Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2209

anytime view models are created (I.e. DDL import as View) allow checkbox to make default transformation so that the model is deployable

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 8.6
    • None
    • Import/Export
    • None

      I have mentioned this before but now that DDL import can generate view models (the only mechanism I can see to bring in logical/conceptual models from other tools like PowerDesigner etc)
      If the model is successful in that it brings all components it is still not a valid model to deploy to a vdb and start work against.

      My proposal is to generate SQL using the column metadata for the view itself.
      For example... I've attached a simple ddl but for order_header it'd be like:

      SELECT null AS Order_header_id, null AS order_header_name

      The primary purpose is to make the model deploy-able immediately.

      I'd also like to see this 'feature' at the Model-->Generate stubs when right clicking the model.

        1. ddl-importer-page-1.png
          66 kB
          Barry LaFond
        2. order_test_ddl.txt
          1 kB
          thomas johnston

            blafond Barry LaFond
            tljohnst@gmail.com thomas johnston (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: