Skip to main content

Posts

Showing posts from 2014

Teiid 8.10 Alpha2

Teiid 8.10 Alpha2 is now available from the  downloads  and maven.  Feature highlights include: TEIID-991 SybaseIQ Translator - for use with SybaseIQ 15.1 and later. TEIID-2882 PrestoDB Translator - for use with PrestoDB 0.85 and later. TEIID-1091 Additional SQL/XML Support - XMLEXISTS, XMLTEXT, and XMLCAST were added. TEIID-3216 Update Support for Google Spreadsheets Ramesh also introduced logic to support OAuth - Integrating Twitter With OAuth . There have been several JIRAs to increase compatibility including quoted set/show variables, temp table on commit clause, (the long overdue) -- single line comment, and set session characteristics for transaction isolation level. And of course there have been a host of other issues resolved - many of which originated from community users.  Special thanks to Filip Elias for contributing the update support for google spreadsheets. Steve

Expose Twitter data in Teiid, using OAuth Authorization

If you want to access Twitter data or any other REST web service (google, facebook etc) secured by OAuth 1.0A or OAuth 2.0 authentication schemes using Teiid, please read this article  https://developer.jboss.org/docs/DOC-52995  for an example. This feature will be available in Teiid starting from 8.10.Alpha2 release. Thanks. Ramesh..

Teiid Designer 9.0 Released

Teiid Designer 9.0 Final is now available via our update site or downloadable archive. This release focused on improving existing features and bug fixes. Primary drivers for this release were: Upgrade to Eclipse 4.4 Luna target platform and JBDS 8.0 GA Compatibility with Teiid 8.8 Runtime Bug fixing with special attention to issues on Windows OS Check out our What's New for 9.0 article for details... Barry LaFond Teiid Designer Team

Teiid 8.10 Alpha1

We've made steady progress on 8.10 and Alpha1 is now available from the  downloads  and maven.  Feature highlights include: TEIID-3192 Salesforce Connectivity - connectivity was converted to the partner api provided by Salesforce rather than utilizing CXF. Please log an issue if you were utilizing features from the CXF config. TEIID-3046 Recursive Common Table Expression - engine and push down support was added. TEIID-3163 TEIID-3167 Text Table Enhancements - to support a general no trim option and to use a different row delimiter. We expect progress with Olingo, but it appears that their final won't be available until March.  Due to that and other needs we will likely produce an 8.11 as well. There will be several new sources coming in the 8.10 release including SybaseIQ and PrestoDB.  HBase is likely and there should be a couple more if time permits. Thanks in advance for the community effort as we work toward the 8.10 release and be sure to let us know

Teiid 8.9 Final Released

The Teiid community is excited to announce yet another (nearly) time boxed release of its Data Virtualization software - version 8.9. This release took an extra 4 weeks on top of regular 12 weeks to accommodate a NEW version of the host environment -  JBoss EAP 6.3.0 Alpha . You can find the Teiid downloads at  http://teiid.jboss.org/downloads/ A little over 100 issues were resolved and this is looking to be solid release. The major features include: TEIID-3009 WITH project minimization - common table expressions will have their project columns minimized. TEIID-3038 geoSpatial support for MongoDB translator TEIID-3050 Increased Insert Performance with sources that support batching or insert with iterator. TEIID-3044 Function Metadata is available through system tables and DatabaseMetaData. TEIID-1910 TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven. TEIID-3119 Performance improvements in gro

Teiid 8.9 CR3

It seems that CR2 was well received or at least there were no major issues with the switch to EAP 6.3 Alpha.  So now we are moving onto 8.9 CR3, which is available in the  downloads  and maven.  The final release should be expected within the next 10 days. There are a couple of fixes beyond what was in CR2 and we are up to 116 total issues addressed for this release.  Work has begun on 8.10.  Expect an 8.10 Alpha about a week after the 8.9 Final.  Now is a great time to vote for or log issues to be included in that release. Thanks, Steve

Teiid 8.9 CR2

