Teiid vs Virtual Data Platform

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.

Virtual Data Platform (VDP) provides live access to enterprise data across systems, networks, and organizations without copying it into a warehouse or lake. Queries run against source systems, and results are combined in an in-memory sandbox for each user. Its low-code Modeler creates reusable Virtual Datasets from Functions, Code Files, Models, and Value Lists. Users can work with the data through Excel, Power BI, Python, R, and MCP-capable AI assistants. Listed integrations include SAP, Snowflake, Salesforce, Workday, SQL Server, SharePoint, ODBC, OData, Oracle, PostgreSQL, BigQuery, and Dynamics 365. Users sign in with Microsoft Entra ID, and queries apply source-system permissions under the requesting user’s identity. The maker describes outbound-only gateway connections, TLS on every connection, encrypted payloads, and results held in memory rather than saved to disk. It describes the service as GDPR-aligned and hosted in the EU on Microsoft Azure, while making no certification claims today. A Dedicated tier offers a dedicated backend cluster and Azure Private Endpoints.