[JBoss JIRA] Created: (TEIIDDES-971) In Designer, when importing tables with foreign keys, let user bring in tables without foreign key dependency errors / allow override
by Joel Tosi (JIRA)
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
13 years, 4 months
[JBoss JIRA] Created: (TEIIDDES-1017) Create "Metadata from Teiid Metadata File" import option which utilizes DTP Flat File connection profile and targets Teiid formatted source table files
by Barry LaFond (JIRA)
Create "Metadata from Teiid Metadata File" import option which utilizes DTP Flat File connection profile and targets Teiid formatted source table files
--------------------------------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-1017
URL: https://issues.jboss.org/browse/TEIIDDES-1017
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 7.5
Reporter: Barry LaFond
Fix For: 7.5
To improve usability of File connectors, users need the ability to import from a Teiid Source file via the import wizard.
1) Add an new import option > "Metadata from Teiid Metadata File"
2) Page 1 set up similar to the JDBC importer & SF importer with the Connection Profile combo box at top with select & edit Connection profiles buttons
- Would be filtered to be only select & edit Flat File Source connection profiles
- Connection profile points to folder on file system
3) Page 2 would show summary of what Metadata objects are available
- User could pick and choose (check-boxes) what tables, procedures, etc... to create
4) Page 3 maybe the Model Selection page with "Update" option, similar to JDBC importer + any more import options
5) Page 4 (if update) to show differences
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 4 months