Friday, July 23, 2010

7.1 Alpha2

7.1 Alpha2 is now available. The big feature is ODBC access support. From any platform that the Postgres ODBC is available, you can now access Teiid and therefore any source Teiid supports through ODBC.

So if you need ODBC access to a legacy system, then there's no need for a proprietary ODBC/JDBC bridge or loads of custom development for you're own driver - just use Teiid and enjoy all the integration and expanded SQL capabilities as well.

The Teiid Team

Thursday, July 15, 2010

7.1 Pre-release

7.1 Alpha1 is now available. Even though 7.0 was just released, we have been working hard to pack more features and fixes into 7.1. What is already available:

  • SQL Support
    • Added NULLS FIST/LAST handling - including pushdown support.
    • Added enhanced numeric stat aggregate functions STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, with pushdown and aggregate decomposition.
    • Added support for the boolean aggregate functions ANY, SOME, EVERY.
    • Added support for using boolean value expression as both criteria and expressions, e.g. "... where boolean_value" or "select x = 1 as boolean_value ...".
    • Changed named procedure syntax to accept param=>value, rather than param=value.
  • Parallel Source Queries - reestablished parallel execution of source queries within a query plan along with a prioritized work system to help prevent resource contention.
  • SHOW Statement - added client handling for the SHOW statement to retrieve query plan information and see execution property values.

  • ODBC access and many caching improvements will be coming shortly.

    The Teiid Team

    Thursday, July 8, 2010

    Teiid Designer 7.0 Released

    Teiid Designer 7.0 is ready to roll and is now available for download.

    It's been difficult to keep up with all of the important, fundamental changes to Teiid 7.0 but we are finally there.

    This release provides a much more integrated Eclipse experience targeted for developers who want to create, integrate and manage various types of data sources. In Designer 7.0, you will now utilize Eclipse's Data Tools Platform and it's inherent connection profile management framework to assist in both importing/creating relational source models and in testing your VDB's via Teiid JDBC connections.

    Creating and editing your VDB's has been greatly simplified in Designer and this release also provides a quick means to deploy and test your VDB's in a running Teiid server.

    The primary goals of this release were:
    • Provide upgraded tooling for creating and managing deployable Teiid artifacts (VDBs)
    • Simplify VDB creation, editing and management
    • Replace custom connection framework with existing Eclipse DTP functionality
    • Provide seamless source connection transition between DTP, Designer and Teiid
    • Expose basic runtime Teiid API functionality necessary for VDB deployment and data access through DTP
    See the release notes for more details of the work behind this release.

    So use our new Quick Start Guide and go give it a test drive!

    Thank you.

    Teiid Designer Team