Tuesday, November 20, 2012

Teiid 8.2 Final Released

Continuing our time boxed release schedule Teiid team is excited to announce availability of Teiid 8.2.Final.

In total there were 120 issues resolved - including 15 new features and over 50 bug fixes. See all the issues on Teiid's JIRA.

This release coincides with the first release of the Teiid Console for Teiid 8.x.  The Teiid Console is a web based administrative tool for configuration and monitoring and is also available from the downloads area. A big thanks to Heiko Braun for his support in developing this.

The Teiid Designer team is making great progress towards the Teiid Designer 8.0 which works with Teiid 8.2.Final. For early releases please see the Designer Downloads.

Teiid 8.2 is still based on JBoss AS 7.1.1  The JBoss AS 7.2 release is still TDB sometime after the rename process. You can help by voting for new name http://jboss.org/vote.  

Here are the feature highlights:
  • TEIID-1923 Teiid Console - A web based administrative console for Teiid.
  • TEIID-2150 Positional procedure defaults - a procedure now may be called positionally with just the leading input parameters as long as all trailing parameters are out or defaultable.
  • TEIID-2148 Streaming Improvements - the ws translator invoke/invokeHttp procedures now accept a "stream"" parameter to indicate that the result should be streamed directly without an intermediate copy being created. Also intermediate document/blob copies are made concurrently with reading to reduce latency.
  • TEIID-2158 Rest Services - when required extension metadata defined on the virtual procedure, a REST based service on that procedure is automatically generated and deployed upon VDB deployment.
  • TEIID-2163 Binary XMLSERIALIZE - XMLSERIALIZE now supports blob/varbinary and the encoding/version and XMLDECLARATION options.
  • TEIID-2141 OBJECTTABLE - was added to extract values from objects using arbitrary scripts. See the Reference for usage.
  • TEIID-2111 Vararg Procedures - variable argument procedures and functions can be created through DDL using the VARIADIC parameter type. See the Reference for usage.
  • TEIID-2195 Function Based Indexes - DDL can be used to specify function based indexes. When used on an internal mat view it will create the corresponding function based index automatically. In any other circumstance, the metadata is not currently used.
  • TEIID-2181 System query performance - system queries are now indexed on case-insensitive schema/table name columns.
  • TEIID-2086 Transactional results caching - the result set cache is now transactional by default.
  • TEIID-2210 Object Translator - the translator-object can support Infinispan Cache and other Map type caches. See OBJECTTABLE for executing queries against this translator.
  • TEIID-1386 Procedure exception handling - the Teiid procedure language now supports exception handling and emitting SQLWarnings. See the Reference for syntax and usage.
  • TEIID-2176,TEIID-2177 Native Query Support - JDBC, LDAP, SalesForce, JPA, OLAP translators now support execution of native queries directly against the source either through "native-query" extension metadata property or native procedure defined by their translator.
  • TEIID-2227 Procedure RETURN statement - the Teiid procedure language now supports a RETURN statement. See the Reference for syntax and usage.
  • TEIID-2269 Vault Support - The transport's keystore and truststore passwords are now supported through vault based passwords.
  • TEIID-1064 Google Spreadsheet Support - there is now support for querying Google Spreadsheets via Teiid. See the Reference and Admin Guides for more.
  • TEIID-2274, TEIID-2275, TEIID-2288, TEIID-2299 Converting examples to Quick Starts - The examples in the Teiid JBoss dist zip have been converted to Quick Starts and will now be found in the Quick Start kit.
This work was due in large part to the great participation from Teiid community users, a BIG thanks to all who participated especially Mark Addleman, Jack Ma, I Leitch, Vineela Gumpa, Samier Nadji, Graeme Gillies, Ivan Chan, David Eichmann, Hisanobu Okuda, Jaspal Singh, Mónica L.A., Rajasekhar Kota, Filip Nguyen in providing valuable input through their JIRAs and community suggestions.

How To Get Involved:

If you have useful features in mind for Teiid, please open a forum discussion and lets get them captured in JIRA for inclusion in the Teiid roadmap.  8.3 is just starting and can still be influenced based upon community need. 

If you are a developer, did you know Teiid source is now hosted on GitHub? Your contribution is just a fork away! 

If you are using Teiid, please blog about it and tell us how it is helping you solve your Data Virtulization needs. If you have/can create tutorials or videos about Teiid, please share with the community.

Thank you.

Ramesh & Steve

Monday, November 5, 2012

Introducing Teiid Admin Web Console - 1.0.CR1

Teiid team is very exited to introduce a new GWT based administrative console for Teiid starting with version 8.2.x

If you are already using slick JBoss AS7 web console, then you already know how good, quick and snappier it is to configure and manage JBoss AS7. Now, you can use the same console to configure and manage Teiid. This new console is an extension to the JBoss AS7 console, written using GWT based technology and uses AS7 DMR underneath for remote communication with Teiid Subsystem on JBoss AS7.

The code for Teiid Admin Web Console is  hosted at https://github.com/teiid/teiid-web-console

You can find some documentation at https://docs.jboss.org/author/display/TEIID/Teiid+Admin+Web+Console

With the new console you can
  • Configure  Teiid
  • Deploy VDBs
  • Check the status of the VDB
  • Check deployment errors of the VDB
  • View models in a VDB and check their properties and and any error associated with them
  • Check data roles, manage role assignments
  • Check current sessions logged against VDB
  • View current requests against a VDB and ability to cancel them
  • View the schema of a VDB
  • View the query-plan of a in-flight query
  • Check and manage the status materialization tables
and much more. Please download the Teiid Web Console and give it a try and give us feedback and what other features you would like to see in this tool future releases. Also if you like GWT programming and would like to contribute to the project please let us know.

Thank you.


Teiid 8.2 CR1 Posted And More

We're closing in on our next release with Teiid 8.2 CR1 now available for deployment on AS7 7.1.1-Final. New features include: 
  • TEIID-2269 Vault Support - The transport's keystore and truststore passwords are now supported through vault based passwords.
  • TEIID-1064 Google Spreadsheet Support - there is now support for querying Google Spreadsheets via Teiid. See the Reference and Admin Guides for more.
  • TEIID-1241 WSDL backed WS Translator - a web services data source can be configured to access a single server and point based upon a specific WSDL.
In total we have addressed over 100 issues (which is now common for a point release). Please ensure that all of your issues have been addressed satisfactorily as we likely release a CR2 before proceeding to final.  

The new Google spreadsheet support, which was an excellent contribution from Red Hatter's Filip Nguyen and Filip Elias, will hopefully be broadened into other Google services over time.

We're also looking at numerous doc clean-ups especially to our examples and quick starts.  You can also assist with the docs via comments or since document editing moderation is turned on, you can submit changes directly.

And finally if you're using Designer or new to Teiid in general, community member Gioppo Luca has been working on tutorials using the latest Teiid Designer release version 7.8 with Teiid 8.1.