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

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.