How to export and import the view model as a DDL with SQL transformation in the teiid designer

[govindarajs]

Hi,

    I have an option to export source model as DDL and import the same in different workspace by using DDL import option in teiid Designer, but the imported Source Model table has only first two column, other columns are missing in the imported source model tables

     Likewise if I exported the view model as DDL and imported the same in different workspace by using DDL import option, it created the view model without any SQL transformation, I lost all SQL transformation in the view model

    So how to export and import the view model as a DDL with SQL transformation in the teiid designer 9.0

    

    Environment:

    Teiid Designer 9.0

    Teiid server 8.7

    Jboss EAP 6.1

Thanks & Regards

Govindaraj s.

[jpmat]

Hi

I've observed same behavior because of:

TEIIDDES-2729

TEIIDDES-2741

They are some workarounds.

Hope this helps

Jean-Pierre

[govindarajs]

Can you please share the workaround to export and import as DDL?

Currently we are using Teiid Designer 9.2, but where also we are facing DDL Stored procedure import issue, Store Procedure SQL Transformation is empty when we import the DDL back to Teiid Designer 9.2

[TEIIDDES-2699] Issues with Dynamic VDB import/export - JBoss Issue Tracker

Regards

Govindaraj s.

[jpmat]

For TEIIDDES-2729 Bad export of carriage return in SQL transformation

Workaround is to do remove all carriage returns in middle of SQL query

For TEIIDDES-2741 Concatenation operator || incompatible with import SQL

Workaround is to use Teiid function CONCAT instead of || operator.

HTH