We are pleased to announce Teiid 7.2 with numerous features, improvements, and bug fixes. Here are some highlights: SQL Support Non-Recursive Common Table Expressions - The WITH clause (and associated pushdown) for non-recursive queries is now supported. Explicit Table Syntax - TABLE x can now be used as a shortcut for SELECT * FROM x JSON Support - JSON, which could be obtained through the ws-translator using http calls or other methods, can be converted to XML using the system function jsonToXml. XMLTABLE and other integration logic can then be used on the JSON results. Transaction Statements - JDBC/ODBC now accepts START TRANSACTION, COMMIT, and ROLLBACK statements to control local transactions. Procedure Result Caching - virtual procedure definitions may use a cache hint to cache results in the result set cache. Improved Plan Caching - plans used by internal materialization and stored procedure plans will be automatically cached in the prepare...
Teiid is a Data Virtualization System for your Enterprise, convert the data you have to data you need!