Teiid Designer 8.4 What's New

Highlights

 

Teiid Designer 8.4 introduces the following changes and features

 

8.4 Users Guide

 

Download and Install 8.4

 


Auto-create VDB Data Source

 

TEIIDDES-2051

 

Deployed VDBs are accessed by applications through their JDBC connection. This connection is defined by a data source defined and deployed on a server. In 8.4, we've added a step in the Deploy VDB and Execute VDB actions to allow users to define/deploy the data source representing the Deployed VDB. You can change the generated JNDI name prior to creating this data source as well as enable Pass Thru Authentication. Cancelling this dialog will not create a VDB data source.

create-vdb-data-source-dialog.png


Improved model name validation

 

TEIIDDES-2034

 

For 8.4, we've added a common model name validation framework and applied it to all wizards and dialogs where model names can be edited.  In the example below the user enters EmployeeViews&x and the wizard displays a validation error stating:  "Invalid model name. The character '&' (at postion 14) is not allowed, only alphabetic ([a-z][A-Z], digit ([0-9]) or '_' are allowed". The error must be fixed to enabled to complete the dialog or wizard page.

invalid-model-name-example.png


Expanded SQL Template insert/replace functionality

 

TEIIDDES-2037

 

When editing a transformation or creating a new view procedure or table, Designer provides a set of SQL templates you can use in your SQL. Prior to 8.4, you could only replace your existing SQL with your template SQL. For 8.4, we've added the ability to replace existing SQL or insert the template SQL statement at the beginning of your existing statement, at the the current cursor location or at the end of your existing statement.  The dialog below illustrates these options.

 

sql-templates-dialog.png



Global temporary table support

 

TEIIDDES-1794

 

The Teiid 8.6 runtime supports virtual tables defined as global temporary tables.  In 8.4, we've added an extension property named Global Temp Table to our relational view tables. Setting the value to true will disable validation of the SQL statement which is expected to be empty.  (See also : TEIID-2067)

global-temp-table-extension-property.png



Added Guides View action context

 

TEIIDDES-1933

 

In 8.4 we've added labels to the guides view actions to provide context on where the user is within the action steps as well as the current value of the objects created or selected in that step.

guides-view-context-labels.png


Lock Diagrams feature

 

TEIIDDES-2067

 

In 8.4 we've added a diagram toolbar action to lock or unlock the top-level package diagram for each model.  This feature was in response to users in a collaborative environment who experienced confusion because diagram x,y coordinates were being persisted and any change to a diagram would result in a change to the model. This made it difficult to know when relevant differences occurred while sharing models.  Locking a diagram will only lock the top-level package diagram. If you wish to change the positions of specific diagram objects (tables, procedures) click "Unlock Diagrams", make your changes, then click "Lock Diagrams".  When your diagram is locked, you can drag components around the canvas, however these positional changes will not be saved.

 

lock-diagrams.png



Teiid Connection Importer allows saving DDL to workspace

 

TEIIDDES-1934

 

In 8.4 we've added a button in the Teiid Connection Importer to allow saving the import DDL to your workspace.  Previously you could save the DDL to the file system, but this allows an easy way to add it to your workspace also.  The wizard page is show below:

TeiidConnectionImporter.png