A JBoss Project
Red Hat

This site is no longer current and is for archival purposes only. All relevant content is moving to http://teiid.io

Feature Matrix


Feature/capabilities by product

Feature/CapabilityTeiid EmbeddedTeiid Server + DesignerRed Hat Data Virtualization Platform
Teiid query processing
  • Retrieve data from multiple sources with single query
  • Consolidated results that span multiple sources
YesYesYes
Optimized query planning and processing:
  • Planner designed for federating heterogeneous data
  • Planner uses source metadata for efficient processing
  • Can push processing (joins, scalar functions, subqueries) to data sources to leverage source capabilities
  • Uses knowledge of source native capabilities
  • Accounts for cardinalities of source tables/objects being accessed.
  • Supports user-defined hints to override default planning behavior
  • Dynamically chooses from a variety of join algorithms during planning
  • Integrated buffer management for flowing results through system
  • Supports cursors for all data sources even when data consolidated from many sources.
YesYesYes
Support for a wide range of enterprise data sourcesData SourcesData SourcesData Sources
SQL access to SQL-based and non-SQL-based data sourcesYesYesYes
SQL/Query capabilities:
  • Majority support for SQL-92, partial support for SQL-98
  • Supports use of SQL operations for all sources regardless of native support
  • Supports use of prepared statements
  • Supports execution of stored procedures
  • Supports scalar functions and user-defined functions in query commands
YesYesYes
JDBC access to data across multiple sources
JDBC access to runtime metadata describing sources
YesYesYes
ODBC access to data across multiple sources
ODBC access to runtime metadata describing sources
YesYesYes
SOAP access (HTTP or JMS) to data across multiple sources
SOAP access (HTTP or JMS) to runtime metadata describing sources
NoYesYes
Logging of all queries and commands processed *YesYes
Distributed transactions and updates *YesYes
Caching of results sets for user queries and individual data source queries *YesYes
Support for materialized views (staging of pre-transformed information in a separate database for rapid access) *YesYes
Caching of lookup tablesYesYesYes
Information abstractionYesYesYes
Schema-based XML from non-XML sources YesYes
Exposure of information as Web services YesYes
Extensible architectureYesYesYes
Extensible data source connectivity
  • Data sources accessed through connectors
  • Numerous connectors included
  • Supports development of custom connectors
  • Well-defined API for developing and integrating new connectors including support for connection pooling; access to transaction management system, runtime metadata, security context and logging system).
Yes (sources may require manual configuration)YesYes
SupportCommunityCommunityCommunity and Red Hat

 * features are possible in Embedded, but require additional integration/configuration.


Supported platforms and data sources

Table of source versions and other stuff here


Standards Supported by Teiid

Teiid project components use many standards, and expose information based on standards.


Data Access Standards

StandardVersionStandards BodyNotes
ODatav2, v4OASISRESTful API for exposing and consuming data.
SQLSQL-92 - SQL-2003ANSI, ISOPrimary query language used for data access through Teiid and for defining transformations in Teiid Designer.
JDBC4.0OracleThe primary API for accessing Teiid and the Teiid Server. In addition, JDBC-accessible sources can be imported into Teiid Designer and integrated as data sources into Teiid, using one of the many JDBC connectors provided.
ODBC3.5Microsoft 
XA3.5The Open GroupDefines the semantics for two-phase commits in distributed transactions. Used by Teiid.

Modeling Standards

StandardVersionStandards BodyNotes
UML2.0OMGUsed in Teiid Designer for model diagrams.
EMF2.1EclipseEclipse framework used to define and manipulate MOF-based models.
MOF1.4OMGUsed to represent model classes and model types.
XMI2.0XMITeiid models are stored in XMI files.

XML Standards

StandardVersionStandards BodyNotes
XML1.0W3CUsed to define hierarchical views in Teiid Designer, which can be executed in Teiid and Teiid Server.
XML Schema1.0W3CUsed to define hierarchical views in Teiid Designer.
XSLT2.0W3CA style sheet can be applied to ad-hoc requests executed against XML Views through the Teiid Server
XPath2.0W3CUsed to define Web services in Teiid Designer
XQuery1.0W3CXML Views can be queried using XQuery through JDBC or ODBC APIs

Web Services Standards

StandardVersionStandards BodyNotes
ODatav2, v4OASISRESTful API for exposing and consuming data.
SOAP1.1W3CWeb services deployed in Teiid are accessible via standard SOAP, over HTTP and JMS.
WSDL1.1W3CTeiid Web services are described using standard WSDL.
UDDI3.0OASISTeiid Web services can be deployed to UDDI registries.
WS-I1.1WS-I OrganizationEnsures interoperability of Teiid Web services with tools and products from other organizations.

Java Standards

StandardVersionStandards BodyNotes
JDBC4.0OracleAPI to Teiid and Teiid Server. JDBC connectivity to data sources is also supported, as is importing of metadata information from JDBC sources to define a VDB.
Java EE1.6OracleVarious J2EE standards used, such as JTA.
Eclipse3.4.1EclipseThe application framework upon which Teiid Designer is built.

Protocols

ProtocolVersionStandards BodyNotes
SSL4.0NetscapeSecure connections.
HTTP1.1W3CSOAP connectivity.
back to top