Enterprise Enabler vs Teiid

Enterprise Enabler 10 is data integration middleware for connecting IT and business users to data held across different sources. Its transformation engine can federate live data from multiple systems and transform it without staging it in a physical or virtual database. A data catalog provides another way to search within the product, and lineage traces a dataset’s origin, destination, formulas, business rules, and intervening steps. Fast Virtualization uses drag and drop to create virtual models for BI reports, web services, and applications. Data masking and obfuscation control partial or full user views; the product page says these features support GDPR compliance, row-level security, and column-level security. Listed relational integrations include Oracle RDBMS, Microsoft SQL Server, IBM DB2, MySQL, and PostgreSQL. Deployment options include on-premise, cloud, hybrid, and a cloud edition designed to run without extra installation and setup. Stone Bond Technologies offers a no-cost trial, with setup instructions sent by email. AWS Marketplace bundles are billed per hour: EE 10 Bundle A is $2.17 a month for 3 data sources, and Bundle B is $8.50 a month for 12.

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.