Teiid
Teiid is a free, open-source data virtualization project that gives applications a uniform way to access information across multiple sources.
What Teiid is
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.
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.
Watch out
- 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.
Who it suits
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.
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.
Plans and prices
From Teiid's own pricing page, checked 4 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Teiid | Free | Open-source data virtualization project · no commercial plans or prices listed |
The facts
Each one read from Teiid's own pages, with the date it was checked.
What it does
- Access methods
- Teiid provides JDBC, ODBC, OData, and REST interfaces for accessing data.checked 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.checked 4 Oct 2026
- Client interfaces
- Teiid supports JDBC, ODBC, OData, and REST access to virtualized data.checked 3 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.checked 4 Oct 2026
- Connectors
- Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can be created.checked 4 Oct 2026
- Data handling
- Teiid acts as a data gateway and does not store the data it accesses.checked 4 Oct 2026
- Data storage
- Teiid does not store data; it acts as an interface or data gateway to underlying sources.checked 3 Oct 2026
- Deployment
- The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options.checked 4 Oct 2026
- Deprecated tool
- Teiid Designer is deprecated and no further releases are expected.checked 3 Oct 2026
- Deprecated tooling
- Teiid Designer is deprecated, and the FAQ says no further releases are expected.checked 4 Oct 2026
- Federated queries
- Teiid can join and union data across dissimilar sources so they appear as one source to an application.checked 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.checked 4 Oct 2026
- Optimization
- The engine uses an optimizer and pushes as much query work as possible to the underlying sources.checked 4 Oct 2026
- Purpose
- Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API.checked 4 Oct 2026
- Query optimization
- The engine uses an optimizer and source capability information to push query work to sources where possible.checked 3 Oct 2026
- Runtime caveat
- The site says Spring Boot is not yet as feature full as the WildFly runtime.checked 4 Oct 2026
- Security
- The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies.checked 4 Oct 2026
- Source access requirements
- Connecting to sources commonly requires third-party drivers that are not included with Teiid.checked 3 Oct 2026
- Support
- The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers.checked 4 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.checked 3 Oct 2026
- Virtual databases
- A virtual database combines components from multiple sources behind a single uniform API.checked 3 Oct 2026
- Who it is for
- The FAQ identifies Java developers integrating multiple enterprise data sources, especially those targeting OpenShift, as likely users.checked 3 Oct 2026
- Workload limitation
- The FAQ says Teiid may not be effective for big data workloads, LDAP-style virtualization, or primarily streaming workloads.checked 3 Oct 2026
Alternatives to Teiid
- 1
Stardog
Free planAndroidiOSWebAPI7.7Free plan - 2
Starburst Galaxy
Free planWebAPILinux7.1Free plan - 3
Apache Drill
Free planAPILinuxmacOSSelf-hosted6.7Free plan - 4
Denodo Platform
Free planWebAPILinuxSelf-hosted6.7Free plan - 5
Enterprise Enabler
WebAPILinuxmacOS6.7From $2.17 a month - 6
QoreDB
Free planLinuxmacOSWindows6.7From €99 a year