Teiid

Written in Java, Teiid is made of tools, components and services for creating and executing bi-directional data 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. 

Features:

• Teiid Components:
• Server
• Tools
• Connectors
• Embedded
• Query Engine

What is new in this release:

• WITH project minimization - common table expressions will have their project columns minimized.
• geoSpatial support for MongoDB translator
• Increased Insert Performance with sources that support batching or insert with iterator.
• Function Metadata is available through system tables and DatabaseMetaData.
• TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven.
• Performance improvements in grouping and duplicate removal as well as general improvements to memory management.
• Collation aware prevention of order by pushdown via the collationLocale translator property and the org.teiid.requireTeiidCollation system property.
• Usage Information on views and procedures in the system table SYSADMIN.Usage.
• OData4 Support - There is partial support for OData4 using the Apache Olingo project. The OData2 is still intact. We consider this still as experimental feature.

What is new in version 8.8.0:

• Translator for Cloudera's Impala data warehouse has been added. See the reference for more.
• More incremental joins where the whole dataset does not need fully sorted or even read.
• More control over MAKE (NOT) DEP hints via syntax that allows for traversing views. See the reference for more.
• Common Table (WITH) planning improvements such that the usage of a WITH clause in a view or inline view no longer inhibits planning as part of the larger query.
• XMLTable Array Support - XMLTABLE may now return arrays for sequence values.
• Updatable LDAP multi-valued attributes - using an array type mapping, LDAP multi-valued attributes can be inserted/updated.
• System tables for view/procedure definitions - the SYSADMIN Views and StoredProcedures tables can be used to access the definitions of the views/procedures.

What is new in version 8.7.0:

• Amazon SimpleDB support.
• Security Enhancements added support for a grant-all attribute on a role. Also added the ability to specify the security domain for a VDB.
• Apache Solr Translator has been added.
• Pattern based system property substitution has been added to VDB.XML files. Only supported if the DVB is being deployed JBoss EAP.
• Remove unauthorized columns from SELECT * can be enabled via the session property ignore_unauthorized_asterisk.
• More robust GSS-API support. This issue also implements a feature where a user can now define a "security-domain" per VDB. User no longer has to depend upon the transport level authentication.
• Revamped build structure for translators and connectors so that it is easier to package them and deploy them to a Teiid server.
• TEXTTABLE FOR ORDINALITY a FOR ORDINALITY column can now be used with TEXTTABLE.
• Apache POI based Excel connectivity has been added.
• Designer VDB support in Embedded is now available. With a few caveats, Designer .INDEX based vdbs can now be used with Teiid Embedded.
• Translator Properties Translator import, override and extension-metadata properties are can retrieved through Admin API.

What is new in version 8.6.0 Beta 2:

• Added initial conformed table feature to improve planning when identical tables exist in multiple sources.

What is new in version 8.4.0:

• EAP Platform - the deployment platform for Teiid has been changed to EAP 6.1.Alpha1
• Improved sort performance - improved sorts for large data sets especially under heavy load.
• VDB Zips - added the ability to deploy non-Designer based vdb zip artifacts with the ability to place DDL outside of the VDB.xml via the DDL-FILE metadata repository.
• Additional Embedded deployments - xml and zip vdb deployment options are available for Teiid Embedded.
• Session Variables - added the teiid_session_set and teiid_session_get methods to maintain session variables.
• Shared Mat Views - materialized views from imported vdbs will be reused rather than recreated in each importing vdb.
• Automatic DB Version Detection - the JDBC translator database version property in most circumstances will not need to be set manually - see the compatibility note below.
• STRING_AGG Added the string_agg aggregate function for concatenating binary and character strings.

What is new in version 8.4.0 Beta 2:

• EAP Platform - the deployment platform for Teiid has been changed to EAP 6.1.Alpha1
• Improved sort performance - improved sorts for large data sets especially under heavy load.
• VDB Zips - added the ability to deploy non-Designer based vdb zip artifacts with the ability to place DDL outside of the VDB.xml via the DDL-FILE metadata repository.
• Additional Embedded deployments - xml and zip vdb deployment options are available for Teiid Embedded.
• Session Variables - added the teiid_session_set and teiid_session_get methods to maintain session variables.
• Shared Mat Views - materialized views from imported vdbs will be reused rather than recreated in each importing vdb.
• Automatic DB Version Detection - the JDBC translator database version property in most circumstances will not need to be set manually (non-available JDBC sources in partial results mode or source with connection factories that require an ExecutionContext to obtain a connection will require manual setting of the database version metadata property. The affected sources are: db2, derby, oracle, postgresql, sqlserver, sybase, teiid)

