Teiid

Teiid 10.2.2 addresses 14 issues: [ TEIID-5336 ] - Improve TEIID-5253 [ TEIID-4784 ] - Provide functionality to perform RENAME table in DDL scripts [ TEIID-5324 ] - MongoDB: SecurityType "None" is not working [ TEIID-5328 ] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior [ TEIID-5329 ] - Problem with salesforce url [ TEIID-5330 ] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer [ TEIID-5331 ] - LEAD/LAG ignores ORDER BY in the OVER clause [ TEIID-5333 ] - Complex foreign keys set the referenced key regardless of order [ TEIID-5334 ] - Improve pg/ODBC mapping of char type [ TEIID-5335 ] - "No value was available" in ROW_NUMBER while inserting in foreign temporary table [ TEIID-5339 ] - Vertica join query fails due to unexpected ordering of intermediate results [ TEIID-5342 ] - If excel FIRST

We are pleased to announce the release of Teiid 10.3.1 (A regression with TEIID-5314 caused an immediate patch release).  See all 48 issues addressed.  The feature highlight are: TEIID-5293 Added implicit partition wise joining in non-multisource scenarios as well. TEIID-5308 Added ENV_VAR and SYS_PROP functions and clarified the usage of the ENV function. TEIID-4745 Added a polling query to trigger the reload of materialized views. TEIID-5317 Added ODBC 3.0 functions current_time, current_date, current_timestamp. TEIID-5314 Environment variables can now be used instead of or to override system properties. TEIID-5307 Added more information_schema tables for pg compatibility. TEIID-4864 Added update support to the Excel translator. Special thanks to the many community members who contributed to this release - in particular Andreas Krück, Divyesh Vallabh, Mathieu Rampant, Mike Higgins, Pedro Inácio, Yuming Zhu, Michael Echevarria, and Bram Gadeyne. We should also ext

Teiid 10.1.4 has been released. It resolves 12 issues: [ TEIID-5336 ] - Improve TEIID-5253 [ TEIID-4784 ] - Provide functionality to perform RENAME table in DDL scripts [ TEIID-5319 ] - SAP IQ translator wrong pushdown of query with multiple JOINs [ TEIID-5324 ] - MongoDB: SecurityType "None" is not working [ TEIID-5326 ] - SAP IQ timestamp conversion to varchar wrong resulting format [ TEIID-5328 ] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior [ TEIID-5329 ] - Problem with salesforce url [ TEIID-5330 ] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer [ TEIID-5331 ] - LEAD/LAG ignores ORDER BY in the OVER clause [ TEIID-5333 ] - Complex foreign keys set the referenced key regardless of order [ TEIID-5339 ] - Vertica join query fails due to unexpected ordering of intermediate results [ TEIID-5342 ] -

Kudos to one of our of community user "Kulbushan Chaskar" writing his experiences and use-cases that he solved using Teiid. Please read his blog at  http://kulbhushanchaskar. blogspot.in/2018/05/teiid- simplifies-data- virtualization.html