We are happy and trepidatious about the availability of 8.9 CR2 in the downloads and maven.  This moves us closer to the final, but introduces two important and late changes: The target platform is now EAP 6.3 Alpha.  This platform change better aligns us with more recent product releases and removed the need for applying the RESTEasy patch. We also have a high degree of confidence in the changes as we have already been through this effort for productizing DV 6.1. You may however need to be signed into a jboss.org account for the EAP 6.3 Alpha download - we are working with the EAP team to get that restriction removed .    The semantics of the pg transport security configuration  have changed . By default the socket configuration has SSL disabled.  If login security is used, then clients will be required to use a secure login - which is currently only GSS.  If SSL is fully enabled, then clients will be required to use SSL. This more closely matches the behavior of the JDBC trans

The 3 big problems with data and how to avoid them

The 3 big problems with data and how to avoid them You’re invited to attend the Beyond Big Data Webinar Series, a set of 5 Red Hat webinars. Read more about the entire series. Webinar 1: The 3 big problems with data—and how to avoid them November 5, 2014, 11:00 a.m. - 12:00 p.m. No matter what your organization looks like, chances are you're wrestling with at least one of the following data challenges: Data silos that are difficult to access when needed Point-to-point integration that doesn't scale Data sprawl leading to security and compliance risks Join this webinar to learn how to implement a data strategy and architecture to avoid these problems. Speakers: Syed Rasheed, solution marketing manager, Red Hat Syed Rasheed, solution marketing manager at Red Hat, coordinates marketing, evangelism, and consulting activities. In addition to helping customers address integration challenges, he is responsible for working with customers, partners, and industry analysts to ensure

Single sign-on (SSO) with Teiid with Kerberos secured Web Service

With the latest upcoming release of Teiid 8.9, user can achieve single sign-on (SSO) in accessing any REST or SOAP based web services that are secured through kerberos. In the previous installment, I have shown few articles on how to do Kerberos authentication through Teiid/JBoss EAP in consuming a REST web service. In this blog I will showcase few more articles that are designed around SOAP web services. Mostly these articles are written tutorial fashion such that one can easily follow and create and as well as consume the web services in JBoss EAP and Teiid. 1)  How to implement a SOAP Web Service with Kerberos authentication in JBoss EAP 2)  How to implement Kerberos authentication to a SOAP Web Service using Teiid 3)  How to implement kerberos "delegation" based authentication to a SOAP Web Service using Teiid In article (1) shows how to create sample SOAP web-service that can be secured through Kerberos In article (2) shows how to consume web-service

Teiid Platform Sizing Guidelines and Limitations

Users/customers always ask us about the sizing of their Data Virtaulization infrastructure based on Teiid or the JDV product from Redhat. Typically this is very involved question and not a very easy one answer in plain terms. This is due to fact that it involves taking into consideration questions like: What kind of sources that user is working with? Relational, file, CRM, NoSQL etc. How many sources they are trying to integrate? 10, 20, 100? What are the volumes of data they are working with? 10K, 100K, 1M+? What are the query latency times from the sources?  How you are using Teiid to implement the data integration/virtualization solution. What kind of queries that user is executing? Even small federated results may take a lot of server side processing - especially if the plan needs tweaking. Is materializing being used? Is query written in optimal way? and so on.. Each and every one of the question affects the performance profoundly, and if you got mixture of those then

Teiid 8.9 CR1 Posted

After a small delay Teiid 8.9 CR1 has been posted to the maven repository and the downloads: http://teiid.jboss.org/downloads/ A recap of the feature highlights so far with Teiid 8.9: TEIID-3009 WITH project minimization - common table expressions will have their project columns minimized. TEIID-3038 geoSpatial support for MongoDB translator TEIID-3050 Increased Insert Performance with sources that support batching or insert with iterator. TEIID-3044 Function Metadata is available through system tables and DatabaseMetaData. TEIID-1910 TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven. TEIID-3119 Performance improvements in grouping and duplicate removal as well as general improvements to memory management. TEIID-3156 Collation aware prevention of order by pushdown via the collationLocale translator property and the org.teiid.requireTeiidCollation system property. In addition Ramesh has be

