Sunday, January 8, 2017

Teiid 9.2 Beta1 Available

Teiid 9.2 Beta1 has been released. Feature highlights since Alpha2:
  • TEIID-4627 Source Triggers to handle source change events.
  • TEIID-4643 Encrypt/decrypt functions were added for 128bit AES.
Feature Progress:
  • The DDL metadata system feature TEIID-4629 will be ready for inclusion in Beta2
We anticipate a Beta2 followed by a CR1 release before the Final.  If needed however we may delay the Final by a couple of weeks to get more feature development in.


Thursday, January 5, 2017

Teiid 9.1.2 Released

Happy New Years to everyone. The next fix release on the 9.1.x line is now available. It addresses 21 issues:
  • [TEIID-4551] - Improve exception handling in Admin methods
  • [TEIID-4663] - Support a more secure block mode for client/server encryption
  • [TEIID-4553] - COUNT returns inconsistent results when column statistics are not gathered
  • [TEIID-4566] - Ordered limit against preserved view fails
  • [TEIID-4573] - Modeshape query
  • [TEIID-4580] - ST_PointOnSurface returns point on the boundary of the polygon
  • [TEIID-4584] - SimpleDB doesn' work
  • [TEIID-4589] - Teiid throws NPE if multi-value insert is issued on global temporary table
  • [TEIID-4595] - Wrong pushdown of several spatial functions to Oracle
  • [TEIID-4598] - NPE when analytic Source function for Greenplum doesn't get pushdown
  • [TEIID-4605] - SqlServer translator - insert/update statements - timestamp is cast to datetime
  • [TEIID-4608] - Insert statement - multi-value insert into view - incorrect type resolution if first tuple contains NULL
  • [TEIID-4631] - IN clause causes an error when used within a function in SELECT clause
  • [TEIID-4637] - join of aliased views with partitioned unions not handled correctly.
  • [TEIID-4648] - MySQL unsigned type detection is incorrect
  • [TEIID-4649] - SybaseIQ translator: different order of arguments in CONVERT function
  • [TEIID-4650] - SybaseIQ translator: week function can't be pushed directly
  • [TEIID-4651] - SybaseIQ translator: different order of arguments in LOCATE function
  • [TEIID-4661] - Subsequent queries hang after materialized view TTL expires.
  • [TEIID-4668] - Google translator skips NULL value in INSERT
  • [TEIID-4673] - Translator import of google spreadsheet not updatable

If needed a 9.0.6 will be made available prior to the release of 9.2 Final.  9.2 Beta1 will be available tomorrow.


Tuesday, December 13, 2016

Teiid 9.2 Alpha2 Available

Teiid 9.2 Alpha2 has been released. Due to the break and other issues this took slightly longer than anticipated.  Feature highlights since Alpha1:
  • TEIID-4532 Hashing Functions were added for md5, sha1, sha2-256, and sha2-512.
Feature Progress:

  • The DDL metadata system feature has been pared down to just TEIID-4629  
  • We're also putting more emphasis on materialization issues in anticipation of greater integration with Debezium.
Even if the features are not fully formed yet, the pace of fixes in general has been good as we're closing in on 70 issues.

Given the upcoming break, I don't expect the next pre-release until around January 6th.  Hopefully we'll be back to about every two weeks after than and stay on track for an early to mid February release.


Thursday, December 8, 2016

Data Service Builder - Sprint 8 available

The Teiid Tooling team has completed a Sprint 8 milestone for the Data Service Builder (DSB).

Data Service Builder (DSB) is a web interface that allows you to easily connect to your data, compose a data service, then test and deploy the data service for your applications to consume as an OData-based REST service.

See our Getting Started Page for instructions to download and try it out.   Also check out our Future Sprint Development Plans page.

Tuesday, November 22, 2016

Kerberos Authentication to Oracle from Teiid

In this article I will show step by step instructions on how to configure WildFly server running Teiid to participate in Kerberos login into Oracle database. This article also shows how the kerberos ticket is used for credential delegation to Oracle and also using Teiid OData Rest Web Service.

See for full details.

Wednesday, November 16, 2016

Teiid 9.2 Alpha1 Released

Teiid 9.2 Alpha1 has been released.  Feature highlights so far:
In progress features:

  • Also using Teiid as a Postgres/Postgis source for qgis is nearly complete.
  • The build has been revamped to support our integration with WildFly Swarm.  Swarm provides a powerful new mechanism for embedding Teiid with the full power of the application server.  See an example/description at
  • It's not in this alpha, but a lot of work has been completed toward a more complete DDL metadata system.  Please follow this and other issues if you are interested in contributing.

We'll continue to shoot for a pre-release about every two weeks and still expect the final release in about 3 months.


Monday, October 31, 2016

Teiid 9.1.1 Released

Teiid 9.1.1 has been posted.  It addresses 7 issues:
  • [TEIID-3755] - Allow embedded to set the default authentication type
  • [TEIID-4499] - OData Kerberos cannot access VDB
  • [TEIID-4535] - Issues with EventDistributor
  • [TEIID-4541] - trustAllLocal works even for remote connections
  • [TEIID-4546] - On setting jboss-teiid cluster : throwing java.lang.IllegalArgumentException.
  • [TEIID-4547] - getQueryPlan fails in adminapi
  • [TEIID-4530] - Add semicolons to generated ddl
The most significant of which is a security issue - TEIID-4541.  If you are allowing remote JDBC connections, not using data roles, and have left trustAllLocal at the default setting, then remote connections that specify PassthroughAuthentication=true are also being allowed.  Please upgrade or alter your settings to prevent this.

The pace of fix releases for 9.0.x will now be much slower and end with the release of 9.2 Final.  The first alpha release of 9.2 should be available by the end of the week.