[
https://issues.jboss.org/browse/TEIIDDES-971?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-971:
---------------------------------------
Teiid Designer does have validation preferences for "Relational" models, but not
for PK/FK/UC references. These could be added but would apply to the whole workspace and
could bot be applied to individual tables.
There is also a question whether Teiid Query Engine would be able to accept this metadata
and not fail on validation during deploy/runtime.
The plan in 7.5 release is to begin implementing a new Model Extension framework which
might allow setting/adding new properties to tables and columns that are either understood
by specific DB's, Translators, Teiid Query Engine or just Teiid Designer.
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
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:
http://www.atlassian.com/software/jira