Nexus vs Teiid
Nexus
coffingdw.comTeiid
teiid.ioSide by side
| Figure | Nexus | Teiid |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Windows | Yes | — |
| Linux | — | Yes |
| API | — | Yes |
| Self-hosted | — | Yes |
| Plans published | 0 | 1 |
| Spec score · Data Federation Software | 7.7 (#10) | 8.0 (#8) |
| Audience | Nexus Pro is described as a database workstation for business users, IT professionals, DBA teams, and ETL teams. | 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. |
| Federated queries | The Super Join Builder guides users through table joins and builds SQL automatically, including federated queries. | Teiid can join and union data across dissimilar sources so they appear as one source to an application. |
| Purpose | Nexus queries, migrates, and federates data across more than 25 relational database platforms. | Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. |
| Support | The change log directs users to [email protected] for setup help. | The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. |
Plans
In their own words
Teiid
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.