Teiid

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.

Teiid 7.1 continues the 7.x series with numerous features and performance improvements. Here are some highlights: ODBC Support - Support for ODBC access is now available through PostgreSQL ODBC driver clients. See the Client Developer's Guide for more on how to use Teiid's ODBC access. Native Materialized Tables - views marked as materialized without a target table will be materialized internally by Teiid. Materialized view tables will be indexed by the primary key of the view if present and can be controlled through the expanded cache hint. There are also new system procedures refreshMatView and refreshMatViewRow to refresh materialized view table contents. Expanded Cache Hint - The cache hint can now specify pref_mem to indicate that data should prefer to be held in memory, ttl to indicate the time-to-live, and updatable to indicate that a materialized view with a primary key can be updated by row with the refreshMatViewRow system procedure. SQL Support Added NUL...