8.9 Beta2 Available

8.9 Beta2 has been posted to the downloads: http://teiid.jboss.org/downloads/ This pre-release builds upon Beta1 to provide performance improvements for dup removal and any usage of our internal table structure and many new fixes.  In fact we are up to ~75 issues being addressed and will likely get close to 100 before the end of the release. Special thanks to Joseph Chidiac for uncovering a variety of issues from Salesforce to windowing and general planning issues.  Community usage of the later pre-releases is vital to producing a quality final release.  So be sure to engage the forums and log issues as soon as you experience them. Expect a candidate release to follow in approximately 2 weeks.  At which time we can start on the 8.10 and ideally the 9.0 Wildfly efforts. Thanks, Steve / The Teiid Team

Teiid Designer 8.6 Final Released

Teiid Designer 8.6 Final is now available our update site or download the archive. This release focused on improving existing features and bug fixes. Primary drivers for this release: Enhance and upgrade Teiid Connection Importer Added support for defining Native Query Procedure REST Importer Enhancements Added Dynamic Parameters JSON WS support Improved Security Definition for Data Roles Check out our What's New for 8.6 article for details... Barry LaFond Teiid Designer Team

Teiid 8.9 Beta1

8.9 Beta1 is now available from the downloads and maven.  Feature highlights since Alpha1 include: TEIID-3050 Increased Insert Performance with sources that support batching or insert with iterator. TEIID-3044 Function Metadata is available through system tables and DatabaseMetaData. TEIID-1910 TeiidPlatform for EclipseLink integration is now provided via the teiid-eclipselink-platform jar in maven. With a total of 59 issues addressed so far, this continues to be primarily a fix release - but there's still time to vote for or log enhancements to make this release. Ideally we'll still get OData 4 support via Olingo in the near term.  However it is becoming doubtful that it will make it into the 8.9 release. Thanks again for all the community support, especially when there are infrastructure issues. We try to ensure that every forum posting gets attention, but notifications are still inconsistent at best. If something hasn't been addressed in a couple

Red Hat JBoss Data Virtualization & Hortonworks Big Data Webinar Series

Discover Red Hat and Apache Hadoop for the Open Modern Data architecture As the Enterprise's big data program matures and Apache Hadoop becomes more deeply embedded in critical operations, the ability to support and operate it efficiently and reliably becomes increasingly important. To aid enterprise in operating modern data architecture at scale, Red Hat and Hortonworks have collaborated to integrate Hortonworks Data Platform with Red Hat's proven platform technologies. Join us in this interactive series, as we'll demonstrate how Red Hat JBoss Data Virtualization can integrate with Hadoop through Hive and provide users easy access to data. Here's what you'll be signing up for: Webinar 1: Delivering the Open Modern Data Architecture Webinar 2: Red Hat JBoss and HDP: Turn your data into strategic asset (demo/deep dive) Webinar 3: Red Hat and JBoss and HDP: Delivers the Data Lake (demo/deep dive) We hope you can join us!

Teiid Market Place Git Repository

Introducing Teiid market place git repository, where you are free to share your project with all the Teiid community of users. (maybe sell?) Checkout  https://github.com/teiid-marketplace If you are a Teiid user, maybe you have written a translator to a source that Teiid does not offer, or maybe you gave a presentation you want to share, a slide-deck, a video or you wrote a cool utility over Teiid. Whatever it may be, now you can share with rest of the Teiid community at one market place. Over the time, if a certain project is popular and licensing terms are acceptable by the Teiid project, then we can accept it as contribution to be maintained as a main Teiid project on a case by case basis. Or you can think of this as incubator space. When you contribute, I will make you the owner of that repository for any management purposes. The only restriction is this needs to be a Teiid-specific project to be acceptable. I am not putting any license restrictions on what it needs to be;

