Wednesday, April 16, 2014

Teiid 8.7 Final Released

Teiid 8.7 has been released and is now available for download and from the Maven repository.  This was both a rich feature and a fix release with over 100 issues addressed.

Main features in this release include:
  • TEIID-1070 Amazon SimpleDB support has been contributed by Radim Hopp. See the Admin and Reference Guides for more. See example here
  • TEIID-2761 Security Enhancements added support for a grant-all attribute on a role. Also added the ability to specify the security domain for a VDB. See the reference guide for more.
  • TEIID-2780 Apache Solr Translator has been added. See the Admin and Reference Guides for more. See example here
  • TEIID-2809 Pattern based system property substitution has been added to VDB.XML files. Only supported if the DVB is being deployed JBoss EAP.
  • TEIID-2844 Remove unauthorized columns from SELECT * can be enabled via the session property ignore_unauthorized_asterisk. See the Reference for more.
  • TEIID-2863/TEIID-2761 More robust GSS-API support. This issue also implements a feature where a user can now define a "security-domain" per VDB. User no longer has to depend upon the transport level authentication.
  • TEIID-2826 Revamped build structure for translators and connectors so that it is easier to package them and deploy them to a Teiid server.
  • TEIID-2859 TEXTTABLE FOR ORDINALITY a FOR ORDINALITY column can now be used with TEXTTABLE. See the Reference for more.
  • TEIID-965 Apache POI based Excel connectivity has been added. See the reference for more. See example here
  • TEIID-2888 Designer VDB support in Embedded is now available. With a few caveats, Designer .INDEX based vdbs can now be used with Teiid Embedded. See the Embedded Guide for more.
  • TEIID-2904 Translator Properties Translator import, override and extension-metadata properties are can retrieved through Admin API
  • TEIID-2627 Accumulo Translator has been added. See Admin and Reference guides for more information. See example here
We sincerely thank everyone who participated in the community.  All bugs/posts are helpful in refining Teiid.  We are looking forward to your input on 8.8.

If have been using Teiid and would like fully supported version, Red Hat has released Data Virtualization V6 (DV6).  The DV platform has comprehensive support from Red Hat including services/training.

Thanks,
Steve and Ramesh

Friday, March 28, 2014

8.7 CR1 Posted

8.7 CR1 has been posted to the downloads.  Since Beta2 this release includes features such as:
  • TEIID-2859 TEXTTABLE FOR ORDINALITY a FOR ORDINALITY column can now be used with TEXTTABLE. See the Reference for more.
  • TEIID-965 Apache POI based Excel connectivity has been added. See the Reference for more.
  • TEIID-2888 Designer VDB support in Embedded is now available. With a few caveats, Designer .INDEX based vdbs can now be used with Teiid Embedded. See the Embedded Guide for more. 
There is also a new framework for translator to supply importer and extension metadata for better integration with Designer.  This will likely evolve slightly before the final release.  Also there is a small KI with this release affecting custom delegating translators.  If you experience an issue with a custom delegating translator, please follow master or wait for CR2.

In total we are closing in on 100 issues for this release and anticipate a release date around 4/16.  Thanks for all of the great feedback, please do check out the candidate releases as we still have time to refine/add fixes before final.

Teiid 8.8 will be kicking off shortly with the CR out of the way.  Take a pass through JIRA or log additional issues if there are things that you want to see make it into the next release.

Thanks,
Steve

Thursday, March 20, 2014

Read Microsoft Excel Document As Relational Table Using Teiid

If you are thinking, who in this age of big data with Hadoop, MongoDB et.al one still bothers to fiddle around with Excel? In reality there are still lot of corporate users out there, do their analytics and reporting using Excel. So, this is still is very important source of data.

From very early versions of Teiid, Teiid supported consuming the data from Microsoft Excel documents, however it always relied upon the "Excel" ODBC driver that came built in Windows platforms. Teiid then used "jdbc-odbc" bridge driver provided by Oracle's JDK to read the data in. Although this solution worked most of the time, it was very tedious and sprinkled with issues and limited the access to Windows platform.

In latest version of Teiid 8.7, a new translator is introduced which is based Apache POI framework, which gives platform independent way to read Excel documents. This is worked out to be much more simple and also gave a way define the metadata for the data in Excel Documents.

If you are interested, I wrote a step-by-step example for this here https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable

Ramesh..

Monday, March 17, 2014

Making business intelligence systems more agile with data virtualization By Rick van der Lans

This is excellent opportunity for all customers, prospects and partners to hear from industry expert and analyst Rick van der Lans as he discusses the IT strategy to build agile business intelligence systems and transforming data into competitive advantage using Jboss data virtualization middleware.  This session will provide great insights into leveraging data virtualization technology to improve delivery of business intelligence systems and data warehouse utilization.  

Time: Wednesday, March 19, 2014 | 15:00 UTC | 11 a.m. (New York) / 4 p.m. (Paris) / 8:30 p.m. (Mumbai)

About Rick van der Lans, managing director, R20/ConsultingRick is an independent consultant, author, and lecturer specializing in data warehousing, business intelligence, big data, data virtualization, and database technology. He has written the industry's first independent book on data virtualization titled, “Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses.” Rick has advised many large companies worldwide on defining their data warehouse, business intelligence, and SOA architectures. He is the chairman of the European Enterprise Data and BI Conference and writes regularly for B-eye-Network.com.

http://app.engage.redhat.com/e/es.aspx?s=1795&e=332131&elq=24680766e7f746ac85a30a30deed2454

Wednesday, March 12, 2014

Teiid 8.7 Beta2

Teiid 8.7 Beta2 is released today. The features since Beta 1 include

  • TEIID-2863/TEIID-2761 This issue fixes the previous issues with GSS-API in ODBC transport. This issue also implements a feature where a user can now define a "security-domain" per VDB. User no longer has to depend upon the transport level authentication.
  • TEIID-2870: Join types that are allowed and pushed to source can be set on the Foreign Key as metadata or allow them to use federated join.
  • TEIID-2826: revamped build structure for translators and connectors, so that it is easier to package them and deploy them to Teiid server
Many other bugs have been fixed. We may be in last couple weeks of development on 8.7 version, so start testing your usecases and let us know any small features we can sneak it in. Once we get to CR1 (which may be next) then there will be no more feature work, we will only work on bug fixes from then on to 8.7 Final (in 3~4 weeks).

Thank you.

Ramesh..

Teiid Designer 8.4.0 Final Released

Teiid Designer 8.4 Final is now available our update site or download the archive.

The primary driver for this release was to upgrade the Teiid client compatibility to include Teiid 8.6 release as well as working a number of bug fixes and a few new features and improvements.

Check out our What's New for 8.4 article for details...

Barry LaFond
Teiid Designer Team

Thursday, March 6, 2014

Teiid on OpenShift

Are you looking for solution where Teiid deployed on PaaS solution like OpenShift? Please look at below articles that show two separate examples n OpenShift.

1) Provision Data Virtualization on OpenShift and Connect from Teiid Designer
https://community.jboss.org/wiki/ProvisionDataVirtualizationOnOpenShiftAndConnectFromTeiidDesigner

2) Salesforce as a REST Service using Data Virtualization
https://community.jboss.org/wiki/SalesforceAsARESTServiceUsingDataVirtualization

Please take a test drive, let us know your comments.

Thanks

Ramesh..