Skip to main content


Showing posts from 2015

Teiid 8.13 Beta1 with WildFly 9.0.2 Available

The next revision Beta1 of Teiid 8.13 with WildFly is now released. The target version of WildFly we choose is 9.0.2.Final, which is latest stable release by the WildFly team. You can download it from

The issues described about sockets, clustering in previous release are now fixed. Support for Web-Console is added back in this release. The navigation of Web-Console has changed a lot, so please take a look and give us feedback.
In the next revision we will be removing "embedded" kit, and will be updating the corresponding examples soon.  We expect to have release a candidate release before the holiday break and hopefully final following soon after that.
This Beta1 version is be good version for start testing you usecase and letting us know about any issues you encounter, we can try fix them before final release.
Thank you.


Teiid 8.12.3 Released

Teiid 8.12.3 has been released.  Issues addressed include:
[TEIID-3814] - Rest Web Service URL for VDB [TEIID-3823] - Issues with fetchsize and local connections [TEIID-3827] - multi-source view insert throwing TEIID30492 error [TEIID-3840] - teiid-outh-util.bat - typo in name [TEIID-3841] - sap-nw-gateway translator wrongly encodes when a parameter includes a space [TEIID-3845] - select count(*) query not working on SimpleDB connector in Teiid [TEIID-3846] - Wrong alias rewriting in subqueries [TEIID-3847] - HiveTranslator should not use a Calendar for the Hive getDate [TEIID-3848] - Issue with hive literal timestamps [TEIID-3850] - Source caching with the cache directive can be at the wrong scope [TEIID-3851] - foreign temp additional extension properties not accessible in QMI [TEIID-3854] - Impala translator - ORDER BY clause using incorrect columns when not in SELECT list [TEIID-3857] - …

Teiid 8.13 Alpha1 with WildFly 9.0.1 Available

Teiid team is proud to announce the first ever version of Teiid with WildFly. The target version of WildFly we choose is 9.0.1.Final. You can download the its from

Most of the functionality  is available,  but following are the areas we are still working on
- Domain mode
- Web-console
- Socket performance issue

We hope to fix these by Beta 1 version, hopefully in next 3 weeks. I encourage you to download and play with it and let us know if you see any issues.

Thank you.


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 quer…

VDB Builder - 0.3 Update Available

VDB Builder UpdateThe 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!
Documentation and ExamplesInstallationSource CodeContributions and feedback are welcome!

Teiid Tooling Team

Teiid Designer 9.2 Released

Primary drivers for 9.2 include: Compatibility with Teiid 8.11 RuntimeNew Features Generate VDB Archive and Modelsfrom dynamic -vdb.xml fileGenerate 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: Release NotesWhat's NewDownload and Install Teiid Designer Project Team

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

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'l…

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 Hadoo…

Teiid 8.12 CR1

After a small delay, we are pleased to release Teiid 8.12 CR1.  We were able to get quite a few issues resolved - to date there are 134 issues resolved.  As usual CR1 can be found in maven and on the downloads page.
Feature highlights since Beta3 include:
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.widenComparisonToStringTEIID-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
Expect a final release in approximately 2 weeks, followed shortly by an 8.11.5 release.  Please let us know if you find any issues as we will address anything critical prior to the final release.

Thanks again for all the community support,

Teiid 8.12 Beta3

There is still more Olingo work and quite a few issues to go through for 8.12, so we decided it was best to release a Beta3 rather than CR1 at this point.  Beta3 can be found in maven and on the downloads page.

The feature highlight since Beta2 include:
TEIID-3546 IS DISTINCT FROM syntax support added for use in procedures.TEIID-3521 Swagger Support for auto-generated REST web servicesTEIID-3652 Additional OUTER JOIN planning to allow more flexibility in join orderingTEIID-3668/TEIID-3618 OAuth Support with JWT Bearer Access Token and Salesforce SSO using OAuth2 (RefreshToken, JWT) TEIID-3652 was only in a preliminary state in Beta2, but should be complete now.  And once again a CR1 will follow shortly.

