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

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.


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.

Friday, April 21, 2017

Teiid 9.3 Beta1 Released

Teiid 9.3 Beta1 has been released.  Feature highlights since Alpha2 include:
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
Feature Progress:
  • Couchbase connectivity TEIID-2820 has been committed and will evolve from here. Thanks Kylin great work.
  • SQLAlchemy/Superset access TEIID-4578 has been committed but will still undergo additional changes with more testing.
If you have any interest please evaluate these in progress features as they mature.
Beyond the feature work, there were a lot general issues addressed - nearly 90 issues have been resolved so far.

Other news:
  • A Teiid 9.2.3 will be available in about 2 weeks.
  • Teiid 10.0 work will begin in about 3 weeks.  It is anticipated there will be major changes and cleanups for that release.

Saturday, April 15, 2017

Teiid 9.2.2 Released

Teiid 9.2.2 is now available.  This fix release covers 13 issues:
  • [TEIID-4501] - Salesforce 34 resource adapter should default to the 34 api
  • [TEIID-4812] - Processor is not exiting the join as soon as it's determined one side contains 0 rows
  • [TEIID-4814] - BatchedUpdateException should be provided for JDBC prepared statement batches
  • [TEIID-4816] - SQL Server 2012+ offset order by issue
  • [TEIID-4819] - Tree page modifications removing the previous page, don't remove immediately
  • [TEIID-4823] - joining 2 procedures results in QueryPlannerException: TEIID30275 Join region with unsatisfied access patterns cannot be satisfied by the join criteria
  • [TEIID-4828] - ST_GeomFromGeoJson fails for certain geometry types
  • [TEIID-4830] - Parsing Error when deploying VDB with "geometry" as column name
  • [TEIID-4832] - NullPointException in GroupingNode.initialize
  • [TEIID-4844] - Google translator unexpected behavior for comparison with time
  • [TEIID-4845] - Google translator comparison with boolean value matches all rows
  • [TEIID-4852] - Wrong OData results with multiple self relationships
Teiid 9.3 Beta1 is expected this coming week.  Also if there is a need for a 9.1.5, please let us know - only 3 issues have been addressed there so far.


Wednesday, March 29, 2017

Teiid 9.3 Alpha2 Released

Teiid 9.3 Alpha2 has been released.  Feature highlights since Alpha1 include:
Feature Progress:
  • Couchbase connectivity is still progressing under TEIID-2820
  • JDG integration continues to get easier - but some major changes are coming, including move the JDG connectivity to its own repository TEIID-4820
Beyond the feature work, there were a lot general issues addressed - nearly 70 issues have been resolved so far.

Other news:

  • A Teiid 9.2.2 will be available in the next 1-2 weeks.
  • JIRA issue cleanup has been ongoing.  There's quite a few backlog issues that should still be dealt with.
  • Teiid 10.0 work will begin by the end of April.  It is anticipated there will be major changes and cleanups for that release.

Tuesday, March 14, 2017

Teiid 9.2.1 Released

Teiid 9.2.1 is now available.  This fix release covers 18 issues:
  • [TEIID-4765] - The notion of resolving order may need to be extended beyond a schema
  • [TEIID-4788] - DDL vdb is expensive to process
  • [TEIID-4809] - lob performance issues
  • [TEIID-4770] - The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
  • [TEIID-4771] - The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
  • [TEIID-4774] - Convert VDB utility does not work when translator overrides are present
  • [TEIID-4776] - Issues with array type metadata
  • [TEIID-4783] - missing message keys for functions
  • [TEIID-4785] - Add options through alter table in DDL does not work.
  • [TEIID-4791] - Bypass lookup function's keycolumn reserved word
  • [TEIID-4797] - Oracle: empty catalog messed up VDB schemas name
  • [TEIID-4807] - DDL format of a vdb lacks import information
  • [TEIID-4652] - SybaseIQ translator: DAYOFYEAR function not pushed correctly
  • [TEIID-4653] - SybaseIQ translator: Input parameter not set in prepared statement in source command
  • [TEIID-4775] - External materialization, after transaction timeout, LoadState continues to be LOADING
  • [TEIID-4778] - External Materialization, When TTL is less than loading time, the scheduling is off
  • [TEIID-4780] - Clone TEIID-4734 (Backwards compatible solution)
  • [TEIID-4782] - Change framework to catch RutineException from translator/connector
Note that several of these are related to the new DDL vdb feature - thanks Bram Gadeyne for the initial feedback.  This feature will continue to evolve even in 9.2.x to maintain forward compatibility with 9.3.x.

Looking forward, Teiid 9.2.2 should be available in 3-4 weeks.