Tuesday, January 13, 2015

Teiid 8.10 Beta1

After the year end slowdown, Teiid 8.10 Beta1 is available from the downloads and maven.  Feature highlights since Alpha2 include:
  • TEIID-2384 Geospatial Support - contributed by Tom Arnold. Adds a geometry type and several functions. See the reference for more.
  • TEIID-2816 Hbase Support - based upon the Phoenix JDBC Drirver.
We expect both of these features to evolve a little more before the final release and documentation is also pending.  Ideally we'll have a blog or two to cover the geospatial topic.

We should be back on track to have pre-releases every two weeks, so expect a Beta2 before the end of the month and a final by mid-February.  It has been determined that we'll skip the Wildfly 8 series in favor of aligning with Wildfly 9 for Teiid 9.  So we'll begin that effort sometime after the Wildfly team hits CR1.


Friday, December 19, 2014

Teiid 8.10 Alpha2

Teiid 8.10 Alpha2 is now available from the downloads and maven.  Feature highlights include:
  • TEIID-991 SybaseIQ Translator - for use with SybaseIQ 15.1 and later.
  • TEIID-2882 PrestoDB Translator - for use with PrestoDB 0.85 and later.
  • TEIID-1091 Additional SQL/XML Support - XMLEXISTS, XMLTEXT, and XMLCAST were added.
  • TEIID-3216 Update Support for Google Spreadsheets
Ramesh also introduced logic to support OAuth - Integrating Twitter With OAuth.

There have been several JIRAs to increase compatibility including quoted set/show variables, temp table on commit clause, (the long overdue) -- single line comment, and set session characteristics for transaction isolation level.

And of course there have been a host of other issues resolved - many of which originated from community users.  Special thanks to Filip Elias for contributing the update support for google spreadsheets.


Thursday, December 18, 2014

Expose Twitter data in Teiid, using OAuth Authorization

If you want to access Twitter data or any other REST web service (google, facebook etc) secured by OAuth 1.0A or OAuth 2.0 authentication schemes using Teiid, please read this article https://developer.jboss.org/docs/DOC-52995 for an example.

This feature will be available in Teiid starting from 8.10.Alpha2 release.



Teiid Designer 9.0 Released

Teiid Designer 9.0 Final is now available via our update site or downloadable archive.

This release focused on improving existing features and bug fixes.

Primary drivers for this release were:
  • Upgrade to Eclipse 4.4 Luna target platform and JBDS 8.0 GA
  • Compatibility with Teiid 8.8 Runtime
  • Bug fixing with special attention to issues on Windows OS

Check out our What's New for 9.0 article for details...

Barry LaFond
Teiid Designer Team

Tuesday, December 2, 2014

Teiid 8.10 Alpha1

We've made steady progress on 8.10 and Alpha1 is now available from the downloads and maven.  Feature highlights include:
  • TEIID-3192 Salesforce Connectivity - connectivity was converted to the partner api provided by Salesforce rather than utilizing CXF. Please log an issue if you were utilizing features from the CXF config.
  • TEIID-3046 Recursive Common Table Expression - engine and push down support was added.
  • TEIID-3163 TEIID-3167 Text Table Enhancements - to support a general no trim option and to use a different row delimiter.
We expect progress with Olingo, but it appears that their final won't be available until March.  Due to that and other needs we will likely produce an 8.11 as well.

There will be several new sources coming in the 8.10 release including SybaseIQ and PrestoDB.  HBase is likely and there should be a couple more if time permits.

Thanks in advance for the community effort as we work toward the 8.10 release and be sure to let us know if there are issues needing attention.


Monday, November 17, 2014

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.

Thursday, November 6, 2014

Teiid 8.9 CR3

It seems that CR2 was well received or at least there were no major issues with the switch to EAP 6.3 Alpha.  So now we are moving onto 8.9 CR3, which is available in the downloads and maven.  The final release should be expected within the next 10 days.

There are a couple of fixes beyond what was in CR2 and we are up to 116 total issues addressed for this release. 

Work has begun on 8.10.  Expect an 8.10 Alpha about a week after the 8.9 Final.  Now is a great time to vote for or log issues to be included in that release.