Skip to main content

Teiid 7.5 Beta1

7.5 Beta1 is now available. While mainly a fix release, there have been notable features since 7.4:
  • Subquery optimization control - added the DJ hint to indicate that a subquery should be the independent side of a dependent join.
  • MAKEIND Hint - The MAKEIND hint can be used to indicate that the other side of the join should be made dependent.
  • ODBC SSL - added support for SSL encrypted ODBC connections.
  • Reauthentication Statement - SET SESSION AUTHORIZATION can now be used to perform a reauthentication via JDBC or ODBC.
  • Pluggable Authorization - an alternative PolicyDecider can be defined in the teiid-jboss-beans.xml file to customize authorization decisions.
  • Streaming XQuery - in situations where document projection applies if the XMLQUERY/XMLTABLE path expressions meet certain conditions, then the incoming document will not only be projected, but the independent subtrees will be processed without loading the entire document. This allows for nearly arbitrarily large XML documents to be processed. See the Reference for more.
  • Logging Procedures - added SYSADMIN.isLoggable and SYSADMIN.logMsg to aid in debugging procedure logic.
  • ANSI OFFSET/FETCH FIRST - instead of the limit clause, a standard OFFSET and/or FETCH FIRST/NEXT clause can be used to limit results.
As always see the release notes for more. For even more detailed information on these or any pending issues, check out the JIRA issues here. Please check any of your issues that have been resolved and log new ones before it's too late to hit the release.

The Teiid Team

Comments

Popular posts from this blog

Authenticating datasources with LDAP or Kerberos in Amazon AWS

This blog is mainly to showcase one of the community success story with Teiid and Amazon AWS. The need for our community user Ben Kibler  was to provide data sources in AWS be participating in Kerberos authentication. Not only participating, he wanted to provide a consistent usage and access pattern, and a light weight integration layer  for these data sources. He choose Teiid embedded for this purpose, and provided an extension to hook Auth services back into their corporate Active Directory.  With that his applications can participate in kerberos auth with Teiid, and then same token will be delegated to underlying data sources in Amazon AWS. The rest was provided by Teiid. Read more about it and find the supporting code at https://developer.jboss.org/message/920818#920818 We love to here about your success stories on Teiid. Also, if something is not working for you as you expect, then come engage us in a discussion, together we can solve the issue the OSS way! Thank You BenK

Teiid on OpenShift demo is available!

We now have a Teiid demo available for deployment to OpenShift.  Teiid allows you to access and integrate data from a variety of distributed data sources - in real-time, without moving your data from its system of record.  OpenShift is Red Hat's Cloud Computing Platform as a Service (PaaS) offering. You can now deploy the Teiid engine to a free OpenShift cloud instance and try it for yourself!  To get your free demo started today, see our install instructions . The demo provides easy-to-follow articles which will show you how to access and integrate data from three disparate sources: MySQL database containing account data Twitter feed webservice Salesforce instance These are just a few of the many sources you can access with Teiid.  And with Teiid, you can easily join any of the sources to create your own federated data views! We also show you how to access your Teiid-OpenShift VDB (virtual database) in a number of ways:  Submit ad-hoc queries via the provided browse

Teiid Spring Boot 1.7.0 Released

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