Teiid

8.2 Alpha2 has been posted to the downloads: http://www.jboss.org/teiid/downloads   Teiid 8.2, is beginning to be feature packed release with a long overdue feature of exception handling in virtual procedures. A developer can write code like RAISE SQLEXCEPTION .. and capture that event in the client with a SQLException. Read more about it at https://docs.jboss.org/author/display/TEIID/Procedure+Language   Native Query support is expanded. What is native query, how is it related? Well a native query any arbitrary command (SQL or otherwise) that is specific to a given source. With this new feature, every Teiid translator provides a mechanism, where you can submit any native command directly to the physical source through translator, and translator will execute and return the results. Why you need it? Well, taking an example of Oracle, lets say you have written a very specialized optimized query and you would like to submit as is with out Teiid re-writing it, then this is way ...

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 Teiid Team is very excited to announce the availability of Teiid 8.1-Final for JBoss AS 7.1.1 .  If you are working with Teiid 8.0, we highly recommend to migrate to 8.1-Final version, as we have about 100 issues resolved along with many new features. In Teiid 6.x versions, Teiid used to support a "embedded" version, this feature has been removed from 7.x versions, now it has been resurrected  with slightly different purpose. Teiid Embedded The main purpose of "Teiid Embedded" is to provide a data virtualization framework with full metadata definitions, query planning and query optimizations across multiple disparate sources with full query features minus any platform specific details such as external vdb deployments, connection management, clustering, authentications etc.  This provides a perfect environment to write a very specific data integration and virtualization needs in any vertical market for your application with out any JBoss AS specific dependencie...

Teiid 8.1 CR1 is now available for deployment on AS7 7.1.1-Final . We are excited to be closing in on the final release.  New features since Beta1 include:  TEIID-1598 Translator Result Caching - translators can interact with the result set caching facility via a CacheDirective. See the Developer's Guide for more. TEIID-2077 Result reuse - the engine will automatically detect if the same source query is used multiple times in a plan and reuse the result rather than issuing another query. TEIID-2113 Misc parser improvements - the parser will now accept the LATERAL keyword for defining a LATERAL join (previously we just used the TABLE keyword), unary negation is now supported e.g. -col1, the FOR keyword is optional for TEXTAGG, and the BNF documentation was dramatically improved. TEIID-2036 Dependent Join Array Comparison - platforms supporting array comparisons can have multi-attribute dependent joins pushed down as array comparisons. Oracle, PG, and ...

If you have been working with Teiid 7.7 version and would like a supported version then look no further than EDS 5.3 from Red Hat .  Red Hat just announced release of their Enterprise Data Services Platform 5.3 which is based on the community projects Teiid and ModeShape and many more. Some of the key highlights include New data sources: Greenplum, PostgreSQL 9, Apache Hive (tech preview) Performance enhancements New wizards, guides, cheatsheets to enhance tooling usability. If you are already a subscriber of EDS from Red Hat, then can you download the bits from Red Hat portal now. This also comes with supported tooling JBoss Developer Studio 5.0. Check out new wizards that can help you consume web services or file based sources with ease in EDS. If you are contemplating on why do you need supported version? well if you are going to deploy a critical application into production environment and need immediate assistance on the product then supported version i...

Teiid 8.1 Beta1 is now available for deployment on AS7 7.1.1-Final . New features include:  VDB Reuse a vdb.xml can now declare imported vdbs to reuse metadata.  See the Reference for more. Comparable Object - the system property org.teiid.comparableObject can be set to use OBJECT values in comparison/sorting/grouping operations. It is expected that the object values correctly implement Comparable.compareTo. Admin Metadata - you can now retrieve metadata in DDL from the admin api via the getSchema method. Improved VDB loading - vdb loading logic was refined to make administration easier. ExecutionFactory now has is/setSourceRequiredForMetadata() to indicate whether a source connection is needed for the getMetadata call. VDB reuse is a powerful feature that enables a lighter-weight approach to sharing schema/models across VDBs.  Design time support will come in a future Designer release. Overall issue fixing has been brisk with 69 issues addre...

A very successful Red Hat Summit and JBoss World 2012 with over 3300 attendees from all over the world happened this week in Boston Hynes Convention Centre.  In last one week Red Hat has released many products. EAP6 Data Grid   OpenShift JBoss Enterprise BRMS 5.3 JBoss Enterprise SOA and Enterprise Data Services Platforms Red Hat Storage There were many varieties of sessions, it was evident that big data and cloud computing has taken prominent spot light. JBoss keynote was so good, there was not even standing room in 800+ capacity session hall. If you have not seen it you can watch it here http://www.youtube.com/watch?v=t1cud4tP4Us&feature=youtu.be If you have not already taken look at GlusterFS (Red Hat Storage), it is just  magic where you can take commodity hard drives and turn them into big data storage solution all with software. I have attended couple sessions on Data Grid by Manik, they were very informative in educating the user about Big Da...