Monday, June 12, 2017

Teiid 9.2.4 Released

Teiid 9.2.4 has been released.  7 issues were addressed:
  • [TEIID-4858] - hive translator is extremely slow
  • [TEIID-4838] - View with a union that projects nulls fails to resolve properly
  • [TEIID-4875] - Planning issue with multiple aggregate decompositions through a join tree
  • [TEIID-4913] - MetadataFactory is not replacing . in column names
  • [TEIID-4927] - Update dockerfile
  • [TEIID-4942] - Statement batch does not enforce autoCommitTxn
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
From here the pace of fix releases for 9.2 will begin to slow.  The next fix will be released in 6-8 weeks.  9.3.x will become the primary focus of support - expect a 9.3.1 in 2-3 weeks.

Also the first preview release of 10.0 will be due out in about 1.5 weeks.

Thanks,
Steve

Friday, June 9, 2017

Teiid 9.1.5 Released

Teiid 9.1.5 has been released.  This will be the last patch release off of 9.1.x.

9 issues were addressed:
  • [TEIID-4797] - Oracle: empty catalog messed up VDB schemas name
  • [TEIID-4819] - Tree page modifications removing the previous page, don't remove immediately
  • [TEIID-4852] - Wrong OData results with multiple self relationships
  • [TEIID-4877] - Boolean syntax is broken on pg 9.5 data sources
  • [TEIID-4890] - DatabaseMetadata Procedure Columns order is incorrect
  • [TEIID-4892] - oData v4 error using $expand
  • [TEIID-4893] - Inconsistent behavior of SUBSTRING function
  • [TEIID-4927] - Update dockerfile
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
We will continue to support 9.2 and 9.3.  Expect a 9.2.4 release early next week.

Thanks,
Steve

Tuesday, June 6, 2017

Teiid 9.3 Final Released

With about 3 1/2 months of work, 138 issues later, 9.3 Final release is ready.  Feature highlights include:
  • TEIID-3624 CREATE DOMAIN support for user-defined simple types.
  • TEIID-4724 DDL .vdb deployment.
  • TEIID-4557 TEIID-2465 Memory restrictions at the operation and session level.
  • TEIID-4578 SQLAlchemy and Superset support through our pg/odbc access.
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
  • TEIID-2820 Couchbase support via a new translator and resource adapter.
  • TEIID-4733 Infinispan Support via a new translator and resource adapter.
There were also several important planning issues that were resolved including: More join pruning and left outer join optimization.

DDL VDB support has been enhanced to be nearly equivalent to of its XML counterpart.  We will continue to improve the usability, feature set, and refine the syntax when necessary.


UI Work

If you haven't seen it, please also check out Data Service Builder - which is a streamlined web UI for JDV/Teiid. We will release a Designer version based on Teiid 9.3 in near future. However after that Designer will be mostly in maintenance mode.  We are going to focus more on Web-based UI for future.

10.x and Beyond

Although initially slated for 9.3 change data capture (CDC) event handling based on Debezium to keep the materialization tables in sync with source data sources like MySQL and PostgreSQL will be delayed until 10.0 or later.

With the emergence of Cloud-based processing and Microservices architectures, we have been taking a hard look at Teiid and how we could progress technology into future. We have laid out some initial plans about our thinking and some immediate actions. We are soliciting your input all these matters, so please get involved so that we can shape Teiid together.

Thanks again to everyone who contributed to this release.
Ramesh & Steve

Friday, May 26, 2017

Teiid 9.3 CR1

Teiid 9.3 CR1 has been released.  A recap of all feature highlights:
  • TEIID-3624 CREATE DOMAIN support for user defined simple types.
  • TEIID-4724 DDL .vdb deployment.
  • TEIID-4557 TEIID-2465 Memory restrictions at the operation and session level.
  • TEIID-4578 SQLAlchemy and Superset support through our pg/odbc access.
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
  • TEIID-2820 Couchbase support via a new translator and resource adapter.
  • TEIID-4733 Infinispan Support via a new translator and resource adapter.
There have been 136 issues addressed so far - https://issues.jboss.org/projects/TEIID/versions/12332954 - please test your issues if possible before the final release in early June.

Other news:
  • A Teiid 9.1.5 will be released shortly after 9.3 Final.
  • Teiid 10.0 work has begun.
    • Please comment on TEIID-4895 with regards to WildFly utilization.  Comments on JRE support are welcome as well - can you describe what circumstances may be holding you to 1.6 or 1.7?
    • We will likely start including the Data Services Builder in the all-in-one download.  Data Services Builder and other efforts will be at the forefront of offering data virtualization on OpenShift.
Thanks,
Steve

Thursday, May 11, 2017

Teiid 9.2.3 Released

Teiid 9.2.3 is now available.  This fix release covers 12 issues:
  • [TEIID-4861] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4868] - formats in timestampformat functions on sybase are ignored.
  • [TEIID-4874] - SQL Server translator should support full outer join by default
  • [TEIID-4875] - Planning issue with multiple aggregate decompositions through a join tree
  • [TEIID-4876] - Salesforce connector not working properly in 9.2.2 release
  • [TEIID-4877] - Boolean syntax is broken on pg 9.5 data sources
  • [TEIID-4887] - Domain mode configuration fails with CNF
  • [TEIID-4890] - DatabaseMetadata Procedure Columns order is incorrect
  • [TEIID-4892] - oData v4 error using $expand
  • [TEIID-4893] - Inconsistent behavior of SUBSTRING function
  • [TEIID-4899] - import foreign schema "import qualifiers" problem
Thanks,
Steve

Tuesday, May 9, 2017

Teiid 10 Planning

As we get closer to staring on Teiid 10.x, we want to elicit as much community feedback on our initiatives as possible.  Some of the major themes are:
  • Refining our messaging around and our usage of WildFly TEIID-4895
  • Removal of the XML document model logic TEIID-4894 and other deprecated features
  • Spring Boot TEIID-4863 and eventually vert.x support
  • More documentation and demos around microservices
  • General project updates including 
    • more build automation
    • possibly do away with pre-release names (e.g. Beta1) and instead promote specific micro releases
    • Relicense under a more permissive license TEIID-4474
Of course there's a lot more already in the 10.0 and 10.x release buckets as well.  Please provide whatever feedback you can - especially on WildFly usage.  Also have a look at all of your relevant issues and comment or vote on any that need more immediate inclusion.

Beyond the core project we are in the initial stages of working towards an OpenShift ready data integration suite including:
If you have any desire to coordinate on these additional efforts, please let us know so that we can loop you in once the appropriate git and other resources are in place.

Thanks,
Steve

Monday, May 8, 2017

Teiid 9.3 Beta2 Released

Teiid 9.3 Beta2 has been released.  Feature highlights since Beta1 include:
  • TEIID-4733 Infinispan Support via a new translator and resource adapter.
The new infinispan support greatly simplifies integration with Infinispan 9.0+. And over 110 issues have been resolved so far - please test your issues if possible before the final release.

Other news:
  • We have a GSOC student Artyom Lyan who will be working on an OrientDB translator. Welcome Artyom!
  • A Teiid 9.2.3 will be available tomorrow.
  • Teiid 9.3 CR1 will be released in about 2 weeks.
  • Teiid 10.0 work will begin in about 1 week.  It is anticipated there will be major changes and cleanups for that release.
Thanks,
Steve