tag:blogger.com,1999:blog-31089450862948104052024-03-13T00:07:10.322-05:00TeiidTeiid is a Data Virtualization System for your Enterprise, convert the data you have to data you need!Teiid Projecthttp://www.blogger.com/profile/17430093389488513545noreply@blogger.comBlogger302125tag:blogger.com,1999:blog-3108945086294810405.post-4885064816407127482021-01-06T09:24:00.000-06:002021-01-06T09:24:15.174-06:00Teiid Spring Boot 1.7.0 Released<p>Teiid Spring Boot version 1.7.0 to support Teiid 16.0 has been released. This release is mainly to support the Teiid's latest version. </p><p>In this release, the support for OpenAPI code generation based on VDB has been removed as there is no community interest and moreover it was at OpenAPI 2.0, and the industry has moved to 3.0 and beyond. There are no plans to further pursue this feature.</p><p>VDB maven plugin was also removed, which was intended to be a replacement for the VDB importing feature was to be used when working on OpenShift, however, since it requires the Maven repository and does not completely represent the feature as defined on the WildFly based deployments this is also removed. You can still use the VDB import feature with Teiid Spring Boot, simply define the VDB with your "IMPORT DATABASE" statements and provide the additional files along with the main VDB file. During the start of the application, Teiid Spring Boot will load all the necessary DDL files for the VDB.</p><p>The Spring Boot version is upgraded to 2.3.4.RELEASE</p><p><br /></p><p>Ramesh..</p>Rameshhttp://www.blogger.com/profile/06446272275326253759noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-13382309494012757882020-05-22T17:52:00.000-05:002020-05-22T17:52:18.010-05:00Teiid Spring Boot 1.5.0 Released<div dir="ltr" style="text-align: left;" trbidi="on">
I am excited to announce that Teiid Spring Boot version 1.5.0 released today to the maven repository based on <a href="http://teiid.io/blog/post-140000/">Teiid 14.0.0</a> release.<br />
<br />
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.<br />
<br />
The release highlights are<br />
<br />
* Cassandra Data Source support<br />
* Materialization automation<br />
* Spring Boot version to 2.2.6<br />
* Keystore/Truststore simplifications that work across the system<br />
* SOAP Data Source support<br />
* FTP Database Support<br />
* 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.<br />
<br />
For a full list see <a href="https://issues.redhat.com/browse/TEIIDSB-57?jql=project%20%3D%20TEIIDSB%20AND%20fixVersion%20%3D%201.5.0%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC">this</a><br />
<br />
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.<br />
<br />
Ramesh..</div>
Rameshhttp://www.blogger.com/profile/06446272275326253759noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-12765477501106228182019-01-18T16:35:00.000-06:002019-01-18T16:35:56.625-06:00Teiid Runtimes Explained<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
If you have been following <a href="https://teiid.io/">Teiid</a> 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".<br />
<br />
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. If you are looking for a data virtualization system in any configuration, one of below should satisfy your needs.<br />
<br />
Now that we know what Teiid is up to, what are different flavors of these Runtimes? Basically, we have four different varieties.<br />
<br />
<ol style="text-align: left;">
<li>Teiid Server with <a href="http://wildfly.org/">WildFly</a> (legacy model)</li>
<li>Teiid Embedded</li>
<li>Teiid <a href="https://spring.io/projects/spring-boot">Spring Boot</a></li>
<li>Teiid <a href="https://thorntail.io/">Thorntail</a></li>
</ol>
<br />
<h3 style="text-align: left;">
Teiid Server on WildFly</h3>
<div>
This is the legacy runtime that Teiid team has been supporting for a while, the support for this will be continuing to new versions of WildFly. Currently, with the release of <a href="http://teiid.io/teiid_runtimes/teiid_wildfly/downloads/">Teiid 12.0</a>, the WildFly support is at <a href="http://wildfly.org/downloads/">WildFly 14.</a> Going forward there will be a separate repo for the WildFly based deployments that is different from current Teiid git repo. This repository will contain only code that is specific to WildFly. To use this version one needs to be little knowledgable in WildFly server, but typically no Java experience is needed but recommended. If you want you can build Docker images based on this as a Server just like say MySQL or PostgreSQL image.</div>
<div>
<br /></div>
<div>
<a href="https://github.com/teiid/teiid/tree/master/wildfly">GitRepo</a></div>
<div>
<a href="https://github.com/teiid/teiid-quickstarts">Examples</a></div>
<h3 style="text-align: left;">
Teiid Embedded</h3>
<div>
I would call this and rest of other runtimes below as "frameworks" where they do not provide a fully functioning system, but Teiid provides the essential APIs and hooks to design your own system with ease. Teiid Embedded is the plainest version of all, where you have a whole lot of autonomy to design to your use case and embed Teiid in your own JVM. There are plenty of examples to you started. When using this Java experience is required. This is ideal for anyone wanting to embed in their own project/product in OEM fashion.</div>
<div>
<br /></div>
<div>
<div>
<a href="https://github.com/teiid/teiid">GitRepo</a></div>
<div>
<a href="https://github.com/teiid/teiid-embedded-examples">Examples</a></div>
</div>
<h3 style="text-align: left;">
Teiid Spring Boot</h3>
<div>
It is no secret that Spring Boot most popular among Java developers. This runtime uses Spring Boot and Teiid Embedded to bring Data Virtualization features for Java developer in a way that they are already familiar to them. For example, it is as simple as using JPA framework. This one is my current favorite, as this supports legacy VDB file based deployments and also JPA based view definitions where explicit VDB does not need to be defined. It also has a feature called "redirection", where it can make it possible to use production data for testing without modifying it. If you are Spring Boot developer there is not much more you need to learn as most of the Data Virtualization will be instrumented in by using a set of annotations. This would be an ideal framework to use if you are thinking of using Teiid in Microservices architecture. If you are looking into container-based deployments and cloud architectures this is an ideal platform. The examples will show how to deploy into OpenShift or Kubernetes using <a href="https://maven.fabric8.io/">fabric8-maven-plugin</a>.</div>
<div>
<br /></div>
<div>
There is limited support for different sources currently we only support <a href="https://github.com/teiid/teiid-spring-boot/tree/master/samples/rdbms-file">relational sources</a>, <a href="https://github.com/teiid/teiid-spring-boot/tree/master/samples/excel">excel</a>, <a href="https://github.com/teiid/teiid-spring-boot/tree/master/samples/rest">REST</a>. But this support will be expanding.</div>
<div>
<br /></div>
<div>
<div>
<a href="https://github.com/teiid/teiid-spring-boot">GitRepo</a></div>
<div>
<a href="https://github.com/teiid/teiid-spring-boot/tree/master/samples">Examples</a></div>
</div>
<div>
<br /></div>
<h3 style="text-align: left;">
Teiid Thorntail</h3>
<div>
Thorntail is a Microprofile based Java framework that is designed for Java-based Microservices using standards-based technologies. Thorntail was previously named "WildFly Swarm". Since this Thorntail 2.x technology was mostly based on WildFly there good support for most of the features that were available in Teiid Server. We will continue to support 2.x Thorntail. If you want a system close to WildFly technology but in embedded Microservice style application then choose this version. this version is also good for using as container-based workloads for cloud environments. This supports similar features as spring boot in this area.</div>
<div>
<br /></div>
<div>
When Thorntail 4.x rolls around we have to reevaluate the support there as that is assumed to be vastly different from Thorntail 2.x, and we expect that would be a complete rewrite.</div>
<div>
<br /></div>
<div>
<div>
<a href="https://github.com/teiid/teiid-thorntail">GitRepo</a></div>
<div>
<a href="https://github.com/teiid/teiid-thorntail/tree/master/examples">Examples</a></div>
</div>
<div>
<br /></div>
<h3 style="text-align: left;">
What about UI?</h3>
<div>
As you probably noticed the pace of Teiid Designer releases stopped, as we are not putting in any more work into eclipse based tooling. The existing Teiid Designer should be still valid to use in the design of your VDBs if you prefer as they VDB you build will be deployable in any of the above Teiid Runtimes. However, Teiid Runtimes also support dynamic VDBs that one can build by hand or programmatically.</div>
<div>
<br /></div>
<div>
We are also collaborating/integrating Teiid technology with Syndesis community, there you will see a UI to build and deploy Teiid based runtime. More on this later in future blogs.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Let us know your opinion as we shape Teiid for future workloads while supporting the legacy.</div>
<div>
<br /></div>
<div>
Ramesh..</div>
</div>
Rameshhttp://www.blogger.com/profile/06446272275326253759noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-70939347563928422512018-05-23T13:52:00.001-05:002018-05-23T13:52:45.362-05:00Teiid 10.2.2 Released<a href="http://teiid.io/teiid_four_ways/teiid_wildfly/downloads/">Teiid 10.2.2</a> addresses 14 issues:
<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5336">TEIID-5336</a>] - Improve TEIID-5253
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-4784">TEIID-4784</a>] - Provide functionality to perform RENAME table in DDL scripts
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5324">TEIID-5324</a>] - MongoDB: SecurityType "None" is not working
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5328">TEIID-5328</a>] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5329">TEIID-5329</a>] - Problem with salesforce url
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5330">TEIID-5330</a>] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5331">TEIID-5331</a>] - LEAD/LAG ignores ORDER BY in the OVER clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5333">TEIID-5333</a>] - Complex foreign keys set the referenced key regardless of order
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5334">TEIID-5334</a>] - Improve pg/ODBC mapping of char type
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5335">TEIID-5335</a>] - "No value was available" in ROW_NUMBER while inserting in foreign temporary table
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5339">TEIID-5339</a>] - Vertica join query fails due to unexpected ordering of intermediate results
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5342">TEIID-5342</a>] - If excel FIRST_DATA_ROW_NUMBER is past all rows, the last row is still used
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5345">TEIID-5345</a>] - ClassCastException if multi-column dependent join is pushed to literals
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5347">TEIID-5347</a>] - low level MetadataFactory properties not honored by DDL import
</li>
</ul>
You can expect the next fix release in 4-5 weeks.
Thank you,
Steve
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-3155380784221800792018-05-22T09:27:00.000-05:002018-05-22T09:27:01.092-05:00Teiid 10.3.1 ReleasedWe are pleased to announce the release of <a href="https://teiid.github.io/teiid.io/teiid_four_ways/teiid_wildfly/downloads/">Teiid 10.3.1</a> (A regression with TEIID-5314 caused an immediate patch release). See all <a href="https://issues.jboss.org/projects/TEIID/versions/12337178">48 issues</a> addressed. The feature highlight are:<br />
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-5293">TEIID-5293</a> Added implicit partition wise joining in non-multisource scenarios as well.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5308">TEIID-5308</a> Added ENV_VAR and SYS_PROP functions and clarified the usage of the ENV function.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4745">TEIID-4745</a> Added a polling query to trigger the reload of materialized views.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5317">TEIID-5317</a> Added ODBC 3.0 functions current_time, current_date, current_timestamp.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5314">TEIID-5314</a> Environment variables can now be used instead of or to override system properties.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5307">TEIID-5307</a> Added more information_schema tables for pg compatibility.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4864">TEIID-4864</a> Added update support to the Excel translator.</li>
</ul>
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.<br />
<br />
We should also extend a warm welcome to <a href="https://github.com/rkorytkowski">Rafal Korytkowski</a> to the Teiid Team. Rafal has begun by finishing off the work on the <a href="https://issues.jboss.org/browse/TEIID-4520">Exosal translator</a> and will help with efforts related to cloud and OpenShift support.<br />
<br />
Other Important Stuff:<br />
<ul>
<li>The new website is (mostly) live! See <a href="https://teiid.io/">teiid.io</a>. There are no under construction animated GIFs, but you can expect a few issues as we get the new Hugo/Netlify/Travis build worked out. Notice that we're effectively combining tooling and backend under a single site. The content is being updated to be more relevant for cloud and OpenShift deployments. A lot of work is happening in creating a <a href="https://github.com/teiid/beetle-studio">self-service data virtualization OpenShift based solution</a>. If you have any interest in becoming involved, or would like to see more around the <a href="https://github.com/teiid/teiid-komodo/">image build/configuration</a> please let us know.</li>
<li>Teiid 10.2.2 and 10.1.4 will be available in the next couple of days. That will effectively end support for the 10.1.x release stream.</li>
</ul>
<div>
Thank you,</div>
<div>
The Teiid Team</div>
<br />
<br />Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-5762782405327174442018-05-22T07:19:00.001-05:002018-05-22T07:19:45.544-05:00Teiid 10.1.4 ReleasedTeiid <a href="http://teiid.jboss.org/downloads_10x/">10.1.4</a> has been released. It resolves 12 issues:
<ul>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5336'>TEIID-5336</a>] - Improve TEIID-5253
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-4784'>TEIID-4784</a>] - Provide functionality to perform RENAME table in DDL scripts
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5319'>TEIID-5319</a>] - SAP IQ translator wrong pushdown of query with multiple JOINs
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5324'>TEIID-5324</a>] - MongoDB: SecurityType "None" is not working
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5326'>TEIID-5326</a>] - SAP IQ timestamp conversion to varchar wrong resulting format
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5328'>TEIID-5328</a>] - regression of org.teiid.padSpace does not affect to the "IN" operator behavior
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5329'>TEIID-5329</a>] - Problem with salesforce url
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5330'>TEIID-5330</a>] - FIRST_VALUE/LAST_VALUE/LEAD/LAG functions always try to return integer
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5331'>TEIID-5331</a>] - LEAD/LAG ignores ORDER BY in the OVER clause
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5333'>TEIID-5333</a>] - Complex foreign keys set the referenced key regardless of order
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5339'>TEIID-5339</a>] - Vertica join query fails due to unexpected ordering of intermediate results
</li>
<li>[<a href='https://issues.jboss.org/browse/TEIID-5342'>TEIID-5342</a>] - If excel FIRST_DATA_ROW_NUMBER is past all rows, the last row is still used
</li>
</ul>
This concludes the community releases on 10.1.x. Please upgrade to 10.2 or 10.3. 10.2.2 will be released tomorrow.
Thanks,
Steve
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-40143125414659613192018-05-07T11:08:00.000-05:002018-05-08T08:04:14.835-05:00Community User Perspective on Teiid use cases and how it simplifies developement<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "verdana" , sans-serif;">Kudos to one of our of community user "Kulbushan Chaskar" writing his experiences and use-cases that he solved using Teiid.</span><br />
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">Please read his blog at </span><a data-saferedirecturl="https://www.google.com/url?hl=en&q=http://kulbhushanchaskar.blogspot.in/2018/05/teiid-simplifies-data-virtualization.html&source=gmail&ust=1525647040834000&usg=AFQjCNGS0E56v5Uxb7cNG-XVm6b4ggZ6Sw" href="http://kulbhushanchaskar.blogspot.in/2018/05/teiid-simplifies-data-virtualization.html" style="background-color: white; color: #1155cc; cursor: auto; font-family: arial, sans-serif; font-size: 12.8px; text-decoration-line: none;" target="_blank">http://kulbhushanchaskar.<wbr></wbr>blogspot.in/2018/05/teiid-<wbr></wbr>simplifies-data-<wbr></wbr>virtualization.html</a><span style="background-color: white; color: #222222; font-family: "arial" , sans-serif; font-size: 12.8px;"> </span></div>
</div>
Rameshhttp://www.blogger.com/profile/06446272275326253759noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-54586040808538732212018-04-20T12:55:00.002-05:002018-04-20T12:55:56.178-05:00Teiid 10.2.1 ReleasedTeiid 10.2.1 has been <a href="http://teiid.jboss.org/downloads/">released</a>. It resolves 12 issues:<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5293">TEIID-5293</a>] - Add implicit partitioning of joins to non-multisource partitioning as well
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5220">TEIID-5220</a>] - Add support for information_schema namespace
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5294">TEIID-5294</a>] - Bug with the name correction logic (TEIID30151 eror)
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5296">TEIID-5296</a>] - With MongoDB, timestamp operations throw exceptions when called on null or missing values
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5297">TEIID-5297</a>] - With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5300">TEIID-5300</a>] - ClassCastException during query Optimization
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5310">TEIID-5310</a>] - updateMatView does not check for null validity
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5312">TEIID-5312</a>] - NullPointerException thrown when the second time login via GSS API
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5313">TEIID-5313</a>] - Oracle translator issue with mixing string types and general issues with non-ascii strings
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5315">TEIID-5315</a>] - MATVIEW_MAX_STALENESS_PCT reloads only based upon ttl
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5319">TEIID-5319</a>] - SAP IQ translator wrong pushdown of query with multiple JOINs
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5320">TEIID-5320</a>] - SAP IQ translator wrong pushdown of dateadd function
</li>
</ul>
If you have time please check out the latest 10.3 snapshot. We are about half way mark in the cycle.
<br />
<br />
Thanks,<br />
Steve
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-71487066033068671772018-04-17T18:27:00.001-05:002018-04-17T18:27:12.392-05:00Teiid 10.1.3 ReleasedTeiid 10.1.3 has been <a href="http://teiid.jboss.org/downloads/">released</a>. It resolves 13 issues:<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5293">TEIID-5293</a>] - Add implicit partitioning of joins to non-multisource partitioning as well
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5265">TEIID-5265</a>] - AssertionError: Batch not found in storage
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5288">TEIID-5288</a>] - OData4 skiptoken is not pulling from the cached results
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5290">TEIID-5290</a>] - NOW() function returns the same value for each call in BEGIN...END block
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5294">TEIID-5294</a>] - Bug with the name correction logic (TEIID30151 eror)
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5296">TEIID-5296</a>] - With MongoDB, timestamp operations throw exceptions when called on null or missing values
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5297">TEIID-5297</a>] - With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5300">TEIID-5300</a>] - ClassCastException during query Optimization
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5301">TEIID-5301</a>] - With MongoDB, a query with subquery in HAVING clause doesn't return any results
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5310">TEIID-5310</a>] - updateMatView does not check for null validity
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5312">TEIID-5312</a>] - NullPointerException thrown when the second time login via GSS API
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5313">TEIID-5313</a>] - Oracle translator issue with mixing string types and general issues with non-ascii strings
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5315">TEIID-5315</a>] - MATVIEW_MAX_STALENESS_PCT reloads only based upon ttl
</li>
</ul>
Up next will be a 10.2.1 by the end of the week.
Thanks,
Steve
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-79341923268827610072018-04-02T07:29:00.004-05:002018-04-02T07:30:42.833-05:00Teiid 10.0.5 ReleasedTeiid 10.0.5 has been <a href="http://teiid.jboss.org/downloads_10x/">released</a>. It resolves 8 issues:<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5293">TEIID-5293</a>] - Add implicit partitioning of joins to non-multisource partitioning as well
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5288">TEIID-5288</a>] - OData4 skiptoken is not pulling from the cached results
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5290">TEIID-5290</a>] - NOW() function returns the same value for each call in BEGIN...END block
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5294">TEIID-5294</a>] - Bug with the name correction logic (TEIID30151 eror)
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5296">TEIID-5296</a>] - With MongoDB, timestamp operations throw exceptions when called on null or missing values
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5297">TEIID-5297</a>] - With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5300">TEIID-5300</a>] - ClassCastException during query Optimization
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5301">TEIID-5301</a>] - With MongoDB, a query with subquery in HAVING clause doesn't return any results
</li>
</ul>
This is the final community release on the 10.0.x line. Please upgrade to 10.1 or 10.2 when possible.
<br />
<br />
Planning and work has begun on Teiid 11 and Teiid 10.3 respectively. Teiid 11 will align with WildFly 12, while Teiid 10.3 will likely be the last minor release on 10.x.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com2tag:blogger.com,1999:blog-3108945086294810405.post-30467261594581264602018-03-21T17:49:00.000-05:002018-03-21T17:49:21.501-05:00Teiid 10.2.0 ReleasedWe are pleased to announce the release of <a href="http://teiid.jboss.org/downloads/">Teiid 10.2.0</a>. This was the new normal of an 8 week cycle. See all <a href="https://issues.jboss.org/projects/TEIID/versions/12336552">54 issues</a> addressed. The feature highlight are:<br />
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-5236">TEIID-5236</a> Updated support for GeoServer and 9.4+ PostgreSQL JDBC drivers.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5246">TEIID-5246</a> Simplified configuration when using an external load balancer.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5248">TEIID-5248</a> v4 Api Support for Google Spreadsheets.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5220">TEIID-5220</a> Additional Npgsql support via limited information_schema support.</li>
</ul>
Other Important Stuff:<br />
<ul>
<li>Several important OData translator issues were addressed - if you use the OData translator, you should upgrade or use next fix release 10.0.5/10.1.3</li>
<li>Teiid 10.1.3 and 10.0.5 will be available in about 3 weeks.</li>
</ul>
Special thanks to the many community members who contributed to this release - in particular dalex dalex, Bram Gadeyne, Divyesh Vallabh, and Yuming Zhu.<br />
<br />
<div>
Thank you,</div>
<div>
The Teiid Team</div>
<br />
<br />Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-33110307393697714562018-03-15T18:34:00.000-05:002018-04-02T07:26:40.955-05:00Teiid 10.1.2 ReleasedTeiid 10.1.2 has been <a href="http://teiid.jboss.org/downloads/">released</a>. It resolves 13 issues:<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5176">TEIID-5176</a>] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5268">TEIID-5268</a>] - Anonymous bind login doesn't work for ldap connector
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5269">TEIID-5269</a>] - Odata4 metadata roundtrip is not in place
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5271">TEIID-5271</a>] - Joining more than one table/view to results of table function causes error
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5274">TEIID-5274</a>] - Odata4 translator can't handle conditions on columns which use conversions
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5275">TEIID-5275</a>] - OData4 translator doesn't handle IS NOT NULL condition properly
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5276">TEIID-5276</a>] - ClassCastException with OData4 translator when using COUNT function without GROUP BY clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5277">TEIID-5277</a>] - OData4 translator doesn't correctly translate LOCATE function to INDEXOF
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5278">TEIID-5278</a>] - Wrong indexing with SUBSTRING function and OData4 translator
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5279">TEIID-5279</a>] - OData4 translator incorrecly translates modulo function
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5280">TEIID-5280</a>] - OData4 translator: disappearing negation when using 'in' predicate
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5281">TEIID-5281</a>] - Issue with concatenating null strings with OData translator
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5283">TEIID-5283</a>] - Recursive WITH query results in "java.lang.ClassCastException: org.teiid.query.sql.lang.Query cannot be cast to org.teiid.query.sql.lang.SetQuery"
</li>
</ul>
<div>
For those who have logged issues against 10.2, please review the fixes before the final release next weak.</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Steve</div>
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-58179896047454772142018-03-14T15:00:00.000-05:002018-03-14T12:47:43.263-05:00Teiid 10.0.4 Released<span style="font-family: "times new roman";">Teiid 10.0.4 has been </span><a href="http://teiid.jboss.org/downloads/" style="font-family: "times new roman";">released</a><span style="font-family: "times new roman";">. It resolves 17 issues:</span><br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5176">TEIID-5176</a>] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5253">TEIID-5253</a>] - Timing issue in domain mode with materialization
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5254">TEIID-5254</a>] - Unhandled exception when making a multipart post to a rest varbinary value
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5255">TEIID-5255</a>] - Assertion failed in MergeJoinStrategy.setProcessingSortRight
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5256">TEIID-5256</a>] - Sysadmin Usage table doesn't track usage of procedures
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5260">TEIID-5260</a>] - TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5268">TEIID-5268</a>] - Anonymous bind login doesn't work for ldap connector
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5269">TEIID-5269</a>] - Odata4 metadata roundtrip is not in place
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5271">TEIID-5271</a>] - Joining more than one table/view to results of table function causes error
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5274">TEIID-5274</a>] - Odata4 translator can't handle conditions on columns which use conversions
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5275">TEIID-5275</a>] - OData4 translator doesn't handle IS NOT NULL condition properly
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5276">TEIID-5276</a>] - ClassCastException with OData4 translator when using COUNT function without GROUP BY clause
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5277">TEIID-5277</a>] - OData4 translator doesn't correctly translate LOCATE function to INDEXOF
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5278">TEIID-5278</a>] - Wrong indexing with SUBSTRING function and OData4 translator
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5279">TEIID-5279</a>] - OData4 translator incorrecly translates modulo function
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5280">TEIID-5280</a>] - OData4 translator: disappearing negation when using 'in' predicate
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5281">TEIID-5281</a>] - Issue with concatenating null strings with OData translator
</li>
</ul>
10.1.2 will be released in the next couple of days. 10.2 is expected later next week.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-59861201991101887362018-02-27T13:55:00.000-06:002018-02-27T13:55:16.064-06:00Teiid 10.1.1 Released<span style="font-family: "times new roman";">Teiid 10.1.1 has been </span><a href="http://teiid.jboss.org/downloads/" style="font-family: "times new roman";">released</a><span style="font-family: "times new roman";">. It resolves 13 issues:</span><br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5236">TEIID-5236</a>] - Document and update GeoServer/PG JDBC compatibility
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5242">TEIID-5242</a>] - XML/JSON issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5247">TEIID-5247</a>] - SQL Server translator should support coalesce
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5241">TEIID-5241</a>] - Problem with OData proxy configuration
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5243">TEIID-5243</a>] - Embedded SessionService does not monitor sessions
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5245">TEIID-5245</a>] - Killed remote jdbc connections to an embedded server allowed to continue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5250">TEIID-5250</a>] - Duplicate result uid reported when using procedure isFunction=true
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5251">TEIID-5251</a>] - OData WAR Module issue with WildFly-Swarm
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5253">TEIID-5253</a>] - Timing issue in domain mode with materialization
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5254">TEIID-5254</a>] - Unhandled exception when making a multipart post to a rest varbinary value
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5255">TEIID-5255</a>] - Assertion failed in MergeJoinStrategy.setProcessingSortRight
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5256">TEIID-5256</a>] - Sysadmin Usage table doesn't track usage of procedures
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5260">TEIID-5260</a>] - TEIID30020 Processing exception for request, "select * into" doesn't work in some cases
</li>
</ul>
10.2 is expected in about 3 to 4 weeks with 10.0.4 sometime before then.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-28893320652908886932018-02-09T13:53:00.003-06:002018-02-09T13:53:44.866-06:00Teiid 9.3.7 ReleasedTeiid 9.3.7 has been <a href="http://teiid.jboss.org/downloads/">released</a>. It resolves 10 issues:
<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5190">TEIID-5190</a>] - Postgresql translator does not support expressions in group by
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5242">TEIID-5242</a>] - XML/JSON issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5200">TEIID-5200</a>] - INSERT INTO query fails in BEGIN ATOMIC block if data is obtained from atomic procedure which catches some exception
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5203">TEIID-5203</a>] - Google Spreadsheet translator NPE thrown on UPDATE
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5204">TEIID-5204</a>] - NOW() is calculated several times for SYS tables
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5221">TEIID-5221</a>] - OData4 Translator generates invalid metadata
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5241">TEIID-5241</a>] - Problem with OData proxy configuration
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5245">TEIID-5245</a>] - Killed remote jdbc connections to an embedded server allowed to continue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5250">TEIID-5250</a>] - Duplicate result uid reported when using procedure isFunction=true
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5253">TEIID-5253</a>] - Timing issue in domain mode with materialization
</li>
</ul>
This will be the last community release on the 9.3.x line. Please upgrade to 10.x if possible - there is a short <a href="https://teiid.gitbooks.io/documents/content/admin/Migration_Guide_From_Teiid_9.x.html">migration guide</a> to help with the process.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-67596911694558906312018-02-06T14:33:00.002-06:002018-02-06T14:33:51.022-06:00Teiid 10.0.3 Released<span style="font-family: "times new roman";">Teiid 10.0.3 has been </span><a href="http://teiid.jboss.org/downloads/" style="font-family: "times new roman";">released</a><span style="font-family: "times new roman";">. It resolves 17 issues:</span><br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5174">TEIID-5174</a>] - Filter internal constructs from oracle metadata
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5190">TEIID-5190</a>] - Postgresql translator does not support expressions in group by
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5242">TEIID-5242</a>] - XML/JSON issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5247">TEIID-5247</a>] - SQL Server translator should support coalesce
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5136">TEIID-5136</a>] - Osisoft translator - NPE when running query with inline view
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5140">TEIID-5140</a>] - Teiid 10 postgres driver version
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5203">TEIID-5203</a>] - Google Spreadsheet translator NPE thrown on UPDATE
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5217">TEIID-5217</a>] - preserve hint should be honored by rule plan outer joins
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5221">TEIID-5221</a>] - OData4 Translator generates invalid metadata
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5226">TEIID-5226</a>] - Error when inserting a Geometry value into PostgreSQL
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5227">TEIID-5227</a>] - Error when inserting a NULL value into a PostgreSQL Geometry datatype column
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5235">TEIID-5235</a>] - Could not find symbol in processing an inline view using except
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5241">TEIID-5241</a>] - Problem with OData proxy configuration
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5243">TEIID-5243</a>] - Embedded SessionService does not monitor sessions
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5245">TEIID-5245</a>] - Killed remote jdbc connections to an embedded server allowed to continue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5250">TEIID-5250</a>] - Duplicate result uid reported when using procedure isFunction=true
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5251">TEIID-5251</a>] - OData WAR Module issue with WildFly-Swarm</li>
</ul>
For those still on 9.3, 9.3.7 is expected later this week.<br /><br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-49272103554741367992018-01-30T15:02:00.000-06:002018-01-30T15:02:21.995-06:00Data Integration for Java Developers - Introducing "Teiid Spring Boot"<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "verdana" , sans-serif; font-size: large;">Are you trying to integrate data from a REST web service with a data in your legacy RDBMS database? How about data from Excel or CSV file, JSON, XML, MongoDB contents? As Java developers we know how to read the data from these sources and how to stitch data together, all it takes some boilerplate code right?</span><br />
<span style="font-size: large;"><span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">How about running some filters on that data, working with data type incompatibilities between data sources like converting a string type to decimal, doing aggregations like grouping the records by certain parameters and finally exposing it as REST service and you got 30 minutes do it?</span></span><br />
<span style="font-size: large;"><span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif;">If you have NOT heard about Teiid (t-ee-d) before, this software is exactly what it is designed to do. It has many more features, but let's focus on Data Integration feature. One of the basic features of Teiid is to provide ways to integrate data from multiple disparate sources where it knows how to work with data type incompatibilities and provides a relational data engine that can plan a very optimized query to fetch only the data that you are interested in and let you combine data with the power of SQL. </span></span><br />
<span style="font-size: large;"><span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif;">If you have used Teiid before, you may have configured data sources in WildFly Server and designed Virtual Databases using Designer or Dynamic VDBs with DDL and deployed them into Teiid Server and used JDBC from your Java application to query it. </span></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif; font-size: x-large;"><b>Now, there is completely a "new" way to approach the problem with simplified options for Java developers. No more VDBs or Servers etc.</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif; font-size: large;">We are introducing a brand new sub-project called "<a href="https://github.com/teiid/teiid-spring-boot">Teiid Spring Boot</a>" for Java developers which unleashes the same power and flexibility of Teiid's Data Integration and Virtualization features while harnessing the power of Spring Boot where using the conventions over configuration makes it developing an application much much more simple.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxKIz2Jz087QQIPtb0egddoqDclYPV_S3eDHs-biapHduENVvBuOGGSkGY1ZouRVx-wZdZTotYGVSCN8WxFmoh9paYf7ySrUtD2WvdXDE1xOFxk4hzoD_2z38-Irl-EgF40jvuLzzqabnc/s1600/tsb.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="288" data-original-width="620" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxKIz2Jz087QQIPtb0egddoqDclYPV_S3eDHs-biapHduENVvBuOGGSkGY1ZouRVx-wZdZTotYGVSCN8WxFmoh9paYf7ySrUtD2WvdXDE1xOFxk4hzoD_2z38-Irl-EgF40jvuLzzqabnc/s400/tsb.png" width="400" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif; font-size: large;">There are no lengthy APIs to learn if you are familiar with JPA and Spring Boot based programming, and SQL you already know most of it. The rest of the Teiid's Data Integration techniques that are defined using Java Annotations on the Entity you defined. For example, here are typical steps involved</span><br />
<span style="font-size: large;"><br /></span>
<ul style="text-align: left;">
<li><span style="font-family: "verdana" , sans-serif; font-size: large;">Define the data source(s) and provide the configuration parameters such as connection URL, username, password as Spring requires. </span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: large;">Write a JPA Entity (View) that you like to expose to your application</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: large;">Decorate JPA Entity with additional Teiid specific Java Annotation and provide any SQL based integration logic as needed based on data source created.</span></li>
<li><span style="font-family: "verdana" , sans-serif; font-size: large;">Use Spring Data API query your Entity model you created.</span></li>
</ul>
<span style="font-family: "verdana" , sans-serif; font-size: large;">If you are ready to take to this for spin take a look at <a href="https://github.com/teiid/teiid-spring-boot/blob/master/docs/UserGuide.adoc">this example</a> where data from two different Postgres databases are being integrated and shown in the single Entity.</span><br />
<span style="font-size: large;"><span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif;">This is especially exciting new framework if you are developing Spring Boot based Microservices and need to integrate with your legacy RDBMS but at the same time not compromise on database per service. More on this later in future blogs.</span></span><br />
<span style="font-family: "verdana" , sans-serif; font-size: large;"><br /></span>
<span style="font-family: "verdana" , sans-serif; font-size: large;">I encourage take 15 minutes and take it for a spin.</span><br />
<span style="font-size: large;"> <span style="font-family: "verdana" , sans-serif;"><br /></span> <span style="font-family: "verdana" , sans-serif;">Ramesh..</span></span><br />
<br /></div>
Rameshhttp://www.blogger.com/profile/06446272275326253759noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-68459162850946362382018-01-26T08:50:00.000-06:002018-01-26T08:50:51.245-06:00Teiid 10.1 ReleasedWe are pleased to announce the release of <a href="http://teiid.jboss.org/downloads/">Teiid 10.1.0</a>. This was a shorter that usual release cycle, but that should become the new normal. See all <a href="https://issues.jboss.org/projects/TEIID/versions/12336003">72 issues</a> addressed. The feature highlight are:<br />
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-5161">TEIID-5161</a> Broader pushdown of the RAND function.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5134">TEIID-5134</a> The -final designation has been dropped from major/minor releases, and weekly snapshots have replaced preview releases.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5201">TEIID-5201</a> NpgSQL client query support.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5222">TEIID-5222</a> General array type conversion.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5212">TEIID-5212</a> Additional optimization of join order with left outer joins.</li>
</ul>
Other Important Stuff:<br />
<ul>
<li>OsiSoft Pi support is now robust and should be suitable for most integration scenarios.</li>
<li>Teiid 10.0.3 and 9.3.7 will be available in about 2 weeks. 9.3.7 will likely be the last release on the 9.3 line.</li>
</ul>
Special thanks to the many community members who contributed to this release. In particular dalex dalex, Aditi Patel, Divyesh Vallabh, El Fuego who identified several important issues each.<br />
<br />
<div>
Thank you,</div>
<div>
The Teiid Team</div>
<br />
<br />Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-78105312524568665072018-01-09T13:05:00.000-06:002018-01-09T13:05:28.054-06:00Teiid 10.0.2 Released<span style="font-family: "times new roman";">Teiid 10.0.2 has been </span><a href="http://teiid.jboss.org/downloads/" style="font-family: "times new roman";">released</a><span style="font-family: "times new roman";">. It resolves 13 issues:</span><br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5176">TEIID-5176</a>] - Postgresql ODBC driver converts {fn CONCAT()} calls to a "textcat()" function
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-4851">TEIID-4851</a>] - Random errors about PostGIS without using it
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5164">TEIID-5164</a>] - Infinispan hotrod translator aggregate functions issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5168">TEIID-5168</a>] - PrestoDB translator - Convert to float not pushed correctly
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5178">TEIID-5178</a>] - doc formatting issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5183">TEIID-5183</a>] - NPE in Swagger translator
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5184">TEIID-5184</a>] - Clob not supported in dynamic VDB
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5186">TEIID-5186</a>] - NPE in QueryResolver when calling virtual procedure
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5189">TEIID-5189</a>] - Empty XmlElement throws an NPE when passed for the non-nullable parameter
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5198">TEIID-5198</a>] - Procedure names containing . do not resolve properly
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5199">TEIID-5199</a>] - Infinispan hotrod translator correlated subquery with where criteria issue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5200">TEIID-5200</a>] - INSERT INTO query fails in BEGIN ATOMIC block if data is obtained from atomic procedure which catches some exception
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5204">TEIID-5204</a>] - NOW() is calculated several times for SYS tables
</li>
</ul>
10.1 is expected in about 2 weeks. For anyone already using the PI translator, please pick up the latest snapshot as there have been quite a few fixes.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-59966604319656037242018-01-03T17:00:00.000-06:002018-01-09T13:01:26.532-06:00Teiid 9.3.6 Released<span style="font-family: "times new roman";">Happy New Year to everyone! After an end of year slow down, Teiid 9.3.6 has been </span><a href="http://teiid.jboss.org/downloads/" style="font-family: "times new roman";">released</a><span style="font-family: "times new roman";">. It resolves 11 issues:</span><br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-4851">TEIID-4851</a>] - Random errors about PostGIS without using it
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5027">TEIID-5027</a>] - Translator infinispan-hotrod incorrect data type import
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5153">TEIID-5153</a>] - RAND function gives same results in view
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5164">TEIID-5164</a>] - Infinispan hotrod translator aggregate functions issues
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5171">TEIID-5171</a>] - Forward navigation of expand returns wrong results.
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5172">TEIID-5172</a>] - Missing message for key "TEIID31262"
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5173">TEIID-5173</a>] - Swagger API mixup
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5183">TEIID-5183</a>] - NPE in Swagger translator
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5184">TEIID-5184</a>] - Clob not supported in dynamic VDB
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5189">TEIID-5189</a>] - Empty XmlElement throws an NPE when passed for the non-nullable parameter
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5198">TEIID-5198</a>] - Procedure names containing . do not resolve properly
</li>
</ul>
Expect a Teiid 10.1 in a couple of weeks.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-49990012107108879032017-12-06T13:43:00.001-06:002017-12-07T08:50:58.231-06:00Teiid 10.0.1 ReleasedTeiid 10.0.1 has been <a href="http://teiid.jboss.org/downloads">released</a>. It resolves 14 issues:
<br />
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5106">TEIID-5106</a>] - Tables names are case sensitive in Postgres/Oracle/MSSQL but not in Teiid.
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5154">TEIID-5154</a>] - Missing default method for IsDistinct
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5137">TEIID-5137</a>] - SystemAdmin.usage column dependency issue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5138">TEIID-5138</a>] - JGroups Channel creation in domain mode is invalid
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5139">TEIID-5139</a>] - Reached maximum thread count "10" for worker pool "async-teiid-threads"
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5140">TEIID-5140</a>] - Teiid 10 postgres driver version
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5146">TEIID-5146</a>] - UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5152">TEIID-5152</a>] - "No value was available" error message when evaluating an expression
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5153">TEIID-5153</a>] - RAND function gives same results in view
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5166">TEIID-5166</a>] - Google spreadsheet insert fails
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5171">TEIID-5171</a>] - Forward navigation of expand returns wrong results.
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5172">TEIID-5172</a>] - Missing message for key "TEIID31262"
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5173">TEIID-5173</a>] - Swagger API mixup
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5175">TEIID-5175</a>] - Binding of Hive date types should not use the calendar
</li>
</ul>
<div>
A 9.3.6 release will be made available before the end of the year.</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Steve </div>
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com2tag:blogger.com,1999:blog-3108945086294810405.post-57139347566703064312017-11-22T10:51:00.001-06:002017-11-22T10:51:09.373-06:00Teiid 9.3.5 Released<div>
Teiid 9.3.5 has been <a href="http://teiid.jboss.org/downloads/">released</a>. It resolves 8 issues:</div>
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5130">TEIID-5130</a>] - Document/refine behavior of treating result parameter as the first parameter
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5128">TEIID-5128</a>] - transaction support value not cloned on access node
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5133">TEIID-5133</a>] - XmlTable path language is not always identical to XPathValue expressions
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5137">TEIID-5137</a>] - SystemAdmin.usage column dependency issue
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5146">TEIID-5146</a>] - UNION of two similar JOIN queries fails with ASSERTION FAILED error if it contains table function of procedural call with arguments
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5152">TEIID-5152</a>] - "No value was available" error message when evaluating an expression
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5153">TEIID-5153</a>] - RAND function gives same results in view
</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5166">TEIID-5166</a>] - Google spreadsheet insert fails</li>
</ul>
<div>
For those in the US happy Thanksgiving. You can expect community activity to return to normal next week.</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Steve</div>
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-78401289633755181252017-11-06T19:40:00.000-06:002017-11-07T07:02:55.683-06:00Teiid 9.2.7 Released<div>
Teiid 9.2.7 has been <a href="http://teiid.jboss.org/downloads_9x//">released</a>. It resolves 6 issues:</div>
<ul>
<li>[<a href="https://issues.jboss.org/browse/TEIID-4870">TEIID-4870</a>] - Google translator unexpected behavior for view update without trigger</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5094">TEIID-5094</a>] - Is DISTINCT FROM evaluation with two null values</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5098">TEIID-5098</a>] - Unsyncronized static date format for Salesforce bulk inserts</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5107">TEIID-5107</a>] - teiid-olingo-*.war not deploying in wildfly when using domain</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5109">TEIID-5109</a>] - Set operations and parenthesis</li>
<li>[<a href="https://issues.jboss.org/browse/TEIID-5133">TEIID-5133</a>] - XmlTable path language is not always identical to XPathValue expressions</li>
</ul>
<div>
This is the last community release on the 9.2.x line.</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Steve</div>
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-554741001638516632017-11-02T18:54:00.002-05:002017-11-02T18:54:22.206-05:00Teiid 10.0.0.Final ReleasedAfter 5 months of work we are pleased to announce the release of <a href="http://teiid.jboss.org/downloads/">Teiid 10.0.0.Final</a>. 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 <a href="https://issues.jboss.org/projects/TEIID/versions/12332970">165 issues</a>. The major feature highlight are:<br />
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4981">TEIID-4981</a> Amazon S3 translator support, now read the objects directly from Amazon S3 with security</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5026">TEIID-5026</a> The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-1131">TEIID-1131</a> Added support for importing sequence information.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5073">TEIID-5073</a> Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4208">TEIID-4208</a> Added parallelism to plan execution involving large sorts.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5002">TEIID-5002</a> Upgraded to WildFly 11</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4711">TEIID-4711</a> Generalized IS DISTINCT support.</li>
</ul>
Other Important Stuff:<br />
<ul>
<li>Take note of <a href="https://teiid.gitbooks.io/documents/content/v/10.0.x/admin/Migration_Guide_From_Teiid_9.x.html">major changes</a> in the release in particular the removal of XML document models and switching the artifact group from org.jboss.teiid to org.teiid.</li>
<li><a href="https://github.com/teiid/teiid-spring-boot">Teiid Spring Boot</a> was launched make getting starting with Teiid and Spring seamless - thank you Ganesh Pol and Christian Posta for early testing</li>
<li>With TEIID-4208 and other performance enhancements you should expect to see a performance boost especially for higher data volume / lower query volume workloads.</li>
<li>Couchbase access is now quite robust</li>
<li>OsiSoft Pi access has gone under more review and will be continue to be refined in 10.1</li>
</ul>
Special thanks to the many community members who contributed to this release. In particular dalex dalex and Mike Higgins who identified several important issues.<br />
<br />
On the horizon:<br />
<ul>
<li>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.</li>
<li>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.</li>
</ul>
<div>
Thank you,</div>
<div>
The Teiid Team</div>
Steven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0tag:blogger.com,1999:blog-3108945086294810405.post-23355129173332261202017-10-26T18:39:00.000-05:002017-10-26T18:39:48.770-05:00Low-risk Monolith to Microservice Evolution<a href="http://blog.christianposta.com/">Christian Posta</a> has written a series of blog posts covering a host of Red Hat technologies that enable migrating from a <a href="http://blog.christianposta.com/microservices/low-risk-monolith-to-microservice-evolution/">monolith to microservices</a>. For the impatient, the <a href="http://blog.christianposta.com/microservices/low-risk-monolith-to-microservice-evolution-part-iii/">third part</a> 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.<br />
<br />
Thanks,<br />
SteveSteven Hawkinshttp://www.blogger.com/profile/05705343586174077184noreply@blogger.com0