A JBoss Project
Red Hat

Feature Matrix


Feature/capabilities by product

Feature/Capability Teiid Embedded Teiid Server + Designer JBoss Enterprise Data Services Platform
Teiid query processing
  • Retrieve data from multiple sources with single query
  • Consolidated results that span multiple sources
Yes Yes Yes
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.
Yes Yes Yes
Support for a wide range of enterprise data sources Data Sources Data Sources Data Sources
SQL access to SQL-based and non-SQL-based data sources Yes Yes Yes
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
Yes Yes Yes
JDBC access to data across multiple sources
JDBC access to runtime metadata describing sources
Yes (no remote access) Yes Yes
ODBC access to data across multiple sources
ODBC access to runtime metadata describing sources
No Yes Yes
SOAP access (HTTP or JMS) to data across multiple sources
SOAP access (HTTP or JMS) to runtime metadata describing sources
No Yes Yes
Logging of all queries and commands processed  * Yes Yes
Distributed transactions and updates  * Yes Yes
Caching of results sets for user queries and individual data source queries  * Yes Yes
Support for materialized views (staging of pre-transformed information in a separate database for rapid access)  * Yes Yes
Caching of lookup tables Yes Yes Yes
Information abstraction Yes Yes Yes
Schema-based XML from non-XML sources   Yes Yes
Exposure of information as Web services   Yes Yes
Extensible architecture Yes Yes Yes
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) Yes Yes
Support Community Community Community 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

Standard Version Standards Body Notes
SQL SQL-92 ANSI, ISO Primary query language used for data access through Teiid and for defining transformations in Teiid Designer.
JDBC 3.0 Sun The 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.
ODBC 3.5 Microsoft  
XA 3.5 The Open Group Defines the semantics for two-phase commits in distributed transactions. Used by Teiid.

Modeling Standards

Standard Version Standards Body Notes
UML 2.0 OMG Used in Teiid Designer for model diagrams.
EMF 2.1 Eclipse Eclipse framework used to define and manipulate MOF-based models.
MOF 1.4 OMG Used to represent model classes and model types.
XMI 2.0 XMI Teiid models are stored in XMI files.

XML Standards

Standard Version Standards Body Notes
XML 1.0 W3C Used to define hierarchical views in Teiid Designer, which can be executed in Teiid and Teiid Server.
XML Schema 1.0 W3C Used to define hierarchical views in Teiid Designer.
XSLT 2.0 W3C A style sheet can be applied to ad-hoc requests executed against XML Views through the Teiid Server
XPath 2.0 W3C Used to define Web services in Teiid Designer
XQuery 1.0 W3C XML Views can be queried using XQuery through JDBC or ODBC APIs

Web Services Standards

Standard Version Standards Body Notes
SOAP 1.1 W3C Web services deployed in Teiid are accessible via standard SOAP, over HTTP and JMS.
WSDL 1.1 W3C Teiid Web services are described using standard WSDL.
UDDI 3.0 OASIS Teiid Web services can be deployed to UDDI registries.
WS-I 1.1 WS-I Organization Ensures interoperability of Teiid Web services with tools and products from other organizations.

Java Standards

Standard Version Standards Body Notes
JDBC 3.0 Sun API 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.
J2EE 1.4 Sun Various J2EE standards used, such as JTA.
Eclipse 3.4.1 Eclipse The application framework upon which Teiid Designer is built.

Protocols

Protocol Version Standards Body Notes
SSL 3.0 Netscape Secure connections.
HTTP 1.1 W3C SOAP connectivity.
back to top