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

Monday, March 2, 2015

Teiid 8.10 Final Released

The Teiid community is excited to announce yet another perfectly time boxed release of its Data Virtualization software - version 8.10. Overall we resolved about 113 JIRA issues (features, enhancements, bugs) in this release. You can download from

A special shout out thank you goes to community member Tom Arnold and his great contributions to Geospatial support in Teiid.

The top highlights are
  • TEIID-3192 Salesforce Connectivity - connectivity was converted to the partner api provided by Salesforce rather than utilizing CXF. Please log an issue if you were utilizing features from the CXF config.
  • TEIID-3046 Recursive Common Table Expression - engine and push down support was added.
  • TEIID-3163 TEIID-3167 Text Table Enhancements - to support a general no trim option and to use a different row delimiter.
  • 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
  • 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.
  • TEIID-3043 Docker Image - can now be produced by the build.
  • TEIID-2694 REST Service - Generated REST web services now support larger binary payloads.
As always it would not have been possible without community members Bram Gadeyne, Devin Pinkston, Ivan Chan, Luca Gioppo, Madhu Garimilla, Mark Twak, Michal Warecki, Nicholas D, Rakesh Bulguri, Salvatore R, Sanjeev Gour, Shiveeta Mattoo, Tu Nguyan for their contributions. Thank you.

This release we have also release Docker Image for Teiid. Be sure to play with it and let us what you think.

End of one release means start of another yet another release 8.11. If you are using Teiid and want some features or want to contribute towards features come talk to us in Teiid Forums.

If you are thinking about production support, look into Redhat Data Virtualization.  You can also download a free developer version of upcoming DV 6.1.0 version there.

Thank you

Steve & Ramesh..