Skip to content
SPECIFICTION
Get listed

Teiid

teiid.io

Free plan LinuxAPISelf-hosted
Visit teiid.io
Spec score 8.0 #8 of 24 in Data Federation Software

What it is

Teiid is a free, open-source data virtualization project that gives applications a uniform way to query multiple underlying sources. It works as a gateway rather than storing the data, and virtual databases can present separate sources together so applications can join or union their results. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be made. Its optimizer uses source capability information to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, with Spring Boot noted as less feature-complete than WildFly. Teiid is aimed especially at Java developers integrating enterprise data sources. Connecting to sources commonly requires third-party drivers that are not included. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit. Teiid Designer is deprecated, with no further releases expected.

Spec sheet

Purpose
Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API.Read 4 Oct 2026 · teiid.io
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.Read 4 Oct 2026 · teiid.io
Deployment
The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options.Read 4 Oct 2026 · teiid.io
Security
The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies.Read 4 Oct 2026 · teiid.io
Support
The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers.Read 4 Oct 2026 · teiid.io
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.Read 4 Oct 2026 · teiid.io
Access methods
Teiid provides JDBC, ODBC, OData, and REST interfaces for accessing data.Read 4 Oct 2026 · teiid.io
Client interfaces
Teiid supports JDBC, ODBC, OData, and REST access to virtualized data.Read 3 Oct 2026 · teiid.io
Compatibility
The WildFly downloads page identifies Teiid 16.0.0 as its latest release and dates its release announcement to December 28, 2020.Read 4 Oct 2026 · teiid.io
Connectors
Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can be created.Read 4 Oct 2026 · teiid.io
Data handling
Teiid acts as a data gateway and does not store the data it accesses.Read 4 Oct 2026 · teiid.io
Data storage
Teiid does not store data; it acts as an interface or data gateway to underlying sources.Read 3 Oct 2026 · teiid.io
Deprecated tool
Teiid Designer is deprecated and no further releases are expected.Read 3 Oct 2026 · teiid.io
Deprecated tooling
Teiid Designer is deprecated, and the FAQ says no further releases are expected.Read 4 Oct 2026 · teiid.io
Federated queries
Teiid can join and union data across dissimilar sources so they appear as one source to an application.Read 4 Oct 2026 · teiid.io
Optimization
The engine uses an optimizer and pushes as much query work as possible to the underlying sources.Read 4 Oct 2026 · teiid.io
Query optimization
The engine uses an optimizer and source capability information to push query work to sources where possible.Read 3 Oct 2026 · teiid.io
Runtime caveat
The site says Spring Boot is not yet as feature full as the WildFly runtime.Read 4 Oct 2026 · teiid.io
Source access requirements
Connecting to sources commonly requires third-party drivers that are not included with Teiid.Read 3 Oct 2026 · teiid.io
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.Read 3 Oct 2026 · teiid.io
Virtual databases
A virtual database combines components from multiple sources behind a single uniform API.Read 3 Oct 2026 · teiid.io
Who it is for
The FAQ identifies Java developers integrating multiple enterprise data sources, especially those targeting OpenShift, as likely users.Read 3 Oct 2026 · teiid.io
Workload limitation
The FAQ says Teiid may not be effective for big data workloads, LDAP-style virtualization, or primarily streaming workloads.Read 3 Oct 2026 · teiid.io

Plans and prices

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

Every Teiid plan and price →

Strong points and limits

Strong points

  • Free and open source.
  • Provides JDBC, ODBC, OData, and REST access.
  • Supports joins and unions across dissimilar sources.
  • Includes translators for several databases and files.
  • Can run on WildFly, Spring Boot, embedded Java, and OpenShift.

Limits

  • Source drivers commonly must be obtained separately.
  • Spring Boot is less feature-complete than WildFly.
  • Not recommended for some big-data or streaming workloads.
  • Teiid Designer is deprecated.

Who it suits

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

Verdict

Teiid offers a gateway approach to querying diverse sources through familiar interfaces, with several documented runtimes. Check driver needs and workload fit before choosing it.

Where Specifiction places it

Alternatives to TeiidAll alternatives →