Teiid

Teiid is a free, open-source data virtualization project that gives applications a uniform interface to multiple data sources. It acts as a gateway and does not store the data it accesses. Applications can join or union information from different sources as though they were one, using virtual databases behind a single API. Access methods include JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be created. 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, though Spring Boot is described as less feature-full than WildFly. Connecting to sources commonly requires third-party drivers that are not included. The FAQ identifies Java developers integrating enterprise sources, especially those targeting OpenShift, as likely users. Teiid may not suit big-data, LDAP-style virtualization, or primarily streaming workloads. Teiid Designer is deprecated, with no further releases expected.

Teiid provides a free gateway for querying across data sources through familiar interfaces. Check the workload caveats and driver requirements, and note that Teiid Designer is deprecated.

Teiid is aimed at Java developers integrating multiple enterprise data sources, especially those targeting OpenShift. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit.

Teiid is a data virtualization engine for Java developers who need to bring enterprise data sources behind a common access layer. It is best suited to integration workloads where data should stay in its existing systems, not to big-data, LDAP-style, or primarily streaming use.

Its appeal is broad client access without a new data store; the tradeoffs are driver setup and a runtime whose Spring Boot option is less feature-complete than WildFly.

Overview

Teiid combines components from multiple sources into virtual databases, presenting them through a uniform API. Applications can join and union data across otherwise dissimilar systems, while Teiid acts as a gateway rather than keeping another copy of the data.

This is a practical fit when applications need a shared view of existing data without moving it. The optimizer uses source capabilities to push query work down where possible, but performance and query behavior still depend on the underlying sources and what they support.

Key features

Access and federation

JDBC, ODBC, OData, and REST interfaces provide several ways for applications to reach virtualized data. Built-in translators cover Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and teams can create custom translators for other sources. Connecting to sources commonly requires third-party drivers that are not bundled with Teiid, so integration includes driver selection and setup.

Deployment and security

Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift. Spring Boot is not yet as feature-complete as WildFly, making WildFly the stronger choice when runtime capabilities matter. Teiid provides a secure data access layer, and WildFly offers security configuration options.

Teiid supports SQL querying, query-result caching, row-level security, and API access. These capabilities make it more than a simple connector, though teams should match their requirements to the chosen runtime.

Pricing

Teiid: free. It is an open-source project with no commercial plans or prices listed. There is no free trial; the free project is the offering rather than a time-limited evaluation. The community says that, starting with Teiid 10.0, most Teiid and related project code is under the Apache License 2.0.

There are no paid tiers or seat-based plan distinctions to weigh. Support is community-oriented, with chat, Stack Overflow, a legacy forum, GitHub, and project issue trackers among the channels.

Platforms

Teiid supports API access and Linux, and can be self-hosted. Its runtime choices include Spring Boot, WildFly, embedded Java, and OpenShift; the Spring Boot runtime has fewer features than WildFly. The project also describes cloud-hosted availability.

Who it's for

Teiid is aimed chiefly at Java developers integrating multiple enterprise data sources, particularly teams targeting OpenShift. It suits organizations that want applications to query existing systems through one interface and can manage connector drivers and runtime configuration.

Look elsewhere for big-data processing, LDAP-style virtualization, or workloads that are primarily streaming: the project FAQ cautions that Teiid may not be effective for those uses. Teiid Designer is deprecated, with no further releases expected, so it should not be treated as an actively advancing design tool.

Pros and cons

• Pro: Federated joins and unions across different sources let applications work through one virtual database instead of integrating each source separately.
• Pro: JDBC, ODBC, OData, and REST access give teams multiple client paths to the same virtualized data.
• Pro: The optimizer can push query work to sources when their capabilities allow it, and the project is free and open source.
• Con: Source connections commonly need third-party drivers, adding setup and compatibility work.
• Con: Spring Boot is less feature-complete than WildFly, so runtime choice can constrain deployment needs.
• Con: Big-data, LDAP-style, and primarily streaming workloads are poor fits, and Teiid Designer is deprecated.

Alternatives

Query Engine Software, Data Federation Software, and Data Virtualization Software are useful category starting points.

• Comunica is another free, MIT-licensed open-source option if its API, Linux, macOS, self-hosted, web, or Windows platform coverage better suits your deployment.
• Databricks Notebooks is worth considering when a web-based notebook workflow is preferable; its free edition includes one serverless workspace with limited compute size and usage.
• Apache Arrow DataFusion is a free open-source Rust library and CLI for teams that want a library-oriented approach with official source-artifact releases.
• Apache Drill offers free Apache License 2.0 software for embedded or cluster deployment if that packaging better matches the intended use.
• Apache Kylin is a free open-source OLAP engine if an OLAP-focused alternative is the priority.
• Denodo Platform has a free Developer plan with one server, four cores, 50 data products, and 2.5 TB per year, alongside a paid offering, for teams whose needs fit those terms.
• Starburst Enterprise Context Layer provides a free tier for up to three clusters in standard execution mode for ad hoc queries, with a Pro plan also offered.
• Starburst Galaxy provides a free tier for up to three clusters in standard execution mode for ad hoc queries, with a Pro plan also offered.

Verdict

Choose Teiid if you are a Java team that needs to query across enterprise sources through a shared interface while leaving data in place. Its free, open-source model and range of access methods are compelling; driver setup, workload limits, and runtime maturity are the reasons to look elsewhere when your use case falls outside that lane.