Teiid

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

7.1 CR2 is now available. This should be the last CR prior to the final release. This CR provides an expanded cache hint to control result set cache and materialized view entries. VDB versioning, which allows multiple VDBs with the same name to be deployed at the same time, is now supported through the use of a file naming convention vdbname.version.vdb - dynamic VDBs may use use the vdb.xml version attribute to denote version. See the release notes in the kit and the JIRAs for more information. More documentation changes will be coming before the release. The Teiid Team

If you are a programmer, chances are that you have written code at least once to read data from a text file to do something with data. Today, I am going to show you how easy it is convert the text contents into a relational Table data using Teiid with out any code. If you are ready parse the Text with Teiid , read about it in this article . In the next blog, I will show you how to convert XML data into a Table, so stay tuned. Thanks Teiid Team.

7.1 CR1 is now available. This release builds on the alpha release with additional fixes and a revamped temp table system. Temporary tables now support atomic update operations and an optional primary key with a clustered index. This greatly improves the performance of temporary tables for comparison, in, like, and order by operations using the index. The final release is drawing nearer. Make sure to try out CR1 to ensure your features and fixes are in. The Teiid Team