Skip to main content

Teiid 8.9 Final Released

The Teiid community is excited to announce yet another (nearly) time boxed release of its Data Virtualization software - version 8.9. This release took an extra 4 weeks on top of regular 12 weeks to accommodate a NEW version of the host environment - JBoss EAP 6.3.0 Alpha.

You can find the Teiid downloads at http://teiid.jboss.org/downloads/

A little over 100 issues were resolved and this is looking to be solid release. The major features include:
  • TEIID-3009 WITH project minimization - common table expressions will have their project columns minimized.
  • TEIID-3038 geoSpatial support for MongoDB translator
  • TEIID-3050 Increased Insert Performance with sources that support batching or insert with iterator.
  • TEIID-3044 Function Metadata is available through system tables and DatabaseMetaData.
  • TEIID-1910 TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven.
  • TEIID-3119 Performance improvements in grouping and duplicate removal as well as general improvements to memory management.
  • TEIID-3156 Collation aware prevention of order by pushdown via the collationLocale translator property and the org.teiid.requireTeiidCollation system property.
  • TEIID-3042 Usage Information on views and procedures in the system table SYSADMIN.Usage.
  • OData4 Support - There is partial support for OData4 using the Apache Olingo project. The OData2 is still intact. We consider this still as experimental feature.
Thank you for continued support in the community, especially to the individuals who found issues, entered JIRAs, and provided other valuable contributions. Huge thanks to Alex K.,  Bram GadeyneCristiano NicolaiDevesh MishraGary GregoryHaifen BiHarrison GentryIvan ChanJoao ViragineJoseph CHIDIACMark AckertMark AddlemanMichael FarwellPranav KSalvatore RSanjeev GourSunil VarmaTom Arnold for all your contributions.

The development of Teiid 8.10 is already well underway, but there is plenty of time to add more features. The target release date will be February 15th, 2015. If you have been thinking about a feature for Teiid, this is a great time to engage the leads and submit your request/proposal. We really need experts out there to help with our big data story.  If you have experience with NoSQL stores, please write a translator in Teiid or improve what we already have in the build.  Check out the Open To Community issue bucket to see some existing issues that could be good to start with.  We are also looking for web smiths, as we really want update the main Teiid website - any volunteers are welcome.

If you are thinking about production support, look into Redhat Data Virtualization.  You can also download a free developer version of upcoming DV 6.1.0 version there.

Thank you. 

Steve and Ramesh.

Comments

Popular posts from this blog

Teiid Spring Boot 1.7.0 Released

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

Teiid 8.13.3 Released

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

Expose Excel Data as OData feed using Teiid

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