Teiid

I am excited to announce that Teiid Spring Boot version 1.5.0 released today to the maven repository based on Teiid 14.0.0 release. If you have not used Teiid Spring Boot before, it is built on top Teiid Core libraries with developer simplification in mind. It simplifies the deployment model to a single VDB and provides you with executable binary rather than Server like WildFly where you need to deploy your VDBs. The release highlights are * Cassandra Data Source support * Materialization automation * Spring Boot version to 2.2.6 * Keystore/Truststore simplifications that work across the system * SOAP Data Source support * FTP Database Support * A Lot of changes to detect data sources based on their inclusion as dependencies and consistent naming schemes across both Teiid and Teiid Spring Boot. For a full list see this Take look at the various examples in Teiid Spring Boot and take it for test drive let me know if there are any issues or improvements you see. Ramesh...

If you have been following Teiid lately we have been going through a whole lot of renovations. Yes, renovations or reorganization or refactoring or whatever you want to call it. Basically, we are making Teiid more modular with fewer dependencies that can be used by however your use case dictates rather than use it as one monolith application deployed into WildFly JEE Application Server. There is nothing wrong in using Teiid as server model, but with the proliferation of container-based workloads and cloud-based architectures, the previous server-based model does not work or simply won't scale. So, we needed to think of alternatives, thus Teiid team introduced a couple different versions modular Teiid what we are calling as "Teiid Runtimes". Note that in these modular Teiid runtimes, not all the features you were used to using in Teiid Server model may not be there but you will have extensions to add in those that are most appropriate for your domain. I...

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...

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