Teiid Designer 8.2 What's New

    Highlights

     

    Teiid Designer 8.2 introduces the following changes and features

    • Upgrade to Teiid 8.4 runtime client
    • Improvements to the DDL Importer and the Teiid Connection Importer including
      • Better feedback for errors and unhandled DDL statements
      • User-selectable importer dialect
      • Support for import of Model Extension properties
    • Improvement of the VDB Editor including:
      • user defined properties support
      • allowed language properties
      • added row-based security and column masking to data role definition

     

    • Integration of model and VDB refactoring actions into Eclipse refactor/preview framework
    • Added option to include costing analysis during JDBC import


     


    New Quick Start Guide

     

    For 8.2, we changed our quick start guide to follow the simple actions/steps in one of Teiid Designer's Guides View action sets, namely : Model Flat File Source.

     

    See Teiid Designer 8.2 Quick Start Guide for details.



    DDL Importer Improvements

     

    TEIIDDES-1711

    TEIIDDES-1674

     

    Many improvents to the DDL importer have been incorported with the 8.2 release.  These improvements are also seen in the new Teiid Connection importer, since it utilizes the DDL importer.

     

    Better feedback for errors, warnings and unhandled DDL statements:

    - The importer now provides more information when a DDL parse error or other warning occurs.

     

    Below is an example of the wizard showing a DDL parse error:

    DDLImport-parseError.png

    The final 'differences' page in the wizard has also been replaced, and includes helpful warning messages - as shown below.

    DDLImport-DifferencesPage.png

     

    User - selectable DDL dialect

    - The user can select the DDL dialect on the first page of the DDL import wizard, rather than rely on the import framework to select it.

     

    Model Extension Properties are generated for Teiid DDL

    - Teiid extension properties are allowed in Teiid DDL.  The importer will now recognize that the extension properties are present,  then include the appropriate built-in extension definition and properties to the generated model.

     


    New VDB Editor features

     

    TEIIDDES-1677

    TEIIDDES-1480

    TEIIDDES-1795


    In addition to the Query Timeout property for VDB's, release 8.2 introduces the ability to add and edit values for allowed languages property as well as user-defined properties as shown below.

     

    vdb-editor-properties-tab.png

     

    Validation Status Info

     

    For 8.2, we've added properties to the VDB that provide info on when your VDB was last validated and what Teiid runtime version it was validated against.  These values are shown in the top panel as shown below.

     

    vdb-editor-validation-info.png

    In addition to displaying the Teiid runtime version, 8.2 has added a validation check on your workspace VDB's to determine if their last validation Teiid runtime is the same version as the the current default Teiid server version.  If not, then a warning problem marker is generated as shown below.

     

    vdb-server-version-warning.png

     

    Right-clicking on the problem and selecting the Quick Fix.... action will present a Synchronize VDB action which will synchronize the VDB with your current workspace metadata and update your server version.

     

    quick-fix-dialog-for-server-version-fix.png

     

    Data Role Row Based Security and Column Masking

     

    In 8.2, the Data Role wizard was improved by adding support for defining Row-based security (condition) and column masking (mask) per the updates to Teiid's 8.4 vdb-deployer.xsd

     

    In the wizard below a Security column was added to the table. Double clicking the security check-box for a model object will launch the Model Object Security Definition dialog where you can define applicable values. In order to edit or remove security, select the Conditions or Masking tabs and use the Edit or Remove buttons.

     

    models-tab-with-security-column.png

     

    model-object-security-definition-dialog.png

     

     


    Model refactoring improvements


    TEIIDDES-1622

     

    Deleting, renaming or moving models in your project now provide feedback around affected dependent models as well as a preview dialog for checking and unchecking specific dependent changes due to the resource change.

     

    Delete Model Dependency Summary Dialog

    delete-source-model-dialog.png

     

     

    Delete Model Preview Changes Dialog

    delete-source-model-preview-changes-dialog.png

     

     

    Rename Model Preview Changes Dialog

    rename-source-model-preview-changes-dialog.png

     



    New Guides View Action Set - Model Teiid Data Source

     

    TEIIDDES-1774

     

    A new action set was added to the Guides View to streamline modeling sources using the new Teiid Connection import option

    model-teiid-data-source-action-set.png

     

     



    Cost Analysis on JDBC Import

     

    TEIIDDES-275

     

    In 8.2, a new 'Include Cost Statistics' option has been added to the JDBC Importer.  When selected, this option will set the table cardinalities and other costing information at import time.  The Teiid Query planner uses this costing information to generate the most efficient query plans.  It should be noted that when importing large schema, selecting this option can significantly increase import times.

    ImporterCostingOption.png