Teiid

Visit site Alternatives

Score6.9

Rank#8 of 25

PriceFree

Free planYes

Runs onAPI, Linux, Self-hosted

Summary

Teiid is a free, open-source data virtualization project that gives applications a uniform way to access information across multiple sources. It acts as a gateway rather than storing the data, and its virtual databases can let applications join or combine results from different sources. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; users can also create custom translators. An optimizer uses information about source capabilities to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, although Spring Boot is described as less feature-complete than WildFly. Connecting to sources commonly requires third-party drivers that are not included. Teiid may not suit big-data, LDAP-style virtualization, or primarily streaming workloads. Teiid Designer is deprecated, with no further releases expected.

Who it is for

Teiid suits Java developers integrating multiple enterprise data sources, particularly those targeting OpenShift. It may be a poor fit for big-data, LDAP-style virtualization, or primarily streaming workloads.

What is good

Free and open source.
Offers JDBC, ODBC, OData, and REST access.
Can combine data across dissimilar sources.
Includes translators for several databases and files.
Can push query work to underlying sources.

What to know first

Source connections commonly need excluded third-party drivers.
Spring Boot is less feature-complete than WildFly.
May not suit big-data or primarily streaming workloads.
Teiid Designer is deprecated.

Verdict

Teiid provides a gateway for querying across multiple data sources through familiar interfaces. Check its workload limitations and driver requirements against your environment before choosing it.

Teiid plans and pricing

All plans

Teiid Free Open-source data virtualization project · no commercial plans or prices listed teiid.io · 4 Oct 2026

Compared on query engine software

Cloud hosted: Yesteiid.io
Self-hosted: Yesteiid.io
SQL querying: Yesteiid.io
Query result cache: Yesteiid.io
Row-level security: Yesteiid.io
API access: Yesteiid.io

Facts

Purpose: Teiid provides data virtualization that integrates data from multiple sources through a single uniform API.teiid.io · 3 Oct 2026
Data storage: Teiid does not store data; it acts as an interface or data gateway to underlying sources.teiid.io · 3 Oct 2026
Client interfaces: Teiid supports JDBC, ODBC, OData, and REST access to virtualized data.teiid.io · 3 Oct 2026
Federated queries: Applications can join and union data from dissimilar sources as if they were one source.teiid.io · 3 Oct 2026
Virtual databases: A virtual database combines components from multiple sources behind a single uniform API.teiid.io · 3 Oct 2026
Connectors: Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be created.teiid.io · 3 Oct 2026
Query optimization: The engine uses an optimizer and source capability information to push query work to sources where possible.teiid.io · 3 Oct 2026
Deployment: The documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift.teiid.io · 3 Oct 2026
Security: The FAQ describes Teiid as providing a secure data access layer, and the distributions page says WildFly provides security configuration options.teiid.io · 3 Oct 2026
Source access requirements: Connecting to sources commonly requires third-party drivers that are not included with Teiid.teiid.io · 3 Oct 2026
Who it is for: The FAQ identifies Java developers integrating multiple enterprise data sources, especially those targeting OpenShift, as likely users.teiid.io · 3 Oct 2026
Workload limitation: The FAQ says Teiid may not be effective for big data workloads, LDAP-style virtualization, or primarily streaming workloads.teiid.io · 3 Oct 2026
Deprecated tool: Teiid Designer is deprecated and no further releases are expected.teiid.io · 3 Oct 2026
Support and community: The site directs users to the Teiid community for chat and identifies the project as open source under the Red Hat umbrella.teiid.io · 3 Oct 2026
Access methods: Teiid provides JDBC, ODBC, OData, and REST interfaces for accessing data.teiid.io · 4 Oct 2026
Data handling: Teiid acts as a data gateway and does not store the data it accesses.teiid.io · 4 Oct 2026
Optimization: The engine uses an optimizer and pushes as much query work as possible to the underlying sources.teiid.io · 4 Oct 2026
Runtime caveat: The site says Spring Boot is not yet as feature full as the WildFly runtime.teiid.io · 4 Oct 2026
Compatibility: The WildFly downloads page identifies Teiid 16.0.0 as its latest release and dates its release announcement to December 28, 2020.teiid.io · 4 Oct 2026
License: The community page says that starting with Teiid 10.0, the majority of Teiid and related project code is under the Apache License 2.0.teiid.io · 4 Oct 2026
Support: The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers.teiid.io · 4 Oct 2026
Audience: The FAQ identifies Java developers integrating multiple enterprise data sources as the main users and says big-data, LDAP-style, and primarily streaming workloads may not be a good fit.teiid.io · 4 Oct 2026
Deprecated tooling: Teiid Designer is deprecated, and the FAQ says no further releases are expected.teiid.io · 4 Oct 2026