Thursday, February 19, 2015

Teiid 8.10 CR2 Released

We found a small kitting issue with 8.10 CR1, and thus we are releasing a 8.10 CR2 today. After CR1, we fixed about ~10 bugs that have identified by the community, so thank for that.

Download at

  • One feature that has been added is "Nested Table Support" in the MongoDB, where one can define multiple related tables with relationships and produce a single document on the MongoDB. This is will co-locate the data and makes the queries execute faster when using joins between related tables.
  • Teiid Docker Image is also being uploaded to DockerHub

We will be branching the Teiid GIT repo for 8.10 Final, and start working on 8.11 today or tomorrow. If no serious issues found, we expect 8.10.Final by the end of next week. So, get the latest CR2 and verify your usecases before the final is released to ensure the continuity.

8.11 is shaping up, it is time for you to speak up and let us know what features you are most interested in, let us know or vote it up in JIRA.


Ramesh & Steve.

Thursday, February 12, 2015

Teiid 8.10 CR1

Teiid 8.10 CR1 is available from the downloads and maven.  Feature highlights since Beta2 include:
  • TEIID-3043 Docker Image - can now be produced by the build.
The geospatial feature continues to evolve. We'll now read geometry values from Oracle, Postgresql/Postgis, and MySQL - including their SRID's. There are also now 18 system functions.

Ideally the final release should be ready by the 20th, but that will of course depend upon any issues that still need to be addressed.

Work on Teiid 8.11 is expected to start sometime next week, so be sure to let us know if there are any issues that you would like to get in.


Saturday, January 31, 2015

Teiid on top of Apache HBase

If you want to access HBase data through JDBC, or integrate/model HBase Data using Teiid/Teiid Designer, please read for an example.

This  feature will be available in Teiid starting from 8.10.Beta2 release.

Thursday, January 29, 2015

Teiid 8.10 Beta2

Teiid 8.10 Beta2 is available from the downloads and maven.  We've continued to tackle issues and refine the work from Beta1.  We have now addressed over 80 issues and are making significant progress on geospatial support.

The 8.10 final is still on track for mid-February.  Now that EAP 6.4 Alpha is available, it will be the target for 8.11 development.

Let us know if you experience any issues as there is plenty of time to get them addressed for CR1.


Tuesday, January 13, 2015

Teiid 8.10 Beta1

After the year end slowdown, Teiid 8.10 Beta1 is available from the downloads and maven.  Feature highlights since Alpha2 include:
  • TEIID-2384 Geospatial Support - contributed by Tom Arnold. Adds a geometry type and several functions. See the reference for more.
  • TEIID-2816 Hbase Support - based upon the Phoenix JDBC Drirver.
We expect both of these features to evolve a little more before the final release and documentation is also pending.  Ideally we'll have a blog or two to cover the geospatial topic.

We should be back on track to have pre-releases every two weeks, so expect a Beta2 before the end of the month and a final by mid-February.  It has been determined that we'll skip the Wildfly 8 series in favor of aligning with Wildfly 9 for Teiid 9.  So we'll begin that effort sometime after the Wildfly team hits CR1.


Friday, December 19, 2014

Teiid 8.10 Alpha2

Teiid 8.10 Alpha2 is now available from the downloads and maven.  Feature highlights include:
  • TEIID-991 SybaseIQ Translator - for use with SybaseIQ 15.1 and later.
  • TEIID-2882 PrestoDB Translator - for use with PrestoDB 0.85 and later.
  • TEIID-1091 Additional SQL/XML Support - XMLEXISTS, XMLTEXT, and XMLCAST were added.
  • TEIID-3216 Update Support for Google Spreadsheets
Ramesh also introduced logic to support OAuth - Integrating Twitter With OAuth.

There have been several JIRAs to increase compatibility including quoted set/show variables, temp table on commit clause, (the long overdue) -- single line comment, and set session characteristics for transaction isolation level.

And of course there have been a host of other issues resolved - many of which originated from community users.  Special thanks to Filip Elias for contributing the update support for google spreadsheets.


Thursday, December 18, 2014

Expose Twitter data in Teiid, using OAuth Authorization

If you want to access Twitter data or any other REST web service (google, facebook etc) secured by OAuth 1.0A or OAuth 2.0 authentication schemes using Teiid, please read this article for an example.

This feature will be available in Teiid starting from 8.10.Alpha2 release.