Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1403 Add a vdb reuse feature
  3. TEIIDDES-1477

Add option to JDBC Importer to create VDB source model from Teiid-only connections

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Blocker Blocker
    • 8.0
    • None
    • Import/Export
    • None
    • Hide
       The JDBC importer detects if the Connection Profile is of a Teiid VDB connection type. If so, then the user has the default option to create a VDB Source Model for a single schema within that VDB. The name of the VDB Source model is determined by the schema name in the VDB (aka model name) and the resulting VDB source model will be treated as Read-Only
      Show
       The JDBC importer detects if the Connection Profile is of a Teiid VDB connection type. If so, then the user has the default option to create a VDB Source Model for a single schema within that VDB. The name of the VDB Source model is determined by the schema name in the VDB (aka model name) and the resulting VDB source model will be treated as Read-Only

      VDB Re-use design will rely on the ability to create relational source models representing VDB's as source models containing schemas and tables for each visible source and view model.

      • During import, user can select/deselect schema (models) and tables on Select Database Objects page
      • Add Check-box for "Import as VDB Source Model" to Specify Import Options page
        • Add "description" to note that this is a Teiid VDB import and can be treated in a special way.
          • Maybe we default the checkbox to CHECKED?
        • if checked, then disable other options
          • Make target a view model (DISABLE as UNCHECKED)
          • Include catalog for Fully Qualified Names (DISABLE as UNCHECKED)
          • Use Fully Qualified Names (DISABLE as CHECKED)
            • schema serves as original Model Name and is required for query validation
          • Change Case for All Characters (DISABLE as UNCHECKED)

        1. jdbc-import-page-1-vdb-source.png
          52 kB
          Barry LaFond
        2. jdbc-import-page-3-vdb-source-error.png
          16 kB
          Barry LaFond
        3. jdbc-import-page-4-vdb-source.png
          55 kB
          Barry LaFond

              blafond Barry LaFond
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: