Teiid Designer 7.4 What's New

Release 7.4 was again dedicated to bug fixing and any changes or feature additions required for 7.4 Teiid release.

 

VDB Editor Improved Layout

 

The VDB editor had some limitations on it's layout and required re-work in order to accommodate a large number of models and files as well as the addition of a new tab introduced for editing Translator Override properties. (TEIIDDES-934)

 

The image below shows upper and lower panels separated by a movable splitter.  Upper panel includes tabs for adding and removing your "Models" and "Other Files.

 

The lower tab contains tabs for editing and managing Data Roles, VDB Description and the newly available Translator Overrides.

 

translator-overrides-editor-tab.png

 

 

VDB Translator Overrides

 

The VDB manifest definition (vdb.xml) has had provisions for applying Translator property overrides specific to the source models contained in your VDB. In 7.4, Teiid Designer provides a means to add and edit these overrides. (TEIIDDES-710)

 

As shown in the figure above, the Translator Overrides tab panel contains a list panel on the left containing references to your Overridden Translators.  Selecting one of these from the list populates the Description and Properties panel on the right.

 

To override translator properties for one or more of you source models, select the "+" or add action at the bottom left of the panel.  When the Add Translator Override dialog appears (shown below), select an existing translator type and select OK.

 

add-translator-override-dialog.png

 

The above dialog will be displayed if there is a default Teiid instance defined and connected in the Teiid View.  If there are no Teiid servers defined in your workspace, you can still create a translator override. The following dialog will be displayed instead. Provide a unique name for your translator override and enter a valid translator name (i.e. oracle, mysql, etc. See your Teiid server installation or AS console for available translator names)

 

add-new-translator-override-dialog.png

 

 

Description View Editing Changes

 

To improve user experience editing descriptions for models and model objects the Description      View was changed to a read-only view. To edit Descriptions for selected objects, click the Edit icon in the toolbar      or right-click select the "Edit" action in the context menu. (See figures below) (TEIIDDES-826)

 

description-view.png

 

 

description-view-context-menu.png

 

 

edit-description-dialog.png

 

VDB Editor Preferences

 

We added an additional tab in the Window > Preferences > Teiid Designer > Editor panel.  The lone preference allows preventing the confirmation/warning dialog that's presented when you synchronize your VDB. (TEIIDDES-896)


vdb-editor-preferences.png

 

Viewing and Removing a Model's Connection Information

 

During JDBC import a model will contain certain connection properties which Teiid Designer uses to provide Preview Data functionality as well as populate VDB's with translator type information.

 

In 7.4, you can now view this connection information by selecting a source model and using the "Modeling > View Connection Profile Info" action. The read-only dialog is shown below.  (TEIIDDES-826, TEIIDDES-876)

 

view-connection-info-action.png

 

view-connection-info-dialog.png

 

In addition, a Remove Connection Info action was added (see image above) that allows cleaning up/removing Connection Profile properties stored in a model. Some users may want to remove these properties prior to production deployment in your VDB for security reasons.

 

Also, an option was added to the Export > Teiid Designer > Model Project Set wizard which reads "Remove all source connection information from source models"

 

You may want to use this option when export project sets for use by other developers.

export-model-project-set-wizard-page-2.png

 

Extended Properties for Relational Objects

 

In order to facilitate custom property usage for relational models and objects such as tables, columns, and procedures, a dialog to create extended properties was added. These properties are exposed in Teiid as indexed metadata and can be read by your custom translator.

 

In 7.4, you can add, edit and delete these extended properties by selecting a relational model or model object using the Modeling > Manage Extended Properties action. The menu option and dialog is shown below:

 

manage-extended-properties-dialog.png

 

RESTEasy WAR Generation

 

Teiid Designer already provides JBossWS-CXF war generation capabilities to allow you to expose your VDBs via SOAP. In 7.4 you can do the same thing using a RESTEasy war created using Designer. You can map virtual procedures to HTTP methods (GET, POST, PUT and DELETE)  using the afore-mentioned extended properties and then let Designer do all the work of creating the RESTEasy artifacts required for RESTful CRUD execution against your VDB.

 

generate-resteasy-war.dialog.png