Freedom251 › Data Virtualization Software

Teiid

Free plan APILinuxSelf-hosted

What Teiid is

Teiid is a free, open-source data virtualization project for giving applications a uniform API to access multiple data sources. It acts as a gateway rather than storing data, and virtual databases let applications query across different sources as though they were one. Access interfaces include JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, with the option to create custom translators. Its optimizer uses information about source capabilities to push query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift; the site describes Spring Boot 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. The majority of Teiid and related project code is under Apache License 2.0 starting with version 10.0. Teiid Designer is deprecated, with no further releases expected.

Who it suits

Teiid is aimed at Java developers integrating multiple enterprise data sources, especially those targeting OpenShift. Its stated workload cautions make it a less suitable fit for big-data, LDAP-style virtualization, or primarily streaming use.

What it does well

Provides JDBC, ODBC, OData, and REST access
Queries can combine data across different sources
Built-in translators cover several databases and files
Optimizer can push work to underlying sources
Free, open-source project

What to know first

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

Limits

Teiid is free and has no stated plan quotas. Source connections commonly require third-party drivers that are not included; Spring Boot is less feature-complete than WildFly.

Plans

Plan	Billed and limits	Price
Teiid	Open-source data virtualization project · no commercial plans or prices listed	Free

As teiid.io lists them, read 4 Oct 2026. The maker's own page has the final word.

Getting started

Visit https://teiid.io/.
Choose a documented runtime: Spring Boot, WildFly, embedded Java, or OpenShift.
Connect the required data sources and provide any necessary third-party drivers.
Create a virtual database and access it through JDBC, ODBC, OData, or REST.

Verdict

Teiid provides a gateway approach for querying multiple enterprise data sources through familiar interfaces, without storing the data itself. Account for external driver needs and the stated workload limitations; Teiid Designer is no longer being developed.

Questions

Is Teiid free?

Yes. The listed Teiid plan is free, and the project is open source.

Which interfaces can applications use?

Teiid supports JDBC, ODBC, OData, and REST.

Which sources have built-in translators?

Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files. Custom translators can also be created.

Does Teiid store the data it queries?

No. It acts as a gateway to underlying sources rather than storing the data.

Which runtimes are documented?

Spring Boot, WildFly, embedded Java, and OpenShift. Spring Boot is described as less feature-complete than WildFly.

Who makes Teiid, and what license applies?

Teiid is an open-source project under the Red Hat umbrella. Starting with Teiid 10.0, the majority of Teiid and related project code is under Apache License 2.0.

Facts from Teiid's own pages

Access methods: Teiid provides JDBC, ODBC, OData, and REST interfaces for accessing data. · 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
Client interfaces: Teiid supports JDBC, ODBC, OData, and REST access to virtualized data. · teiid.io, 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. · teiid.io, 4 Oct 2026
Connectors: Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can be created. · 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
Data storage: Teiid does not store data; it acts as an interface or data gateway to underlying sources. · teiid.io, 3 Oct 2026
Deployment: The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options. · teiid.io, 4 Oct 2026
Deprecated tool: Teiid Designer is deprecated and no further releases are expected. · teiid.io, 3 Oct 2026
Deprecated tooling: Teiid Designer is deprecated, and the FAQ says no further releases are expected. · teiid.io, 4 Oct 2026
Federated queries: Teiid can join and union data across dissimilar sources so they appear as one source to an application. · 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
Optimization: The engine uses an optimizer and pushes as much query work as possible to the underlying sources. · teiid.io, 4 Oct 2026
Purpose: Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. · teiid.io, 4 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
Runtime caveat: The site says Spring Boot is not yet as feature full as the WildFly runtime. · teiid.io, 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. · teiid.io, 4 Oct 2026
Source access requirements: Connecting to sources commonly requires third-party drivers that are not included with Teiid. · teiid.io, 3 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
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
Virtual databases: A virtual database combines components from multiple sources behind a single uniform API. · 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