Teiid

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...

After a small delay, 7.2 CR1 adds support for converting JSON to XML and creating CSV output via the TEXTAGG aggregate. Numerous fixes have been added from internal testing and excellent user reports. Please let us know if your resolved JIRAs need any additional work before the final release next week. And now is the time to put in enhancement requests for 7.3, which is still slated for the end of the year. The Teiid Team

7.2 Beta1 includes support for non-recursive common table expressions (including pushdown support), improvements to multi-source update logic, refined procedure assignment statement syntax, the session_id system function, and various bug fixes. Give it a try and vote for any issues you want to see in the final release. Time is running out though as we expect a candidate release early next week. The Teiid Team

7.2 Alpha2 includes various bug fixes and adds support for replication of result sets and internal materialization in clustered mode. We also added support for IPv6 network addresses. One major security change in this release is by default Teiid's Admin port is now secure. So if you need to access Admin API from AdminShell or Java classes, before sure to use "mms://" protocol instead of "mm://". Give it a try and vote for any issues you want to see in the final release. The Teiid Team

7.2 Alpha 1 is now available. We've been working hard to improve plan caching, internal materialized view performance, and simplify role usage. See the release notes for more. The Teiid Team

Teiid Designer 7.1 is ready for download . This release further solidifies and enables key data access capabilities for the Teiid 7.1 runtime framework. The major features of this release are: Restored Preview Data feature Data Role management in VDB Editor LDAP and Salesforce connection profile contributions compatible with Eclipse Data Tools framework Web Services support through generation of deployable web service War files New DDL into Relational Model importer Support for multiple User Defined Function models Tighter integration of Teiid Designer connection management with Eclipse Data Tools See the release notes for more details. Interested in getting started with data services? Use our Quick Start Guide and you'll be off and running in no time. Thank you. Teiid Designer Team

In this article I will show how to convert XML data into relational form using Teiid using "XMLTABLE" SQL/XML function. XMLTABLE is defined in SQL/XML 2006 specification and is supported by most major databases like Oracle, DB2 etc. XMLTABLE functionality is introduced in Teiid 7.0. If you are already familiar with using this function it is no different in using it in Teiid. Please see this WIKI article for complete information. Generating XML data from the Relational Data: If you need to produce the XML data Teiid provides various SQL/XML functions for that purpose too. Check out this article on the available SQL/XML functions . These are functions are also supported by Teiid. In a future article, we will how show you how to use these SQL/XML functions and create a web service by just using the Teiid Designer and Teiid.