Teiid
teiid.io
- Free plan
- Linux
- API
- Self-hosted
What Teiid is
Teiid is an open-source data virtualization project that gives applications a uniform API for accessing information from multiple sources. It acts as a gateway rather than storing the data. Its virtual databases bring components from different sources behind one interface, letting applications join or union results as if they came from a single source. Access methods include JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can also be created. The query optimizer uses information about source capabilities to push work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift; Spring Boot is not as feature-full as WildFly. Connecting to sources commonly requires third-party drivers that are not included. Teiid is free, and the majority of its code has been under Apache License 2.0 starting with version 10.0. The project warns it may not suit big-data, LDAP-style virtualization, or primarily streaming workloads. Teiid Designer is deprecated, with no further releases expected.
Who it suits
Teiid may suit Java developers integrating multiple enterprise data sources, especially those targeting OpenShift. It may be a poor fit for big-data, LDAP-style virtualization, or primarily streaming workloads.
Good to know, and what to watch
- Provides JDBC, ODBC, OData, and REST access.
- Applications can join data from dissimilar sources.
- Built-in translators cover several databases and files.
- Runs with WildFly, Spring Boot, embedded Java, and OpenShift.
- Open source and free.
- Source connections commonly need third-party drivers not included.
- Spring Boot is less feature-full than WildFly.
- The project may not suit big-data or primarily streaming workloads.
- Teiid Designer is deprecated.
Plans
Every plan and priceTeiid
Open source
The verdict
Teiid offers a free gateway approach for querying across multiple sources without storing their data. Check runtime fit and source-driver requirements before adopting it, and note that Teiid Designer is deprecated.
What the maker publishes
- Access methods
- Teiid provides JDBC, ODBC, OData, and REST interfaces for accessing data. source
- 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. source
- Client interfaces
- Teiid supports JDBC, ODBC, OData, and REST access to virtualized data. source
- Compatibility
- The WildFly downloads page identifies Teiid 16.0.0 as its latest release and dates its release announcement to December 28, 2020. source
- Connectors
- Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be created. source
- Connectors
- Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can be created. source
- Data handling
- Teiid acts as a data gateway and does not store the data it accesses. source
- Data storage
- Teiid does not store data; it acts as an interface or data gateway to underlying sources. source
- Deployment
- The documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift. source
- Deployment
- The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options. source
- Deprecated tool
- Teiid Designer is deprecated and no further releases are expected. source
- Deprecated tooling
- Teiid Designer is deprecated, and the FAQ says no further releases are expected. source
- Federated queries
- Applications can join and union data from dissimilar sources as if they were one source. source
- Federated queries
- Teiid can join and union data across dissimilar sources so they appear as one source to an application. source
- 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. source
- Optimization
- The engine uses an optimizer and pushes as much query work as possible to the underlying sources. source
- Purpose
- Teiid provides data virtualization that integrates data from multiple sources through a single uniform API. source
- Purpose
- Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. source
- Query optimization
- The engine uses an optimizer and source capability information to push query work to sources where possible. source
- Runtime caveat
- The site says Spring Boot is not yet as feature full as the WildFly runtime. source
- Security
- The FAQ describes Teiid as providing a secure data access layer, and the distributions page says WildFly provides security configuration options. source
- Security
- The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. source
- Source access requirements
- Connecting to sources commonly requires third-party drivers that are not included with Teiid. source
- Support
- The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. source
Checked against the maker's pages on 4 Oct 2026.