Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Teiid

teiid.io

  • Free plan
  • Linux
  • API
  • Self-hosted
7.4 Club score Visit teiid.io

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.

Teiid

Free

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.