Does anyone have experience using Teiid? Is it as good as it claims?

Question

Recently I have been reading a bit about Teiid:

Teiid is a data virtualization system that allows applications to use data from multiple, heterogenous data stores.

Teiid is comprised of tools, components and services for creating and executing bi-directional data services. Through abstraction and federation, data is accessed and integrated in real-time across distributed data sources without copying or otherwise moving data from its system of record.

It seems very interesting, and could potentially remove a fair amount of complexity from some applications at my place of work.

However, it seems pretty new, and I have never heard of it until recently, so I was wondering:

Does anyone have firsthand experience with Teiid?

Could you comment on how effective / stable / performant Teiid is? Based on your experience, is it ready for prime time?

Answer 1

Teiid actually does do the things claimed on the web site. Quick history...

MetaMatrix was a company--and product--that was around since the late 1990's. The MetaMatrix product is used by corporations and some government agencies. Used with a great deal of success and satisfaction.

In 2007, Red Hat acquired MetaMatrix. A goal was to change the MetaMatrix product from a proprietary product to open source. Teiid is the result. (It's the community version.)

While Teiid is new (converting from proprietary to open source is not for the faint of heart), it has been around for quite a while. So, if you're interesting in trying Teiid to see if it's right for your situation, download it and give it a shot! If you run into problems, use the forums. We'll be happy to help out.

(I've been part of the MetaMatrix/Teiid team since 2001.)

Answer 2

I've just had a play with Teiid and very quickly was able to integrate it with Pentaho and run a federated query over Oracle and Salesforce webservice.

At this stage it looks amazing. However I havent got indepth into it yet. But potentially for us it will allow us to expose our salesforce data to adhoc reporting users, as well as being able to provide richer reports, without having to sync the data across into Oracle. Fantastic!

If you do look at it, I strongly reccomend using the 6.1 versions which are about to be released as they fix a lot of usability issues. I've documented my findings on the Pentaho wiki.