Wednesday, May 2, 2012

Teiid 8.0 Final Released, brings Data Virtualization to JBoss AS 7.x

The Teiid Team is proud to announce the availability of Teiid 8.0 Final for JBoss AS 7.1.1.

A major effort with this release was moving from JBoss AS 5.1.0 platform to the new JBoss AS 7.1.1 platform.  We super exited with the move as JBoss AS7 offers:
  • Blazing fast start-up, deployment and configuration
  • Modular design, with powerful class loader
  • Exceptionally light weight resource consuption
  • Simple, centralized and consistent configuration
  • Standards compliance
  • Simplified Clustering
  • Infinispan support
  • Easy testing
Read more about JBoss AS 7.1.1 here. This means all the above features/services are also applicable to Teiid. That is not all, we have advanced Teiid 8 with powerful features, performance enhancements, and query optimizations. The Teiid 8 feature list includes:
  • 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.
Teiid 8.0 still lacks an administrative console GUI web application.  We are working to bring you that in the Teiid 8.1 release. Meanwhile JBoss CLI tooling can be used for any configuration purposes.

Also, a fully compatible Teiid Designer for Teiid 8.0 is still in works. Until one is available, use Teiid Designer 7.7 to develop your VDBs - however you will not be able be able to administer/preview a Teiid 8.0 server.

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

Thank you,

The Teiid Team