What is new in version 8.3.0:

• OData Support
• JSON Support
• Source Temp Tables

What is new in version 8.2.0:

• Teiid Console - A web based administrative console for Teiid.
• Positional procedure defaults - a procedure now may be called positionally with just the leading input parameters as long as all trailing parameters are out or defaultable.
• Streaming Improvements - the ws translator invoke/invokeHttp procedures now accept a "stream"" parameter to indicate that the result should be streamed directly without an intermediate copy being created. Also intermediate document/blob copies are made concurrently with reading to reduce latency.
• Rest Services - when required extension metadata defined on the virtual procedure, a REST based service on that procedure is automatically generated and deployed upon VDB deployment.
• Binary XMLSERIALIZE - XMLSERIALIZE now supports blob/varbinary and the encoding/version and XMLDECLARATION options.
• OBJECTTABLE - was added to extract values from objects using arbitrary scripts. See the Reference for usage.
• Vararg Procedures - variable argument procedures and functions can be created through DDL using the VARIADIC parameter type. See the Reference for usage.
• Function Based Indexes - DDL can be used to specify function based indexes. When used on an internal mat view it will create the corresponding function based index automatically. In any other circumstance, the metadata is not currently used.

What is new in version 8.1.0:

• VDB Reuse
• Comparable Object
• Admin Metadata
• Improved VDB loading
• Translator Result Caching
• Result reuse
• Misc parser improvements
• Dependent Join Array Comparison

What is new in version 8.0:

• Blazing fast start-up, deployment and configuration
• Modular design, with powerful class loader
• Exceptionally light weight resource consuption
• Simple, centralized and consistent configuration
• Standards compliance
• Simplified Clustering
• Infinispan support
• Easy testing

What is new in version 7.7:

• Excel JDBC Translator - for use with Excel using the JDBC-ODBC bridge.
• Salesforce Aggregates - salesforce pushdown queries now support GROUP BY, HAVING, and the standard aggregate functions.
• Comparable LOBs - the system property org.teiid.comparableLobs can be set to use CLOB and BLOB values in comparison/sorting/grouping operations.
• Padded String Comparison - the system property org.teiid.padSpace can be set to effectively right pad strings to the same length for comparison.

What is new in version 7.0:

• JBoss AS Integration - Teiid now requires a JBoss AS 5.1 instance. This change allows Teiid to leverage many AS/MC features, including transaction management, JCA, hot file drop VDB deployment, and the profile service for configuration.
• New Admin Console - This release includes a preview release of our new administration console. See it's feature overview. Once Teiid is installed, the Teiid Admin Console is automatically contributed to the JBoss Admin Console.
• Translators and JCA components - This release separates the old connector API into light-weight Translators and JCA components. This greatly simplifies the process of adding new integration sources to Teiid, since it cleanly separates container provided functionality (JCA) from the Teiid specific classes knwon as a Translator. See the Developer's Guide for more information.
• Text Integration - Structured text file processing is now handled by the TEXTTABLE table function and the .
• SQL/XML - Nearly all of SQL/XML 2003 support has been added, as well as XMLTABLE and XMLQUERY from SQL/XML 2006.
• Web Services Integration - XML/Relational logic has been replaced by the SQL/XML XMLTABLE and web services execution is now done through the WS Translator/WS Resource Adapter.
• Expanded Dynamic VDB Support - Every source type except for LDAP can now be integrated in a Dynamic VDB.
• Other SQL Support - Queries can now contain nested tables that allow for correlated variables to preceding from clause items. Expressions are supported in the order by clause. Double quoted identifiers are allowed by default. Added the functions to_bytes, to_chars, and querystring. ResultSet caching can now be utilized with the /* cache */ query hint.
• Improved Buffering - Forward only cursors will typically not buffer results on the server. Algorithms for storing and retrieving buffers have also been improved.