Skip to main content

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

Comments

  1. Great post Ramesh!I was looking for a IBM business partner when I came across your very informative post. Thank you for sharing this with us!

    ReplyDelete

Post a Comment

Popular posts from this blog

Teiid 8.11 Beta1 and 8.10.1 Released

Teiid 8.11 Beta1 is now available from the  downloads  and maven.  Feature highlights since Alpha2 include: TEIID-3434 More caching control over ttls in the result set cache down to the schema/table level. TEIID-3412 MS Access support via the UCanAccess driver. The UCanAccess support is necessary for those running on Java 1.8 as the JDBC ODBC bridge has been removed from the JRE. The waiting continues on EAP 6.4 Alpha1 - it still should be available shortly and should be the platform target for Teiid 8.11 Beta2. Of course, let us know if you find any issues with these early releases.  There's still plenty of time to get fixes into the final release. Teiid 8.10.1 is also available.  It addresses 5 important issues discovered since 8.10 was released: [ TEIID-3409 ] - PostgreSQLExecutionFactory TranslatorProperty annotation in wrong place [ TEIID-3437 ] - Inconsistencies with row count handling [ TEIID-3438 ] - Null value returned from BlobImpl

Tech Tip: Teiid SQL Language MAKEDEP Hint Explained

In this article I will explain what a MAKEDEP hint is, how and when, why it should be used in Teiid. What: MAKEDEP is query hint.  When a query hint is defined in the SQL query it influences the Teiid query planner to optimize the query in a way that is driven by the user. MAKEDEP means "make this as a dependent join". What is a Dependent Join? For example if we have query like: SELECT * FROM X INNER JOIN Y ON X.PK = Y.FK Where the data for X, and Y are coming from two different sources like Oracle and WebService in Teiid, so in relational algebra you can represent above query as Here the result tuples from node X and node Y are being simultaneously fetched by Teiid query engine, then it joins the both the results inside Teiid engine based on the specified X.PK = Y.PK condition and returns the filtered resulted to the user. simple.. Now, what if, if X table has 5 rows and Y table has 100K rows? In order to do the JOIN naively Teiid need sto read all the 5

Teiid Spring Boot 1.7.0 Released

Teiid Spring Boot version 1.7.0 to support Teiid 16.0 has been released. This release is mainly to support the Teiid's latest version.  In this release, the support for OpenAPI code generation based on VDB has been removed as there is no community interest and moreover it was at OpenAPI 2.0, and the industry has moved to 3.0 and beyond. There are no plans to further pursue this feature. VDB maven plugin was also removed, which was intended to be a replacement for the VDB importing feature was to be used when working on OpenShift, however, since it requires the Maven repository and does not completely represent the feature as defined on the WildFly based deployments this is also removed. You can still use the VDB import feature with Teiid Spring Boot, simply define the VDB with your "IMPORT DATABASE" statements and provide the additional files along with the main VDB file. During the start of the application, Teiid Spring Boot will load all the necessary DDL files for the