Thanks again for all the community support,

Teiid Earns 2015 InfoWorld Bossie

We are very proud to announce that Teiid was named one of the winners of the 2015 InfoWorld Bossie (Best of Open Source Software) awards in the business applications, enterprise integration and middleware category.

Please see the announcement at 

Congrats to whole Teiid community for this validation of the dedicated work we put in to consistently expand our integration and virtualization capabilities.

The Teiid Team

Teiid 8.11.4

In what should be the last of the formal 8.11 fix releases, we have made 8.11.4 available.  This address 8 issues since 8.11.3:
[TEIID-3671] - filter on child table not working [TEIID-3674] - NOT IN construct behaves inconsistently [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator [TEIID-3692] - Impala/Hive string literals [TEIID-3696] - Duplicates are not always removed when UNION and GROUP BY clauses are used in a subquery [TEIID-3699] - execute immediate only checks immediate parent scope [TEIID-3702] - dependency and validation logic incorrect [TEIID-3664] - Timing issue with ping Thanks to those who helped uncover the issues.  8.12 CR1 will follow shortly.


Teiid 8.12 Beta2 and 8.11.3

We are further along toward the fall debut of Teiid 8.12 with the release of 8.12 Beta2 today.  The highlights of Beta1 are mostly fixes including corrections to the auto sizing of memory resources, fixing geometry methods in the EAP kit, improving the admin api, and a variety of translator issues.  We expect a CR1 in about 2 weeks.

Teiid 8.11.3 has also been released.  It contains 9 important fixes - all of which are in 8.12 Beta2.  Moving forward we anticipate supporting fix releases for longer into the cycle than we were previously.  So it should be routine for 3-4 fix releases to be issued rather than just a single one.

Both releases are available from maven and have been added to the download page:

Thanks again for all the community support,

Teiid 8.12 Beta1

Teiid 8.12 Beta1 has been released.  The feature highlight since Alpha2 is TEIID-3595/TEIID-3594 which were logging enhancements for command and audit logging - more granularity of the levels and more security events.

There have also been several HBase/Phoenix fixes and a variety of other fixes.  Expect another Beta release in about 2 weeks.

Thanks again for the community support and let us know if you find anything with the pre-release.


VDB Builder - Update Available

VDB Builder UpdateThe Teiid Designer 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. The command line interface (CLI) is a result of our on-going Komodo initiative to develop an extensible VDB editing framework.
What's New? In this milestone, we have added the ability to import and export Teiid DDL.  This means that you can create model content using a saved DDL file, and you can also export your model content into a DDL file.  In addition, we have updated our launch scripts and made numerous fixes and enhancements.
Try It Out You can start building your VDBs now by downloading and unzipping the milestone kit from SourceForge!
SummaryInstallationImport and Export VDBs and DDLYou can view and checkout the source code here:

Contributions and feedback are welcome!

Teiid Designer Project Team

Teiid 8.12 Alpha2 Released

Teiid 8.12 Alpha2 is now available from the downloads and maven.  Feature highlights since Alpha1 include:
TEIID-3515 TEIID-3530 Dependent join enhancements in hints and pushdown planning. TEIID-2883 Actian Vector in Hadoop Translator added Expect more translators to come for this release.  There should be a Beta1 in about 2 weeks, and an 8.11.2 release will be available by the end of the week to correct a couple of new issues and addresses two of the issues originally intended for 8.11.1 but that didn't make it into the release.

Thanks again for all of the community support,

Teiid 8.11.1 Released

Just a quick post to say that Teiid 8.11.1 is now available from maven.  It address 5 important issues:

[TEIID-3502] - Teiid returns integer/long overflow values[TEIID-3556] - BufferManager reserve memory variable is decremented twice[TEIID-3557] - Can't reload VDB in domain mode[TEIID-3558] - Duplicate records being for formed for Internal Materialized View cluster[TEIID-3563] - Problems with capabilities initialization
Also 8.12 Alpha2 should be available next week.
Thanks, Steve

VDB Builder - Next Generation Teiid Tooling Available

Next Generation of Teiid DesignerThe Teiid Designer team has been developing a more versatile VDB editing tool called the VDB Builder.  The VDB Builder is a command line tool that allows creating, editing and managing dynamic VDBs and their contents.

This tool is a result of our on-going Komodo initiative to develop a non-Eclipse extensible VDB editing framework. We plan to continue building out this CLI to allow full editing of VDBs and data sources and eventually adding deployment capabilities. But it is currently limited to VDB creation and editing.

This framework is rooted in adapting a local embedded ModeShape repository which utilizes sequenced node structures modeled from the Teiid vdb-deployer.xsd schema definition and Teiid BNF.
Try It Out You can start building your VDBs now by downloading and unzipping the first milestone kit from SourceForge!
SummaryInstallationCreating a VDBImport a VDBYou can view and checkout the source code here:…

Teiid 8.12 Alpha1

Teiid 8.12 Alpha1 is now available from the downloads and maven.  Feature highlights in Alpha1 include:
TEIID-3411 LDAP modeling can now better account for associations defined by multivalued attributes. TEIID-3323 Vertica translator added. There have also been several important fixes, new options for default handling, and refinements to dependent join pushdown planning.  We except more sources to be added in the subsequent pre-releases and we're working toward removing the embedded kit in favor of more examples and just using maven, so stay tuned.

Also expect an 8.11.1 release in about a week to provide fixes for around 5 - 10 key issues.

Thanks again for all of the community support,

Teiid on top of HP Vertica Analytic Database Server

HP Vertica Analytic Database Server is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.

Starting from Teiid 8.12, with Vertica Data Source(Vertica supply JDBC Driver) Teiid support connect/transform/federate data exist in Vertica table.

vertica-as-a-datasource is example demonstrates using the Vertica Translator to access data in Vertica Server, this can be a quick start for implementing your usecase.

8.11 Final Released, Support for OData V4 and SAP HANA

Keeping up with tradition of releasing a minor release every 3 months, the Teiid community is proud to announce yet another feature rich release - 8.11.0.Final. We have resolved 117 JIRA issues (features, enhancements, bugs) in this release. You can download the latest version from

JBoss EAP & Teiid:
Note that in this release the base environment to deploy Teiid is moved JBoss EAP 6.4 platform. For your convenience, we are also providing a download link where EAP 6.4 Alpha + Teiid 8.11 + Teiid Web-Console bundled all in single downloadable file. You also have choice of using Docker image if you choose to at Docker Hub.

Embedded Teiid:
If you are working with Embedded Teiid checkout our new examples repository at For embedded we are changing from providing a kit, to just relying on maven and the examples for 8.12.  We want provide as many example scenarios as possible, so that you can pick a example an…

SQL on MongoDB using Teiid - Part 2

In the previous article SQL on MongoDB using Teiid - Part 1 I showed a simple example how one can start using SQL based queries on MongoDB using Teiid. I have showed how to install and configure the Teiid and test.

The previous example was very simple that generated a MongoDB collection for defined relational table in Teiid. One of many advantages of NoSQL based stores like MongoDB is, user's ability to de-normalize data such that data for related entities is co-located. When the data is co-located there is no requirement for defining the relationships across entities, and queries will be naturally faster to execute. However, in relational databases data is more often very normalized, the naive implementation of relational to MongoDB where one table is mapped to a collection will result in very poorly performing queries. The solution is, utilize the MongoDB's nested document feature to represent a relationships in Relational database.

In this article, I will show how to defin…

Teiid 8.11 CR1

Teiid 8.11 CR1 is now available from the downloads and maven.  

There are no new features since Beta3 as we were focused on address as many regular issues as possible, including further refinements to the materialization logic.  The feature set for the entire release is looking good:
TEIID-3372 Multiple metadata elements can now be used to configure a vdb. TEIID-3369 Custom query rewrite - via a configurable PreParser. TEIID-3389 Kerberos Delegation JDBC driver can now participate in kerberos delegation based authentication TEIID-3390 SQL/XML improvements in performance and disk utilization. TEIID-3362 ARRAYITERATE system procedure for iterating over an array. TEIID-3393 Embedded AdminApi is now available from EmbeddedServer.getAdmin. TEIID-3270 Virtual Functions can not be defined with procedure syntax. TEIID-3434 More caching control over ttls in the result set cache down to the schema/table level. TEIID-3412 MS Access support via the UCanAccess driver.…

SQL on MongoDB using Teiid - Part 1

In this article series, I will showcase how you can use SQL based queries with MongoDB. In general there seems to be resurgence of SQL based access to all NoSQL based stores in the market space, take for example Hive, Impala, Spark, Apache Drill etc. The main reason for this shift is there are abundant amount of talent pool out there for SQL based developers, and even today (and years to come) our strong dependence on the relational stores for the enterprise data. I do not see either of them fading away any time soon. So utilizing the known skills on new types of data stores will save you lot of time and provide better integration with rest of your enterprise applications.

I know there are plenty of folks offering SQL based access to MongoDB, why you should choose Teiid?
Teiid provides full ANSI compatible SQL based access to MongoDB. This includes full SQL-92, and most SQL-99 and SQL-2003 support.Provides JDBC/ODBC access to execute SQL queries.Provides ODATA based access to MongoDB…

Tech Tip: Teiid SQL Language MAKEDEP Hint Explained

In this article I will explain what a MAKEDEP hint is, how and when, why it should be used in Teiid.

What: MAKEDEP is query hint.  When a query hint is defined in the SQL query it influences the Teiid query planner to optimize the query in a way that is driven by the user. MAKEDEP means "make this as a dependent join".

What is a Dependent Join?

For example if we have query like:

Where the data for X, and Y are coming from two different sources like Oracle and WebService in Teiid, so in relational algebra you can represent above query as

Here the result tuples from node X and node Y are being simultaneously fetched by Teiid query engine, then it joins the both the results inside Teiid engine based on the specified X.PK = Y.PK condition and returns the filtered resulted to the user. simple..

Now, what if, if X table has 5 rows and Y table has 100K rows? In order to do the JOIN naively Teiid need sto read all the 5 rows from X sid…

Teiid 8.11 Beta3 Posted

Teiid 8.11 Beta3 is now available from the downloads and maven.  

The main feature highlight since Beta2 is a community contribution from Tom Arnold to add support for the REGEXP_REPLACE function - a more powerful version of the REPLACE function that supports regular expressions.

There were a lot of late changes, thus the decision to release another beta rather than progress to CR1.  It is expected that we'll produce a CR1 by June 10th - with the final to follow at least a week later.

Also we're looking at starting on Teiid 9.0 soon.  If you have any major features you'd like to see, please start a forum topic of log/vote for a JIRA issue.  Another parallel effort could be to produce a Wildfly enabled 8.x release -please let us know if there is any interest in that.

For 8.11 we've addressed 90+ issues so far - with your help we'll close out quite a few more before the final release.

Thanks again for all of the community efforts.


Teiid 8.11 Beta2 Avaliable

Teiid 8.11 Beta2 is now available from the downloads and maven.  The main feature highlight of this release since Beta1 is TEIID-3371 which puts us on EAP 6.4 Alpha as the target platform.

Also more buffer manager configuration has been exposed for embedded and there are now examples showing integration with IronJacamar/Naryana.  We'll be looking into rounding out the examples and Teiid embedded in general to make it's usage as straight-forward as possible in the coming releases. 

For 8.11 we've addressed nearly 80 issues so far and will start to narrow in on the final release - which should be on track for a little over 3 weeks from now.

Thanks again for all of the community efforts.