A JBoss Project
Red Hat

Why Teiid?


1. Familiar Interface: JDBC

Teiid has a very familiar interface: JDBC! Every Java developer is familiar with JDBC access to data sources. Now leverage your knowledge of the JDBC standard to access all your data sources.

  • JDBC 4.0 API
  • DML SQL-92 support (with select SQL-99 and later features)
  • Support for standard JDBC scalar functions

2. Familiar Query Language: SQL

Want to query non-SQL sources in the same way you do with SQL sources? With Teiid, you can! You can access data from any types of sources, and interact with those sources using a single flavor of SQL - even if the native sources do not understand SQL!

  • DML SQL-92 support (with select SQL-99 and later features)
  • Issue SQL to any data source -- see currently supported sources
  • Level the data access playing field, using one version of SQL dialect, scalar functions, and datatypes

3. Multiple Sources Look Like One

With Teiid, you can join and union data that resides in very dissimilar data sources. Multiple sources suddenly look like a single source to your application.

  • Joins across data sources
  • Unions across data sources

4. Easy To Deploy

The Teiid query engine is a Java component - it plugs right into your application, like any other Java library. Deployment is simple.


5. Eliminate Hand-coded Data Access Logic

Real applications often access more than one data source. We know that. Teiid technology from MetaMatrix has been in the business of enterprise data integration since 1999. Many of you have built your own frameworks to handle integrating multiple sources, and have realized the difficulty of doing that in a generic manner that performs and scales well under real use conditions. Now you can retire your custom frameworks and hand-coded logic, and use a dedicated query component for all your data access needs. This lets you focus on the logic on top of the data access layer rather than the nuts and bolts of accessing heterogeneous data uniformly.

  • Cheaper - than hand-coding and maintaining hand-coded integration, and re-inventing integration logic on every project
  • Better - than non-optimized integration logic that does not make use of a real query engine
  • Faster - to implement your projects, leveraging the integration logic already built into Teiid, and reusing that logic on other projects

6. Battle Tested - and Improving

You don't want to be a guinea pig for someone's "product" experiments. Don't worry - with Teiid, you won't have to. Teiid is a component form of the query engine that is the heart of the JBoss Enterprise Data Services Platform (JBEDSP), which is used by large commercial organizations, independent software vendors, and many federal agencies, including intelligence agencies responsible for protecting citizens in the U.S. and other countries. These are organizations that cannot and do not play with toys, so you can have confidence that our products have been put through the ringer a number of times.

  • Used by Fortune 500 companies and Government Intel agencies
  • Used by independent software vendors
  • Large data sets, small data sets, data sets with quirky characteristics
  • Relational data, XML data, and data from sources you've never even heard of!

 


7. Optimized

Part of being battle-tested is operating at expected levels of performance in a wide variety of enterprise solutions. Teiid accounts for the unique requirements of integrating information across disparate data sources.

  • Cost-based optimizer
  • Accounts for federating data across heterogeneous systems
  • Caches result sets for user queries and queries to sources

8. Scriptable Integration

Teiid comes with an administrative shell that allows programatic access to administrative features.


9. Works Like a Charm - Fast

Your time is precious - we know that. You can't waste your time investigating every newfangled product and solution marketed to you. With Teiid, you don't have to. In 30 minutes, you can demonstrate to yourself that you can issue federated queries against 2 of your own databases.


10. Tip of the Iceberg

Still not convinced? What if we told you that all this was merely the tip of the iceberg? That's right - there's more! Not only can you do more with the Teiid query engine, but everything you do can be leveraged and extended with the Teiid Server and JBoss Enterprise Data Services Platform.

With Teiid Designer, you get the following additional functionality:

  • Data abstraction through an Eclipse-based modeling tool
    • Relational views - of any type of data
    • XML views of non-XML data (XSD-compliant)
  • Data Services - rapid design and deploy
    • For Web services architectures
    • For general services-oriented architectures (SOAs)

Moving up to the JBoss Enterprise Data Services Platform suite enables you to take advantage of the following enterprise-level features:

  • Extensive connectivity to enterprise sources
    • Support for packaged applications such as SAP
  • Security
    • Authentication and authorization (entitlements)
    • Integration of external authentication/user systems
  • Model management
    • Searchable metadata for dependency and impact analyses
  • Monitoring and administration
    • Enterprise administration and monitoring console
Looking for a fully supported, certified Data Services Platform?



tei·id (TEE-id)

adj.     pertaining to a family of tropical American whip-tailed lizards noted for speed and agility.
n.     a set of open source enterprise information integration tools noted for their ability to rapidly create data services that can quickly adapt to changes in your IT environment.

Blog Posts



back to top