Sunday, August 21, 2011

Teiid 7.5 Final Released

We are pleased to announce Teiid 7.5 is now available.  Highlights of 7.5 features:
  • Window function support - Teiid and pushdown support was added for SQL 2003 OLAP window functions. The analytical ranking functions RANK, DENSE_RANK, and ROW_NUMBER were also added. See the reference for more.
  • Additional ANSI support - Teiid and pushdown support was added for SUBSTRING using FROM/FOR syntax, TRIM, EXTRACT, SIMILAR TO, and LIKE_REGEX. See the reference for more.
  • Subquery optimization control - added the DJ hint to indicate that a subquery should be the independent side of a dependent join.
  • MAKEIND Hint - The MAKEIND hint can be used to indicate that the other side of the join should be made dependent.
  • ODBC SSL - added support for SSL encrypted ODBC connections.
  • Reauthentication Statement - SET SESSION AUTHORIZATION can now be used to perform a reauthentication via JDBC or ODBC.
  • Pluggable Authorization - an alternative PolicyDecider can be defined in the teiid-jboss-beans.xml file to customize authorization decisions.
  • Streaming XQuery - in situations where document projection applies if the XMLQUERY/XMLTABLE path expressions meet certain conditions, then the incoming document will not only be projected, but the independent subtrees will be processed without loading the entire document. This allows for nearly arbitrarily large XML documents to be processed. See the Reference for more.
  • Logging Procedures - added SYSADMIN.isLoggable and SYSADMIN.logMsg to aid in debugging procedure logic.
  • ANSI OFFSET/FETCH FIRST - instead of the limit clause, a standard OFFSET and/or FETCH FIRST/NEXT clause can be used to limit results.
  • ODBC Cursors - added the capability to use "UseDeclareFetch" with ODBC. This enables users to read results in batches, which is especially useful when dealing with large row counts.
  • Internal Materialized Views
    • Distributed Refresh - When a internal materialized view is refreshed at one node, an event is issued to all other nodes in the cluster to asynchronously fetch the new contents.
    • Sync at Start - When a node is restarted in a cluster, at end of start cycle Teiid will asynchronously fetch the cached internal materialized view contents from other nodes.
  • LDAP Pagination - the ldap translator now supports pagination for retrieving large results from directory servers like Active Directory and OpenLDAP.
There were 93 total issues addressed.  See the release notes for more details.  Download today, give it try, and vote for or log features you want in upcoming releases.

The Teiid Team

Wednesday, August 10, 2011

Teiid 7.5 CR1

Adding on more features to 7.5 Beta 2, 7.5 CR1 is released today.  This marks end of new feature work for 7.5. We are planning a quick turn around and releasing 7.5 Final after some testing within next week.

If you are using 7.4 or any prior versions of Teiid, we highly encourage you to download this version of Teiid and validate your test cases and submit any bugs through JIRA. We will try to fix any critical and blocker bugs before the 7.5 Final.

New features in 7.5 CR1

- LDAP Pagination (TEIID-1659)
- Support for 'substring', 'trim', 'extract' functions (TEIID-1694)

If you are looking for new features in Teiid, this would a great time to start requesting and discussing them out in community forums, so that we can plan them for either 7.6 release or 8.0 releases.

Thank you.

The Teiid Team