Use Apache SOLR as Index store with Teiid

Solr TM is the popular, blazing fast open source enterprise search platform from the  Apache  LuceneTM project.  In this article I show a working example, how one can start using Apache SOLR as index store for the logical views they have created in Teiid. This dramatically improves the query performance in certain situations when user query is over that logical view. https://community.jboss.org/wiki/ImproveTeiidQueryPerformanceUsingApacheSOLRAsIndexStoreOnAView Now, combined this with any of big data sources like Hive, MongoDB, Accumulo etc. that is a success story you can take it to your organization. Please share your comments and usecases. Thanks Ramesh..

Teiid 8.9 Alpha1 Posted

8.9 Alpha1 is now available from the downloads and maven.  Feature highlights include: TEIID-3009 WITH project minimization - common table expressions will have their project columns minimized. TEIID-3038 geoSpatial support for MongoDB translator There was also an initial commit of a usage table in SYSADMIN that can be used for runtime dependency analysis.  Saxon was updated several minor revisions, so let us know if you see any issues with SQL/XML functionality. We're seeing a broad array of users logging issues across lots of functionality, so thanks again for all the community support. Top reporters include Cristiano Nicolai, Ivan Chan, and Mark Addleman.  Be sure to log anything you find with the early releases as there is still plenty of time to get them addressed. Thanks, Steve

Teiid In JBoss Community Asylum

JBoss Community Asylum is audio podcast that feature many interesting technical talks about various community projects hosted in JBoss.org.   Steve and Ramesh joined me last week to chat about Teiid and data virtualization. This is often a mysterious topic for many so I encourage you to go listen to the podcast episode   http://in.relation.to/Bloggers/JBossCommunityAsylumWhatKindOfAnimalIsTeiid People in Asylums can come back any time to haunt you. Emmanuel

Teiid Web Console 1.2 Released

A new version of Teiid Web-Console application has been released along with Teiid 8.8 release. You can download the new version at  http://sourceforge.net/projects/teiid/files/webconsole/1.2/Final/teiid-console-dist-1.2.0.Final-jboss-as7.zip/download Using the Teiid web console you can manage/monitor and administer various aspects of the Teiid Server. The new version adds feature to enable Audit/Command/trace logging without editing the standalone-teiid.xml file manually. It also has few bug fixes. Ramesh..

Teiid 8.8 Final Released

We are pleased to announce the timely release of Teiid 8.8.  It is now available for download and from the Maven repository.  While we didn't quite make it to 100 issues, this release still has a good set of features and quite a few fixes.  Main features include: TEIID-2647 Translator for Cloudera's Impala data warehouse has been added. See the reference for more. TEIID-2902 More incremental joins where the whole dataset does not need fully sorted or even read. TEIID-2263 More control over MAKE (NOT) DEP hints via syntax that allows for traversing views. See the reference for more. TEIID-2263 Common Table (WITH) planning improvements such that the usage of a WITH clause in a view or inline view no longer inhibits planning as part of the larger query. TEIID-2980 XMLTable Array Support - XMLTABLE may now return arrays for sequence values. TEIID-1675 Updatable LDAP multi-valued attributes - using an array type mapping, LDAP multi-valued attributes can be inserted/

Teiid 8.8 CR1

We are closing in on the 8.8 release with the availability of 8.8 CR1 .   Notable features since Beta2 include: TEIID-3018 System tables for view/procedure defintions - the SYSADMIN Views and StoredProcedures tables can be used to access the defintions of the views/procedures.  We will also be kicking off Teiid 8.9 development shortly.  Expect more OData support in this release along with the usual performance improvements and fixes. Please provide any feedback that you can on CR1 or vote/log issues for 8.9 and thanks again for all of the community support. Steve

Kerberos authentication with Teiid

