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

Teiid is comprised of tools, components and services for creating and executing bi-directional data access 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.

Query Engine The heart of Teiid is a high-performance query engine that processes relational, XML, XQuery and procedural queries from federated datasources. Features include support for homogeneous schemas, heterogeneous schemas, transactions, and user defined functions.

Embedded An easy-to-use JDBC Driver that can embed the Query Engine in any Java application.

Server

An enterprise ready, scalable, manageable, runtime for the Query Engine that runs inside JBoss AS that provides additional security, fault-tolerance, and administrative features.

Connectors

Teiid includes a rich set of Translators and Resource Adapters that enable access to a variety of sources, including most relational databases, web services, text files, and ldap. Need data from a different source? A custom translators and resource adaptors can easily be developed.

Tools

• Create - Use Teiid Designer to define virtual databases containing views, procedures or even dynamic XML documents. Use Teiid Dashboard Builder to quickly create a dashboard for data visualization.
• Monitor & Manage - Use the Teiid Web Console with just the AS or the Teiid RHQ plugin to control any number of servers.
• Script - Use the Teiid AdminShell to automate administrative and testing tasks.