Tuesday, August 21, 2012

Teiid 8.1 Final Released, Brings back "embedded" Teiid

The Teiid Team is very excited to announce the availability of Teiid 8.1-Final for JBoss AS 7.1.1.  If you are working with Teiid 8.0, we highly recommend to migrate to 8.1-Final version, as we have about 100 issues resolved along with many new features.

In Teiid 6.x versions, Teiid used to support a "embedded" version, this feature has been removed from 7.x versions, now it has been resurrected  with slightly different purpose.

Teiid Embedded

The main purpose of "Teiid Embedded" is to provide a data virtualization framework with full metadata definitions, query planning and query optimizations across multiple disparate sources with full query features minus any platform specific details such as external vdb deployments, connection management, clustering, authentications etc.  This provides a perfect environment to write a very specific data integration and virtualization needs in any vertical market for your application with out any JBoss AS specific dependencies.

To support the "Teiid Embedded", we have added separate downloadable kit, with a fully functional example.  Go ahead download it, and hack it away. BTW, please let us now if there are any features we can add to improve your usecase.  Also check out blog by Andrily on Teiid Embedded

Below are other notable new features in the Teiid 8.1-Final
  • TEIID-1366 VDB Reuse - a vdb.xml can now declare imported vdbs to reuse metadata. This is a huge feature, will do another blog on this very soon.
  • TEIID-2061 Comparable Object - the system property org.teiid.comparableObject can be set to use OBJECT values in comparison/sorting/grouping operations. It is expected that the object values correctly implement Comparable.compareTo.
  • TEIID-2083 Admin Metadata - you can now retrieve metadata in DDL from the admin api via the getSchema method. This works for Designer defined VDBs too. Design a VDB in Designer and deploy it and ask for its metadata in DDL.
  • TEIID-2105 Improved VDB loading - vdb loading logic was refined to make administration easier. ExecutionFactory now has is/setSourceRequiredForMetadata() to indicate whether a source connection is needed for the getMetadata call.
  • TEIID-1598 Translator Result Caching - translators can interact with the result set caching facility via a CacheDirective. See the Developer's Guide for more.
  • TEIID-2077 Result reuse - the engine will automatically detect if the same source query is used multiple times in a plan and reuse the result rather than issuing another query.
  • TEIID-2113 Misc parser improvements - the parser will now accept the LATERAL keyword for defining a LATERAL join (previously we just used the TABLE keyword), unary negation is now supported e.g. -col1, the FOR keyword is optional for TEXTAGG, and the BNF documentation was dramatically improved.
  • TEIID-2036 Dependent Join Array Comparison - platforms supporting array comparisons can have multi-attribute dependent joins pushed down as array comparisons. Oracle, PG, and H2 translators are already marked as supporting array types.

Due to the time constraints and JBoss AS 7.2 time line, Teiid still does not have administrative console GUI web application.  We believe we will provide a initial version of this console in Teiid 8.2 release.

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.1 server.

Also many thanks all our community users especially Mark Addleman, Andriy Rokhmanov, Manoj Agarwal, Simon Green, Bob Akers, Deshi Xiao, Nabeel Ahmed, Heidi Muehlebach in providing valuable input through their JIRAs and community suggestions.

Guys keep them coming, please help us make Teiid a thriving community that provides solutions in Data Virtualization space.

Thank you.

Ramesh & Steve

Monday, August 13, 2012

Teiid 8.1 CR1 Posted

Teiid 8.1 CR1 is now available for deployment on AS7 7.1.1-Final. We are excited to be closing in on the final release.  New features since Beta1 include: 
  • TEIID-1598 Translator Result Caching - translators can interact with the result set caching facility via a CacheDirective. See the Developer's Guide for more.
  • TEIID-2077 Result reuse - the engine will automatically detect if the same source query is used multiple times in a plan and reuse the result rather than issuing another query.
  • TEIID-2113 Misc parser improvements - the parser will now accept the LATERAL keyword for defining a LATERAL join (previously we just used the TABLE keyword), unary negation is now supported e.g. -col1, the FOR keyword is optional for TEXTAGG, and the BNF documentation was dramatically improved.
  • TEIID-2036 Dependent Join Array Comparison - platforms supporting array comparisons can have multi-attribute dependent joins pushed down as array comparisons. Oracle, PG, and H2 translators are already marked as supporting array types.
We are also closing in on addressing nearly 100 issues, which should ensure a high quality release shortly.

Please ensure that all of your issues have been addressed satisfactorily in the next week and of course log anything new that you find. 

The Teiid Team

Wednesday, August 1, 2012

EDS 5.3 available from Red Hat

If you have been working with Teiid 7.7 version and would like a supported version then look no further than EDS 5.3 from Red Hat.  Red Hat just announced release of their Enterprise Data Services Platform 5.3 which is based on the community projects Teiid and ModeShape and many more.

Some of the key highlights include

  • New data sources: Greenplum, PostgreSQL 9, Apache Hive (tech preview)
  • Performance enhancements
  • New wizards, guides, cheatsheets to enhance tooling usability.
If you are already a subscriber of EDS from Red Hat, then can you download the bits from Red Hat portal now. This also comes with supported tooling JBoss Developer Studio 5.0. Check out new wizards that can help you consume web services or file based sources with ease in EDS.

If you are contemplating on why do you need supported version? well if you are going to deploy a critical application into production environment and need immediate assistance on the product then supported version is the only solution. The product versions are tightly integrated, stable and battle tested on variety of platforms by Red Hat and come with 5 years of support on given version major version. Contact Red Hat sales for more details.

Thank you.

Ramesh..