3 Replies Latest reply on Dec 8, 2015 7:56 AM by Jean-Pierre Matsumoto

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

    govindaraj s Novice

      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

         

           error.JPG

       

          Environment:

          Teiid Designer 9.0

          Teiid server 8.7

          Jboss EAP 6.1

       

       

      Thanks & Regards

      Govindaraj s.