Monday, November 16, 2015

Using Hadoop as a datasource in Teiid

If you are trying to connect to Hadoop platform from Teiid, please see this clearly written blog detailing every step


Using Hadoop as a datasource

Thursday, November 12, 2015

Teiid 8.12.2 Available

Teiid 8.12.2 is now available.  Issues addressed since 8.12.1 include:
  • [TEIID-3795] - Order of VARIADIC parameters is not preserved
  • [TEIID-3799] - Insert default expressions not rewritten
  • [TEIID-3802] - HANA translator modifies boolean to tinyint in type conversion
  • [TEIID-3803] - Kerberos with ODBC with MutualAuth fails
  • [TEIID-3806] - Improve null resolving in array literals
  • [TEIID-3807] - quantified comparison results dependent on null ordering
  • [TEIID-3812] - HANA MIN and MAX functions not applicable on boolean
  • [TEIID-3813] - Informix translator - convert function in definition of view is not pushed down
  • [TEIID-3815] - Oracle translator - OFFSET function does not work
  • [TEIID-3817] - HANA FLOOR and CELING functions not applicable to boolean
  • [TEIID-3818] - Issues with ODBC metadata foreign key queries
  • [TEIID-3819] - SimpleDB NullPointerException when inserting null value
  • [TEIID-3581] - Add a system function to return Teiid Server Name
  • [TEIID-3582] - Add the query requestID to all lines for that query in the logs
  • [TEIID-3793] - Push Teiid function LOCATE() to SQL Server
  • [TEIID-3821] - Expand xml output types
  • [TEIID-3717] - Enable SNI (Server Name Indication) support
  • [TEIID-3787] - ignored properties in dynamic vdb should be flagged with a WARN log entry
  • [TEIID-3811] - Teiid Embedded with remote JDBC susceptible to exploit with common-collections in classpath
  • [TEIID-3820] - SimpleDB column import order may not be consistent

If you are using Teiid Embedded with socket based JDBC access enabled and have spring, common-collections, or groovy in the classpath, then you should upgrade to 8.12.2 due to TEIID-3811 to prevent deserialization attacks.

There have been a few delays in the 8.13 pre-releases as there has been more changes in the AS/Wildfly integration apis and it has been a larger effort than expected to normalize our dependencies.  Ideally we're still on track for an alpha release in the next week or two.

Thanks again for all the community support,

Wednesday, November 11, 2015

VDB Builder - 0.3 Update Available

VDB Builder Update

The Teiid Tooling team has released the next milestone kit for VDB Builder.  The VDB Builder is a command line tool that allows creating, editing and managing dynamic VDBs and their contents.  It also allows interaction with a teiid instance.


What's New?

Please see the announcement on our Teiid Tooling page for a full list of changes since the last milestone.  In this milestone, we have added the ability to connect to a teiid instance.  You can view server artifacts and also deploy vdbs from your VDB Builder workspace.  We have also made numerous enhancements in other areas.


Try It Out

You can start building your VDBs now by downloading the milestone kit from SourceForge!
Contributions and feedback are welcome!

Teiid Tooling Team

Monday, November 2, 2015

Teiid Designer 9.2 Released

Primary drivers for 9.2 include:
  • Compatibility with Teiid 8.11 Runtime
  • New Features
    • Generate VDB Archive and Models from dynamic -vdb.xml file
    • Generate Dynamic -vdb.xml file from VDB archive *.vdb 
These 2 new features allow you to manage your vdb's in a simpler format and utilize Teiid Designer's detailed VDB Editor to manage data roles as well as setting various VDB runtime properties (translator overrides, allowed languages).  With 9.2, you can also deploy and test your dynamic VDBs.
  • Converts dynamic -vdb.xml files in your workspace into VDB archives (*.vdb) and models
  • Converts VDB archives (*.vdb) into dynamic -vdb.xml files

See Working with Dynamic VDBs section in documention

For details see:
Teiid Designer Project Team

Thursday, October 29, 2015

Teiid 8.12.1 Released

Teiid 8.12.1 is now available.  It contains all of the 8.11.5 fixes plus a number of odata and hbase fixes.  All fixes since 8.12 include:
  • [TEIID-3757] - OData V2: $top doesn't work with virtual procedures
  • [TEIID-3760] - endswith defined with wrong return type
  • [TEIID-3761] - OData V2: The property based response and Function based responses are incorrect per specification
  • [TEIID-3762] - OData V2: $value on property is not supported
  • [TEIID-3764] - HBase - Phoenix driver does not support UNION
  • [TEIID-3765] - HBase - Phoenix does not support scalar subquery
  • [TEIID-3767] - HBase - Phoenix does not support LIKE ESCAPE
  • [TEIID-3770] - HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
  • [TEIID-3771] - Teiid throws an NPE while executing query with nested subquery IN predicate
  • [TEIID-3776] - Teiid throws NPE if query contains AVG function on varchar type
  • [TEIID-3777] - ORDER BY DESC is ignored in STRING_AGG function when DISTINCT is also specified
  • [TEIID-3783] - Error when limit/sort is pushed above a window function
  • [TEIID-3785] - PostgreSQL - Large Objects may not be used in auto-commit mode.
  • [TEIID-3759] - Missing Apache Olingo dependency in Teiid 8.12.0.Final
  • [TEIID-3780] - Hive: Convert "UseDatabaseMetaData: to be an translator import property
  • [TEIID-3781] - Queries are not killed even if the client sends a cancel request
