Skip to main content

Teiid 10.3.1 Released

By
We are pleased to announce the release of Teiid 10.3.1 (A regression with TEIID-5314 caused an immediate patch release).  See all 48 issues addressed.  The feature highlight are:
  • TEIID-5293 Added implicit partition wise joining in non-multisource scenarios as well.
  • TEIID-5308 Added ENV_VAR and SYS_PROP functions and clarified the usage of the ENV function.
  • TEIID-4745 Added a polling query to trigger the reload of materialized views.
  • TEIID-5317 Added ODBC 3.0 functions current_time, current_date, current_timestamp.
  • TEIID-5314 Environment variables can now be used instead of or to override system properties.
  • TEIID-5307 Added more information_schema tables for pg compatibility.
  • TEIID-4864 Added update support to the Excel translator.
Special thanks to the many community members who contributed to this release - in particular Andreas Krück, Divyesh Vallabh, Mathieu Rampant, Mike Higgins, Pedro Inácio, Yuming Zhu, Michael Echevarria, and Bram Gadeyne.

We should also extend a warm welcome to Rafal Korytkowski to the Teiid Team. Rafal has begun by finishing off the work on the Exosal translator and will help with efforts related to cloud and OpenShift support.

Other Important Stuff:
  • The new website is (mostly) live! See teiid.io. There are no under construction animated GIFs, but you can expect a few issues as we get the new Hugo/Netlify/Travis build worked out. Notice that we're effectively combining tooling and backend under a single site.  The content is being updated to be more relevant for cloud and OpenShift deployments. A lot of work is happening in creating a self-service data virtualization OpenShift based solution. If you have any interest in becoming involved, or would like to see more around the image build/configuration please let us know.
  • Teiid 10.2.2 and 10.1.4 will be available in the next couple of days. That will effectively end support for the 10.1.x release stream.
Thank you,
The Teiid Team


Comments

Post a Comment

Popular posts from this blog

Teiid Spring Boot 1.7.0 Released

By
Teiid Spring Boot version 1.7.0 to support Teiid 16.0 has been released. This release is mainly to support the Teiid's latest version.  In this release, the support for OpenAPI code generation based on VDB has been removed as there is no community interest and moreover it was at OpenAPI 2.0, and the industry has moved to 3.0 and beyond. There are no plans to further pursue this feature. VDB maven plugin was also removed, which was intended to be a replacement for the VDB importing feature was to be used when working on OpenShift, however, since it requires the Maven repository and does not completely represent the feature as defined on the WildFly based deployments this is also removed. You can still use the VDB import feature with Teiid Spring Boot, simply define the VDB with your "IMPORT DATABASE" statements and provide the additional files along with the main VDB file. During the start of the application, Teiid Spring Boot will load all the necessary DDL files for the
Post a Comment
Read more

Teiid 8.13.3 Released

By
Teiid 8.13.3 is now  available .  In total 8.13.3 addresses 10 issues since 8.13.2: [ TEIID-4028 ] - adding salesforce-34 resource adapter does not work through the cli [ TEIID-4066 ] - Odata translator ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl [ TEIID-4070 ] - Issues with resource adapters with api modules in wildfly [ TEIID-4089 ] - Teiid JDBC driver does not reset the update count when calling getMoreResults(int) [ TEIID-4093 ] - OData authentication fails with NPE when gss-pattern related properties are included in VDB [ TEIID-4096 ] - AssertionError with independent side of a dependent join that has an ordered limit [ TEIID-3050 ] - allow for more incremental insert with iterator [ TEIID-4075 ] - Netezza translator to support common table expressions [ TEIID-4098 ] - Always preserve columns order in google spreadsheets models [ TEIID-4046 ] - OData - $skip is beeing ignor
10 comments
Read more

Expose Excel Data as OData feed using Teiid

By
For that matter you can expose any data source that is supported by Teiid through its translators as OData service. You can convert Relational databases XML, JSON, CSV files Web Services  Sales Force Excel documents sources, or write your on top of your specific source. Teiid added support for exposing its virtual database (VDB) as OData service without any additional work. Create a virtual database with your required sources and create any additional views and deploy in the the JBoss EAP 6.1 server, that has Teiid 8.3 or greater installed.  See https://docs.jboss.org/author/display/teiid84final/OData+Support  for more information. So, lets build a simple example of exposing the Excel Sheet. Teiid accesses Excel sheets via JDBC-ODBC bridge, and Windows OS provides a ODBC driver for Excel documents.  Edit the standalone-teiid.xml, and create Connection Factory jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};Dbq=c:\ODBC\ExcelData.xls odbc
2 comments
Read more