Teiid supports kerberos authentication over its JDBC and ODBC driver. It is also possible to configure OData access to use kerberos using SPNEGO with little amount of configuration. Recently I wrote few articles while testing the feature, if interested see A practical "how-to" guide to Kerberos authentication with Teiid over JDBC A practical "how-to" guide to implement kerberos authentication with Simple REST Web App A "how to" guide to "delegate" kerberos token to REST based data source in Teiid In article (1) shows how to configure Teiid to participate in Kerberos authentication. In article (2) I showed a example to create simple web-app to configure with SPNEGO to participate in Kerberoes. In article (3) I showed an example, to delegate the logged in user into Teiid, to the REST web-service as passthrough with out extra negotiation.  Thanks Ramesh..

Teiid 8.8 Beta2

Teiid 8.8 Beta2 is now available from the downloads .  Features since Beta1 include: TEIID-2980 XMLTable Array Support - XMLTABLE may now return arrays for sequence values. TEIID-1675 Updatable LDAP multi-valued attributes - using an array type mapping, LDAP multi-valued attributes can be inserted/updated. Over 70 issues have now been addressed in the release so we are expecting a high quality result by mid-July. Please provide feedback as early as possible so that the changes make it into the CR build. Thanks again for all the feedback and forum questions. A general infrastructure issue that we are seeing is that there seem to be periods of time when we are not getting forum notifications. We do ordinarily strive to respond as quickly as possible. Thanks, Steve

Teiid Designer 8.5 Final Released

Teiid Designer 8.5 Final is now available our update site or download the archive. The primary drivers for this release were: Replace multiple Teiid client plugins with single plugin greatly improves ability to support future Teiid runtimes Upgrade Teiid runtime compatibility to version 8.7 Expose Translator import properties within Teiid Connection importer Support for dynamic extension metadata (custom translators) VDB Editor layout improvements Make System functions available for use at design-time Check out our What's New for 8.5 article for details... Barry LaFond Teiid Designer Team

Teiid 8.8 Beta1

Teiid 8.8 Beta1 has just been posted to the downloads .  Notable features since alpha1 include: TEIID-2263 More control over MAKE (NOT) DEP hints via syntax that allows for traversing views.  See the reference for more. TEIID-2263 Common Table (WITH) planning improvements such that the usage of a WITH clause in a view or inline view no longer inhibits planning as part of the larger query. There has also been quite a bit of general issues addressed (including several with MongoDB), so this should be a fairly stable pre-release.  We have also seen that the Resteasy patch is now also required for SOAP WS translator/resource adapter operations, so please apply the patch proactively. Thanks again for all the feedback.  Be sure to let us know of any issues as there is still plenty of time to get them addressed before the final release. Thanks, Steve

Docker and Red Hat JBoss Data Virtualization (Teiid)

Seems like every one is looking into Docker now a days and JBoss Data Virtualization is no exception. Take look at the following article and see how you can stand up JDV Docker image for your distribution or testing http://www.ossmentor.com/2014/05/docker-and-red-hat-jboss-data.html Note: JBoss Data Virtualization (JDV) is product version Teiid that Redhat sells subscription to. Now, to a bigger question I would like to engage community is 1) is there any interest in bring this to Teiid community? 2) What configurations? 3) How do you intend to use it? 4) Would you like us to build image every time we do a Teiid release and update the Docker.io repository along with Teiid download section? Some other ideas with docker 1) What would be really great is somebody help us with building quick start examples with Docker images, then we can reduce the barrier of using data virtulaization technology. 2) Build Docker images so that one deploy multiple instances of it then t

Teiid 8.8 Alpha1 Posted

8.8 Alpha1 is now available from the downloads and maven.  Feature highlights include: TEIID-2647 Translator for Cloudera's Impala data warehouse has been added. See the reference for more. TEIID-2902 More incremental joins where the whole dataset does not need fully sorted or even read. Ramesh has added command and audit logging to a variety of database targets through JPA - see TEIID-2938 and Logging for more. Generally this will be a fix and enhancement focused release, but there still is time to propose additional feature work. Thanks again for all the community support, Steve

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

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

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 D

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) Register:   https://vts.inxpo.com/Launch/QReg.htm?ShowKey=18825&AffiliateData=Syed   About  Rick van der Lans, managing director, R20/Consulting Rick 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,

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

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

