Teiid

Are you trying to integrate data from a REST web service with a data in your legacy RDBMS database?  How about data from Excel or CSV file,  JSON,  XML, MongoDB contents? As Java developers we know how to read the data from these sources and how to stitch data together, all it takes some boilerplate code right? How about running some filters on that data, working with data type incompatibilities between data sources like converting a string type to decimal, doing aggregations like grouping the records by certain parameters and finally exposing it as REST service and you got 30 minutes do it? If you have NOT heard about Teiid (t-ee-d) before, this software is exactly what it is designed to do. It has many more features, but let's focus on Data Integration feature. One of the basic features of Teiid is to provide ways to integrate data from multiple disparate sources where it knows how to work with data type incompatibilities and provides a relational data engine that c...

Data integration between multiple disparate sources is now as simple as writing SQL code in your application as if all your schema (tables, views and procedures) from different databases are co-located in a single data source. No, I am not talking horizontal partitioning of your data that have same schema defined in all the databases that some other tools support. You can have segments of data to your liking or the way they were given to you. That not all, you can even add text files to this mix and use them as another source that is participating in data integration. All this is doable with Teiid . All you have to do is to define the "data source(s)" you would like to integrate in a Teiid configuration file and configure Teiid as your JDBC data source in your application and start writing your application, which may be a simple JDBC or Hibernate application. Sounds simple huh? Thanks to a new feature called " Connector Supplied Metadata ", which is being intr...

If you wondering what the heck is Teiid , and what kind of crazy name is this, well Teiid is data lizard, actually it is a "Whip Tail Lizard" and very interesting one too. It is pronounced as "tee-id". Here is definition of it by http://www.thefreedictionary.com The Common Data Lizard (Cnemidophorus datumus) is the only species of whiptail lizard native to all continents. It was once considered a subspecies of the Common DeeBase Whiptail, Cnemidophorus Jdbcus, but was eventually granted full species status due to it's uncanny reliability and availability. It is one of only lizard species known to be embeddogenic. Description The Common Data Lizard grows to between 8 and 12 inches in length. It is typically blue-gray in color, with 5-6 white or orange dots decorating the hind section of the of the body. They are thin bodied, with a long tail. Behavior Like most whiptail lizards, the Common Data Lizard is active, yet stable. They are acute, energetic, and fast mo...

We are very proud to announce a new open source project, " Teiid " under JBoss . org's community of projects. Teiid is a data virtualization system that allows applications to use data from multiple, heterogeneous data stores and provides you with single view of that data. Teiid (pronounced Tee - id) is also a whiptail lizard . Although the Teiid project is new to open source, the Teiid technology has been around for many years under the " MetaMatrix " brand name. Red Hat acquired " MetaMatrix " in April 2007 and committed to open sourcing the technology and Teiid is result of that effort. During this transition time, Teiid has gone though several major updates in its technology SVN migration Projects consolidation, refactoring into manageable components. Use Maven for build system Replacement of transaction framework to " JBoss Transactions" Use of JBoss Cache for caching and clustering needs. Upgrade to Java 1.6 Re-write of Query Pr...