Red Hat
May 1, 2012
by Ramesh
The Teiid team is proud to announce the availability of the Teiid 8.0 Final release that is based on JBoss AS 7.1.1 .

This release marks major effort in moving the Teiid environment from JBoss AS 5.1.0 platform to new  JBoss AS 7.1.1 platform.  We super exited with move as JBoss AS7 brings in
  • Blazing fast start-up, deployment and configuration
  • Modular design, with powerful class loader
  • Exceptionally light weight
  • Simple, centralized and consistent configuration
  • Standards compliant
  • Simplified Clustering
  • Infinispan support
  • Easily testable
Read more about JBoss AS 7.1.1 here . This means all the above features/services are also applicable to Teiid, as Teiid extends the JBoss AS subsystem and hosted on this platform. That is not all, that is just the beginning for Teiid 8. We have further advanced Teiid 8 with more powerful features, performance enhancements and query optimizations. The Teiid 8 feature list include

  • DDL Based View Definitions - Define virtual tables, procedures and functions for Dynamic VDBs using DDL.
  • MetadataRepository - Pluggable metadata facility for any VDB and models inside it.
  • CallableStatement Named Parameters - you can now use CallableStatement named parameter get/set methods.
  • New Translator capabilities
    • translators may indicate which convert functions they support
    • restrict non-join comparisons to only literals.
    • return ReusableExecution instances for processing nodes that issue multiple queries.
    • translators may indicate support for dependent join handling
  • Continuous Asynch Queries to process plans in a streamed window fashion the TeiidStatement/TeiidPreparedStatement methods now take a RequestOptions object to specify continuous mode. See the Client and Developers Guides for more.
  • Texttable selectors - can be used to selectively parse only record lines matching a given selector string. Selectors may also be used for column values to join data from other records positionally.
  • Enhanced Comparison Support - see the Admin Guide more.
    • Comparable LOBs - the system property org.teiid.comparableLobs can be set to use CLOB and BLOB values in comparison/sorting/grouping operations.
    • Padded Comparison - the system property org.teiid.padSpace can be set to effectively right pad strings to the same length for comparison.
    • Collation Support - the system property org.teiid.collationLocale can be set to use a different collation than the Java UTF-16 default.
  • VARBINARY type support - the Teiid VARBINARY type can now be used to support source BINARY and VARBINARY types.
  • Greenplum Translator - for use with the Greenplum database.
  • Enhanced parse/format pushdown - added more built-in support and extension points for parse/format function pushdown. Added parse/format timestamp handling for SQLServer, Sybase, Oracle, and PostgreSQL.
  • User Defined Aggregates - user defined aggregate functions can be defined via extension metadata, DDL, or connector metadata.
  • SET PAYLOAD statement - SET PAYLOAD can be used to set a name value pair on a session scoped payload that will be sent with requests.
  • ENCRYPT REQUESTS - encryptRequests may be used as a connection/datasource property when not using SSL to indicate that request messages and any associated payload should be encrypted.

Couple things that Teiid is still lacking in Teiid 8.0 is administrative console GUI web application, we are working to bring you that in the Teiid 8.1 release. Meanwhile JBoss CLI tool can be used for any configuration purposes.

Also, a fully compatible Teiid Designer that works with Teiid 8.0 is still in works. Users can use Teiid Designer 7.7 and build VDBs with this version, however they will not able to use the "preview" feature offered by Designer.

Download it , take it for a spin and let us know what you think.

Thank you.

Teiid Team
Original Post