Teiid Designer 7.3 What's New

Other than bug fixing, the Teiid Designer 7.3 release included UI changes required to support the changes in how the 7.3 Teiid query engine processes Update queries. This was covered under the TEIIDDES-806 jira.

 

Update SQL support

 

In short, the "Select" SQL is now "analyzed" and validated to determine what "Update" capabilities will be enabled. Also, the previously generated "Default" queries wereremoved and NO SQL is defined if "Use Default" is enabled for Insert/Update/Delete. In addition, the Update SQL validation recogonizes Trigger Action SQL in the form of "FOR EACH ROW" clauses.

 

The example show below includes a Select statement who's source does not support updates.  Note the Select tab is decorated with a warning and the Insert/Update/Delete tabs are decorated with a "not alowed" symbol and annotated with the "(default)" text indicating the "Use Default" option is checked for each.

 

no-update-source.png

 

Looking at the Insert tab reveals more detail about the validation of the Select SQL and the result (errors and warnings).

 

no-update-source-insert-tab.png

 

In the case below for the Delete tab, the "Use Default" was unchecked and an invalid Delete SQL was statement was inserted to demonstrate the resulting validation.

 

no-update-source-invalid-delete-tab.png

 

File and Web Service Translators procedure generation

 

New Model contributions were added to help create default procedures for Web Service and Text Relational source models.

 

In Teiid Designer 7.2 the ability to create a new model to support both Text File translators and Web Service translators was introduced. See TEIIDDES-781

 

To create a relational model for one of these translator types:

 

1) Select "New > Teiid Metadata Model"

2) Supply a unique model name

3) In the "Select a model builder list", choose either the "Generate File Translator Procedures" option or the "Generate Web Service Translator Procedures" option.

4) Select Next >

 

For Generate File Translator Procedures, you yave 3 procedures options, for Generate Web Service Translator Procedures, you have two procedures to choose from.

 

new-model-generate-file-procedures.png

 

(Download and install an example that will walk you through the Text File use-case)

new-model-generate-ws-procedures.png

 

JDBC Model Importing

 

Teiid Designer 7.3 includes improvements in datatype mapping during JDBC Import as well as DDL Import/Export features. Specifically, numeric types are more accurately mapped during JDBC import (See TEIIDDES-345)

 

Project Examples

 

New Model Project examples available covering basic JDBC model importing, connection profile management, preview data feature, VDB creation, deployment and execution. Download examples at: http://www.jboss.org/teiiddesigner/downloads/examples

 

Teiid View Usability

 

The usability of the Teiid View was improved in 7.2/7.3 (TEIIDDES-755) including ability to use a custom name for your instance.(TEIIDDES-808). The New Teiid Instance wizard was expanded to include Teiid JDBC connection information as well as Teiid Admin info. This JDBC info is required to enable Preview Data and Execute VDB functionality.

 

Teiid Designer Connection Profile Support

 

The integration of Data Tools Connection Profiles as the connection management framework for Teiid Designer since 7.0, we added the ability to set Text, web service, Salesforce and LDAP connection profiles on source models.  This was required to enable Designer to create and deploy the data source artifacts that Teiid needs to perform data preview.