Monday, April 13, 2015

Teiid 8.11 Alpha2 Released

Teiid 8.11 Alpha2 is now available from the downloads and maven.  Feature highlights since Alpha2 include:
  • TEIID-3393 Embedded AdminApi is now available from EmbeddedServer.getAdmin.
  • TEIID-3270 Virtual Functions can not be defined with procedure syntax.
EAP 6.4 Alpha1 should be available shortly and should be the platform target for Teiid 8.11 Beta2.

Expect an 8.10.1 release around the same time as 8.11 Beta2.  This will address important issues with 8.10 found after the release.

Thanks again for all the community support.  There has been a rash of spam attacks against the forums of late, so please be patient if you encounter any issues with posting.


Red Hat Taste of Training - Managing Virtual Datab...

A short video introduction to managing DV through the web console - Eric D. Schabell: Red Hat Taste of Training - Managing Virtual Datab...

Friday, March 27, 2015

OReva - Fork of OData4J library

Teiid community depends upon OData4J for its V2 implementation of the OData protocol. We see that there has been not much activity in OData4J project for last 2 years, so we consider this is project is effectively dead by all means. However, Teiid community still on hook to support our OData V2 implementation for little while longer (I see at least 2 yrs), for that reason we have forked this project and calling it "OREVA".

I have somewhat simplified the offering by removing the JDBC and JPA as we do not use those modules, but rest of core protocol is intact. We will try to keep it up with any bug fixes and maintenance. So, if you are wanting to submit a patch or work on some enhancements you can always come and talk to us,  patches are Welcome.

Here is the fork   If there is enough interest form OData4J remaining community, I do not mind moving this to different GitHub organization other than Teiid. If you find a issue, use  for now we are using Teiid's issues system.

I also would like to thank John Spurlock for his all his contributions towards OData4J, Thank you. It is a very good OData framework

Thank you.


Teiid 8.11 Alpha1 Released

After a two week delay we're ready to release 8.11 Alpha1 - now available from the downloads and maven.  Feature highlights include:
  • TEIID-3372 Multiple metadata - elements can now be used to configure a vdb.
  • TEIID-3369 Custom query rewrite - via a configurable PreParser.
  • TEIID-3389 Kerberos Delegation JDBC driver can now participate in kerberos delegation based authentication
  • TEIID-3390 SQL/XML improvements in performance and disk utilization.
  • TEIID-3362 ARRAYITERATE system procedure for iterating over an array.
Other things of note:
EAP 6.4 Alpha1 is still not quite properly available in the community - which is the primary reason for our delay. We'll continue to work with them to get so that we can retarget 8.11 to 6.4 as early as possible.

Progress with Olingo has slowed. Their community may not get to a final release in a timely fashion and they have slowed in working with Ramesh on patches.

We now have our own fork of OData4j, which will give us a proper community place for patches and other work -

Thanks for all the community efforts. We have a pending contribution of Redis connectivity from Devin Pinkston and of course have been working hard to address any issues found post 8.10.


Sunday, March 22, 2015

Authenticating datasources with LDAP or Kerberos in Amazon AWS

This blog is mainly to showcase one of the community success story with Teiid and Amazon AWS. The need for our community user Ben Kibler was to provide data sources in AWS be participating in Kerberos authentication. Not only participating, he wanted to provide a consistent usage and access pattern, and a light weight integration layer  for these data sources.

He choose Teiid embedded for this purpose, and provided an extension to hook Auth services back into their corporate Active Directory.  With that his applications can participate in kerberos auth with Teiid, and then same token will be delegated to underlying data sources in Amazon AWS. The rest was provided by Teiid.

Read more about it and find the supporting code at

We love to here about your success stories on Teiid. Also, if something is not working for you as you expect, then come engage us in a discussion, together we can solve the issue the OSS way!

Thank You BenK.


Tuesday, March 10, 2015

Teiid Embedded Examples

With the revolution of underlying infrastructure transformation, Cloud based platform is popular, and Micro based service is the latest trends.

Teiid Embedded is a light-weight version of Teiid, The Embedded contains almost all Teiid features without heavy EE Container involve, it supply a feasible and convenient way to build Micro service to Cloud.

Start from 8.11.0.Alpha1, Teiid contains a series embedded examples:
  • embedded-portfolio - how to federate data from a relational data source, a text file-based data source           
  • cassandra-as-a-datasourse - using the Cassandra Translator to access table in Cassandra
  • excel-as-a-datasource - using Excel Translator query Excel file with JDBC
  • generic-soap - using the WS Translator to call a generic soap service.
  • hbase-as-a-datasource - using the HBase Translator with Phoenix Data Source to access data in HBase
  • ldap-as-a-datasource - using the ldap Translator to access data in OpenLDAP Server
  • mongodb-as-a-datasource - using the MongoDB Translator to access data in mongodb
  • webservices-as-a-datasource - using the WS Translator to call a REST web services and transform the web service results into relational results
Please feel free to take a look at about examples, any feedback we will appreciated.


Monday, March 9, 2015

Welcoming the Komodo dragon

Komodo dragon
noun Ko·mo·do dragon \kə-ˈmō-dō-\
:  an Indonesian monitor lizard (Varanus komodoensis) that is the largest of all known lizards and may attain a length of 10 feet (3 meters) 


For the better part of 13 years, the primary relational modelling support behind the Teiid runtime VDB has been backed by a handful of Eclipse's EMF E-core models. Just the fact of using the "E-core" sends shivers down my spine, but it's served it's purpose for over a decade. Unfortunately, as we move forward with Teiid runtime improvements, it's become apparent that sticking with EMF (and maybe Eclipse) has become a roadblock to implementing new and more robust modelling concepts.

So, over the past year, the Teiid Designer team has been gearing up to remove the burdens of that Eclipse framework and embracing the simplicity of traditional DB terminology. In particular DDL. This initiative has been code-named Komodo as a reference to both it's Teiid (Teiidae) lineage and to the awesome power of this largest of all lizards.
In a nutshell, we're utilizing a design-time Modeshape/JCR repository for managing and persisting our design-time metadata (VDB, DDL, etc...) which allows consistent import/export of runtime metadata.

Here's a link to our on-going Komodo project plan:

Also check out a recent Komodo status presentation dated Feb 15, 2015.  Comments and suggestions are most welcome!!

So expect some buzz on this channel in the coming months. We're bringing the Komodo Engine on-line as we speak and will hopefully have initial UI prototypes to play with in a few weeks.

Barry LaFond
Teiid Designer Project