Skip to main content


Showing posts from March, 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  https:/

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 w

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

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 - us

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)  (See )  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.

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