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

In Designer, when importing tables with foreign keys, let user bring in tables without foreign key dependency errors / allow override

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 7.5, 7.4.2
    • 7.2
    • Import/Export
    • None

      When mapping data in side Designer, a user is forced to bring in all dependencies (think tables with foreign key dependencies) in order to have a valid model. You should be able to override this - make the user aware of the missing data and allow user to accept the limitation.

      Think of a scenario where there is a large database, with say 100 tables. Tons of foreign keys, etc. If a user wants to create a model against one table that has one foreign key (and bringing in its dependency brings another foreign key....etc) - if the user doesn't need the information from the related table for their modeling, then they should be allowed to override the warning and model without the dependency.

      To reproduce - create a relational store and create 10 tables (A - J) - A has a foreign key to B, B to C, and so on. In designer, be able to override the warning when trying to model against just A.

              mdrillin1@redhat.com Mark Drilling (Inactive)
              jtosi_jira Joel Tosi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: