Wednesday, November 22, 2017

Teiid 9.3.5 Released

Teiid 9.3.5 has been released.  It resolves 8 issues:
  • [TEIID-5130] - Document/refine behavior of treating result parameter as the first parameter
  • [TEIID-5128] - transaction support value not cloned on access node
  • [TEIID-5133] - XmlTable path language is not always identical to XPathValue expressions
  • [TEIID-5137] - SystemAdmin.usage column dependency issue
  • [TEIID-5146] - UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
  • [TEIID-5152] - "No value was available" error message when evaluating an expression
  • [TEIID-5153] - RAND function gives same results in view
  • [TEIID-5166] - Google spreadsheet insert fails
For those in the US happy Thanksgiving.  You can expect community activity to return to normal next week.

Thanks,
Steve

Monday, November 6, 2017

Teiid 9.2.7 Released

Teiid 9.2.7 has been released.  It resolves 6 issues:
  • [TEIID-4870] - Google translator unexpected behavior for view update without trigger
  • [TEIID-5094] - Is DISTINCT FROM evaluation with two null values
  • [TEIID-5098] - Unsyncronized static date format for Salesforce bulk inserts
  • [TEIID-5107] - teiid-olingo-*.war not deploying in wildfly when using domain
  • [TEIID-5109] - Set operations and parenthesis
  • [TEIID-5133] - XmlTable path language is not always identical to XPathValue expressions
This is the last community release on the 9.2.x line.

Thanks,
Steve

Thursday, November 2, 2017

Teiid 10.0.0.Final Released

After 5 months of work we are pleased to announce the release of Teiid 10.0.0.Final.  This is longer than a typical cycle, but it should be worth the wait as we were able to pick up WildFly 11.0 and address 165 issues.  The major feature highlight are:
  • TEIID-4981 Amazon S3 translator support, now read the objects directly from Amazon S3 with security
  • TEIID-5026 The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.
  • TEIID-1131 Added support for importing sequence information.
  • TEIID-5073 Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.
  • TEIID-4208 Added parallelism to plan execution involving large sorts.
  • TEIID-5002 Upgraded to WildFly 11
  • TEIID-4711 Generalized IS DISTINCT support.
Other Important Stuff:
  • Take note of major changes in the release in particular the removal of XML document models and switching the artifact group from org.jboss.teiid to org.teiid.
  • Teiid Spring Boot was launched make getting starting with Teiid and Spring seamless - thank you Ganesh Pol and Christian Posta for early testing
  • With TEIID-4208 and other performance enhancements you should expect to see a performance boost especially for higher data volume / lower query volume workloads.
  • Couchbase access is now quite robust
  • OsiSoft Pi access has gone under more review and will be continue to be refined in 10.1
Special thanks to the many community members who contributed to this release.  In particular dalex dalex and Mike Higgins who identified several important issues.

On the horizon:
  • Teiid 9.2.7 will be the last community release on 9.2.x and is expected tomorrow.  Teiid 9.3.x will receive "extended" community support until the release of 10.2 as to ease any transition issues.
  • Teiid WildFly Swarm will be updated in the near future.  Initially this may be against the 9.3.x release stream as Swarm is not yet on WildFly 11.
Thank you,
The Teiid Team

Thursday, October 26, 2017

Low-risk Monolith to Microservice Evolution

Christian Posta has written a series of blog posts covering a host of Red Hat technologies that enable migrating from a monolith to microservices.  For the impatient, the third part highlights the usage of Teiid Spring Boot.  Ramesh has done great work getting this effort off the ground and we hope that it continues to gain attention and community usage.  Please interact with us through JIRA or the forums if you have a data integration or migration scenario with Spring Boot that Teiid could help enable.

Thanks,
Steve

Wednesday, October 25, 2017

Teiid 10.0.0 CR2 Released

Now that WildFly 11 Final is available, we have released Teiid 10.0.0.CR2.  A recap of all feature highlights:
  • TEIID-4981 Amazon S3 translator support, now read the objects directly from Amazon S3 with security
  • TEIID-5026 The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.
  • TEIID-1131 Added support for importing sequence information.
  • TEIID-5073 Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.
  • TEIID-4208 Added parallelism to plan execution involving large sorts.
  • TEIID-5002 Upgraded to WildFly 11
  • TEIID-4711 Generalized IS DISTINCT support.
Additionally there were recent changes to refine Osi Pi integration, improve with clause performance, and add more import options. 

Given that this has been longer than our usual time box release, there have been a total of 162 issues addressed so far.  Please ensure that your issues have been addressed as expected before the final release.

In the works:
  • Spring Boot integration is should be considered beta level.  See the current state.  There will be additional documentation and development around supporting Teiid 11, but it is expected to have a somewhat independent life cycle to meet community needs.
  • Expect a 10.0.0.Final in a week to 10 days.
Thanks,
Steve

Monday, October 23, 2017

Teiid 9.3.4 Released

Teiid 9.3.4 has been released.  It resolves 21 issues:
  • [TEIID-4567] - UCASE and LCASE functions do not work with CLOBs.
  • [TEIID-4870] - Google translator unexpected behavior for view update without trigger
  • [TEIID-5039] - Couchbase document type definition for a table
  • [TEIID-5041] - Couchbase documentID column enforced also in a view
  • [TEIID-5063] - Issues with bigdecimal values and odata
  • [TEIID-5065] - Unable to connect to VDB having names with unicode characters
  • [TEIID-5067] - Incorrect source query with simple inherent updates
  • [TEIID-5068] - Couchbase retrieval causes ClassCastException
  • [TEIID-5069] - Blob getBytes() handling of input streams reads the stream multiple times without a reset
  • [TEIID-5075] - Couchbase incorrect update count returned
  • [TEIID-5076] - Couchbase update syntax error
  • [TEIID-5077] - Couchbase strange behaviour for long numbers
  • [TEIID-5081] - FORMATTIMESTAMP is not pushed down to postgresql but formattimestamp is
  • [TEIID-5082] - Salesforce default URL incorrect
  • [TEIID-5085] - NullPointerException after SortUtility blocks in initialSort
  • [TEIID-5090] - Issues with matview scripts
  • [TEIID-5094] - Is DISTINCT FROM evaluation with two null values
  • [TEIID-5098] - Unsyncronized static date format for Salesforce bulk inserts
  • [TEIID-5104] - BigInteger mapped to string for OData 4
  • [TEIID-5107] - teiid-olingo-*.war not deploying in wildfly when using domain
  • [TEIID-5109] - Set operations and parenthesis
This fix pack was delayed slightly as several important issue came up prior to release.  Notice that Couchbase support continues to be refined, but the issues are getting more targeted to narrow functional areas.

Unfortunately we are still on hold with Teiid 10.0.0.CR2 as we wait on the release of WildFly 11.  It is expected any day now.  Teiid 10.0.0.Final should follow about a week after that.

Thanks,
Steve

Friday, October 6, 2017

Teiid 10.0.0.CR1 Released

Even though we do not yet have a WildFly 11 final, we have released Teiid 10.0.0.CR1.  This may mean that a CR2 will be needed.  A recap of all feature highlights:
  • TEIID-4981 Amazon S3 translator support, now read the objects directly from Amazon S3 with security
  • TEIID-5026 The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.
  • TEIID-1131 Added support for importing sequence information.
  • TEIID-5073 Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.
  • TEIID-4208 Added parallelism to plan execution involving large sorts.
  • TEIID-5002 Upgraded to WildFly 11
In the works:
  • Spring Boot integration is on-going.  You can see the incremental progress
  • Expect a 9.3.4 next week.
Thanks,
Steve