]
Mark Drilling resolved TEIIDDES-971.
------------------------------------
Fix Version/s: 7.4.2
Resolution: Done
An option 'Include Incomplete FKs' was added to the JDBC import wizard options for
FK import. By default all FKs will still be imported even if they do not have a
corresponding PK. However, the user can now override by deselecting this option. When
the option is de-selected, the FKs with no PK will be not be imported.
In Designer, when importing tables with foreign keys, let user bring
in tables without foreign key dependency errors / allow override
-------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-971
URL:
https://issues.jboss.org/browse/TEIIDDES-971
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Affects Versions: 7.2
Environment: JBDS 4.0
Reporter: Joel Tosi
Assignee: Mark Drilling
Fix For: 7.5, 7.4.2
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: