Monday, August 30, 2010

Teiid Designer 7.1 Released

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

Wednesday, August 25, 2010

Convert XML data into Relational Table data using Teiid

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.

Tuesday, August 17, 2010

Teiid 7.1 Final Released

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 NULLS FIST/LAST handling - including pushdown support.
    • Added enhanced numeric stat aggregate functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, with pushdown and aggregate decomposition.
    • Added support for the boolean aggregate functions ANY, SOME, EVERY.
    • Added support for using boolean value expression as both criteria and expressions, e.g. "... where boolean_value" or "select x = 1 as boolean_value ...".
    • Changed named procedure syntax to accept param=>value, rather than param=value.
    • Added PRIMARY KEY and the associated index support to temp tables.

  • Parallel Source Queries - reestablished parallel execution of source queries within a query plan along with a prioritized work system to help prevent resource contention.
  • Improved Insert Support - Cross source inserts using a query expression can defer to the source to perform the entire insert atomically with source controlled batching. See maxPreparedInsertBatchSize on any JDBC translator supporting the new InsertWithIterator capability.
  • SHOW Statement - added client handling for the SHOW statement to retrieve query plan information and see parameter values.
  • User Identity - Teiid DataSources in JBossAS connecting to a local Teiid instance can preserve the thread's user identity, rather than requiring a new authentication. See TeiidDataSource.setPassthroughAuthentication.
  • VDB Versioning - The VDB version may be determined by the deployed file name. The expected pattern is .Version.vdb. See the Admin Guide for more on how to use VDB versioning.
See the release notes for more details. Download today, give it try, and let us know what you think and what features you would want in upcoming releases.

The Teiid Team

Thursday, August 12, 2010

7.1 CR2

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

Tuesday, August 10, 2010

Text To Table with Teiid

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.


Teiid Team.

Tuesday, August 3, 2010

7.1 CR1

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