Teiid Designer 8.4 Beta1 available

Work on Teiid Designer 8.4 release is nearing completion. Get the latest milestone, 8.4 Beta1 via via our update site or download the archive. The primary driver for this release is to upgrade the Teiid client compatibility to include Teiid 8.6 release. Check out our What's New for 8.4 article for details on some of the new features and improvements. Barry LaFond Teiid Designer Team

Teiid 8.7 Beta1

After a minor weather delay, we're back on track with 8.7 pre-releases with Beta 1 .  Feature highlights since Alpha1 include: 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. The pace of community issues has been good, so we're up to 55 issues addressed to date.  At this point we should miss the mid-March release date slightly, but we may need to lengthen the cycle for feature work.  That means the release will be out any time between the end of March to the beginning of May.  Should it be needed, we'll work toward an 8.6 cumulative patch for those who wish to stay on a release version.    Thanks, Steve

Teiid Designer 8.4 Alpha1 available

Work on Teiid Designer 8.4 release is progressing nicely and the first development release, 8.4 Alpha1 is available via update site . The primary driver for this release is to upgrade the Teiid client compatibility to include Teiid 8.6 release.  This includes UI support for: Added a native type property to procedure OUT parameters - TEIIDDES-1863 Ability to define a virtual table as global temporary table - TEIIDDES-1794 In addition, we're include a number of bug fixes and minor enhancements to importers as well as improvements to VDB validation. Barry LaFond Teiid Designer Team

JBoss Data Virtualization v6 GA Released

Have you been waiting for productized version Teiid 8.x? Then your wait is over, see below for announcement from Redhat. Redhat is excited to announce the general availability and launch of JBoss Data Virtualization v6. Effective data utilization is top priority on every IT and business executive agenda: Data volume, velocity and variety is growing exponentially. Most of your customers are drowning in data and struggling to gain actionable information. Its time to show them how to build efficient data supply chain instead of data warehouse to gain competitive advantage. Red Hat JBoss Data Virtualization, enables organizations to deliver timely, actionable, and unified information through lean integration of data spread over multiple applications and technology silos including Hadoop and traditional data warehouses. Red Hat JBoss Data Virtualization enables agile data utilization in 3 easy steps: Connect: Access data from multiple, heterogeneous data sources. Compose: Easily

Integrate Apache Solr search results with enterprise data with Teiid

Apache Solr is a full text search engine built on top of Apache Lucene for indexing and searching any data contents. This is been widely used by many organisations for their searching needs. Typically when a user wants to use Apache Solr, they will configure an instance of Apache Solr or SolrCloud with  relevant indexing fields  and publish all their data/documents that instance to be indexed. Once the documents are indexed, they can use Solr APIs to search the documents and use it for their purposes. This is where I believe Teiid can help ease the uploading of the enterprise data and with integration of search results with other data sources. Starting with Teiid 8.7.Alpha1, Teiid provides translator for Apache Solr. Using this translator, user can  Continually add/update the documents in the search system from other sources automatically. If the search fields are stored in Solr system, this can be used as very low latency data retrieval for serving high traffic applications

Teiid 8.7 Alpha1

After the holiday slowdown we're getting right back into the swing of things with the first 8.7 prerelease .  Feature highlights include initial commits of the following connectivity: TEIID-1070 Amazon SimpleDB support has been contributed by Radim Hopp.  See the Admin and Reference Guides for more. TEIID-2780 Apache SOLR support has been contributed by a collaboration of Mike Walker, Jason Marly, and Ramesh. TEIID-2627 Accumulo support has been added via a new translator/resource adapter. This is a fantastic amount of new connectivity for Teiid - and we're not even to the first beta.  Together with some other features and lots of fixes we're looking forward a strong 8.7 release. Any additional testing of the new sources or just early feedback in general is greatly appreciated. Thanks, Steve