Skip to main content

Posts

Dynamic VDBs Are Back With A Punch!!!

You did not think we removed this feature from Teiid forever did you? In earlier releases of Teiid 8.0 cycles, Dynamic VDBs were not supported due to lack of non-archive file based deployment support from the JBoss AS 7. Now that  JBoss AS 7.1.0-Final has been released they added much needed feature to enable the Dynamic VDBs. With that we are announcing the first release of Teiid that is based on JBoss AS 7.1.0-Final . Teiid 8.0.Beta1 is released today. Teiid 8.0.Final will also be based upon same version of JBoss AS. This release brings back Dynamic VDB feature, but that is not the big news. Now you can define virtual tables, procedures and functions as you did in Teiid Designer based VDB are now can be defined in the Dynamic VDBs using DDL with out Teiid Designer. Yes, using DDL! This can lead design of Virtual Databases that are more dynamic in nature that can be changed programatically. Without any more non-sense here is quick example. The below example is extension of t...

Teiid 7.7 Final Released

We are pleased to announce Teiid 7.7 is now available.  While mostly a fix release with nearly 50 issues addressed, highlights of 7.7 features include: Excel JDBC Translator - for use with Excel using the JDBC-ODBC bridge. Salesforce Aggregates - salesforce pushdown queries now support GROUP BY, HAVING, and the standard aggregate functions. Comparable LOBs - the system property org.teiid.comparableLobs can be set to use CLOB and BLOB values in comparison/sorting/grouping operations. Padded String Comparison - the system property org.teiid.padSpace can be set to effectively right pad strings to the same length for comparison. See the release notes for more details.  Download today, give it try , and vote for or log features you want in upcoming releases. Steve

8.0.0 alpha2

Second instalment in 8.0 series is now available as 8.0.0.alpha2 release. This release is designed to be deployed on AS7 7.1.0-CR1b . The main changes include in this release are - New data type, VARBINARY has been added. - Documentation moved to confluence - Enhanced comparison support, includes comparable lobs, padded string comparison support and collation support. - Event ids along with all logged messages - many more bug fixes. Dynamic VDBs are still not supported, however once the AS 7.1.0-Final is released this will be supported. Test it out and let us know if any features not working as you expected or any new features you would like to see in 8.0-Final release as the window for new features is narrowing. Thank you community for the valuable input. Keep em coming! Ramesh..

Teiid 7.7 CR1 Posted

7.7 CR1 is now available.  7.7 is becoming a more feature-full release, highlights include: Excel JDBC Translator - for use with Excel using the JDBC-ODBC bridge. Salesforce Aggregates - salesforce pushdown queries now support GROUP BY, HAVING, and the standard aggregate functions. Comparable LOBs - the system property org.teiid.comparableLobs can be set to use CLOB and BLOB values in comparison/sorting/grouping operations. Padded String Comparison - the system property org.teiid.padSpace can be set to effectively right pad strings to the same length for comparison. Over 40 issues have been addressed in total.  Please validate any features or fixes of interest before the final release. The Teiid Team

Teiid 8.0.alpha1 - JBoss AS7 based Teiid

Teiid Team is proud to announce the availability of Teiid 8.0-alpha1 release. This is the first release of Teiid that is based on JBoss AS 7 as host environment. It is also start of the next major revision for Teiid and departure from Teiid 7.x releases. There will not be any more 7.x based releases. There is still lot more work to do for 8.0 Final release, this is our effort to get the community involved early on and weed out any possible regressions. There are many things changed with respect to AS7, as it completely re-written and entirely different from JBoss 5.x and 6.x releases. For details please see the AS7 documentation. That means there are numerous changes tricked down for Teiid too. I will list some issues to look out for All the deprecated features from the 7.x release have been removed. AS7 provides completely new way of configuration. Teiid utilizes this new configuration mechanism. Fully Supports CLI based administration. Deployment of artifacts such as vdbs an...

Source Tables Made Easy

For our Teiid Designer 7.6 release we introduced a couple of new ways to create new source tables in your relational models. If you have an existing model that needs a new table, select the model and choose the " New Child > Base Table ... " context action to launch the New Relational Table Wizard dialog. This wizard contains the options necessary to construct a relational table complete with columns, unique keys and foreign key definitions. Another new way to create tables is to import an XML input file which you can generate using the new RelationalModel.xsd schema.  Launch the Import wizard and select Teiid Designer's " Designer Text File >> Source or View Models " option.  Then choose the " Relational Model (XML Format) " import type. Select Next> to get to the file selection page. Browse to select your XML file and select a target model location for your new tables. When finished your new tables will be display...

Teiid Designer 7.6 Final Released

We are pleased to announce Teiid Designer 7.6 is now available.  Feature highlights include: XML Source Data File Importer - generate relational model xml externally and import to create your relational model. New Relational Table Wizard - Create a new relational table complete with column definition, keys and references in one wizard. New XML Format Relational Model Importer - generate relational model xml externally and import to create your relational model. New Model Extension Definition (MED) Framework - Provides more flexibility to add custom metadata to your models which enables your translators to be more flexible for accessing and exposing your source data. Framework includes a MED Registry View and MED editor. For more see Teiid Designer 7.6 What's New... See the release notes for more details on the 74 issues addressed. Download it today.... The Teiid Designer Team