Additionally we are working targeted enhancements in 8.12.x.  For 8.12.1 this includes:
  • [TEIID-3039] - OData V2: Add support for odata expand
  • [TEIID-3361] - Initial addition of source query details to the command log
  • [TEIID-3436] - OData V2: Add array type support to the odata translator
  • [TEIID-3778] - Mark hbase/phoenix as supporting limit
  • [TEIID-3791] - Upgrade groovy-all to be version 2.4.
We'll look to put out an 8.12.2 in a couple of weeks as more issues are worked/found.

Work has started on the Wildfly 9 support in Teiid 8.13.  If all goes well, then an 8.13 Alpha1 will be available in the next two weeks.

The Teiid Team

Thursday, October 22, 2015

Teiid 8.11.5 Released

Teiid 8.11 development has concluded with the release of 8.11.5, which is available from maven and the downloads page.  Important issues addressed in this release include:
  • [TEIID-3564] - float field gets converted to scientific notation when query is submitted to source
  • [TEIID-3707] - Wrong Data returned when a procedure is executed in the SELECT clause
  • [TEIID-3720] - DDLString Visitor not writing the OPTIONS value for Procedure parameters
  • [TEIID-3726] - CTEs combined with constant values yield an error message
  • [TEIID-3739] - Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
  • [TEIID-3756] - Order By clause specified in STRING_AGG function is skipped when pushed down to PostgreSQL
  • [TEIID-3777] - ORDER BY DESC is ignored in STRING_AGG function when DISTINCT is also specified
  • [TEIID-3705] - Build issue in security

From here we will start providing 8.12.x releases - starting with 8.12.1 in about a week.  If all goes well in approximately 2 weeks we'll provide an 8.13 Alpha with the initial Wildfly integration.


Thursday, October 15, 2015

Teiid 8.12 Final Released, Swagger support added

Keeping up the tradition of time boxed releases, the Teiid team is proud to announce 8.12.0 Final. We have resolved 147 issues (features, enhancements, bugs) in this release. You can downloads at

JBoss EAP & Teiid:
8.12/8.11 are based on the JBoss EAP 6.4.Alpha platform. The downloads page contains a consolidated single download file that contains  EAP 6.4 Alpha + Teiid 8.12.0 + Teiid Web-Console.  You also have choice of using Docker image if you choose to at Docker Hub.

Please note this is the LAST VERSION of Teiid that will be based on JBoss EAP.  8.13 and 9.0, we will be moving to WildFly. Any micro releases on 8.12 line like 8.12.1, 8.12.2 etc still be using JBoss EAP.

Highlights of 8.12
  • TEIID-3411 LDAP modeling can now better account for associations defined by multivalued attributes.
  • TEIID-3323 Vertica translator added.
  • TEIID-3515 TEIID-3530 Dependent join enhancements in hints and pushdown planning.
  • TEIID-2883 Actian Vector in Hadoop Translator added
  • TEIID-3595 TEIID-3594 Logging Enhancements for command and audit logging
  • TEIID-3546 IS DISTINCT FROM syntax support added for use in procedures.
  • TEIID-3521 Swagger Support for auto-generated REST web services
  • TEIID-3652 Additional OUTER JOIN planning to allow more flexibility in join ordering
  • TEIID-3668/TEIID-3618 OAuth Support with JWT Bearer Access Token and Salesforce SSO using OAuth2 (RefreshToken, JWT)
  • TEIID-3712 Date/Time Keyword Literal support was added in the parser.
  • TEIID-3722 Option to not widen comparisons to string was added via the system property org.teiid.widenComparisonToString
  • TEIID-3327 OSIsoft PI translator added for use with the PI JDBC driver.
  • TEIID-3727 Salesforce Translator added a translator and resource-adapter based on Salesforce Partner API 34
  • TEIID-3370 OData4 Translator added new translator to read/write from any compliant OData V4 source
Community Folks:
Once again we had great interactions with community in developing this release. We sincerely extend our appreciation to Albert Wong, Avinash Misra, Bram Gadeyne, Burak Serdar, Dalex, Don Krapohl, Gary Gregory, Guru Prasad, Jorge Herrera, John Muller, Mark Addleman, Mark Tawk, Michael Davies, Michal Sanitrak, Mike Higgins, Pranav K, Prashanthi Kairuppala, Salvatore R, Sathish Kumaran Vairavelu, Scott Wallace, and Tom Arnold.

What's Coming Next:

Lot's of Stuff :)

We are working on 8.13 version that is just going to be similar to 8.12 version in terms of features, but we will replace JBoss EAP 6.4 Alpha with WildFly 9 or 10. If community feels WildFly 10 is better please speak up.  We'll probably move to WildFly 10 during the Teiid 9.0 development regardless.

Also expect an 8.11.5 shortly as the last of the 8.11.x series.

We are always looking for volunteers, so if you got idea or just want contribute to Teiid, please come talk to us in the forums.

Thank you for your continued support.

Ramesh & Steve.