[JBoss JIRA] (TEIID-4760) optional object name manipulations while executing IMPORT FOREIGN SCHEMA
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4760?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4760:
----------------------------------
Fix Version/s: 10.3
(was: Open To Community)
(was: 10.x)
> optional object name manipulations while executing IMPORT FOREIGN SCHEMA
> ------------------------------------------------------------------------
>
> Key: TEIID-4760
> URL: https://issues.jboss.org/browse/TEIID-4760
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: Bram Gadeyne
> Labels: ddl, import, import_wizard
> Fix For: 10.3
>
>
> While executing IMPORT FOREIGN SCHEMA, table (and other object) names are added to the schema with their original names.
> In our previous virtual database we imported two schema's that contain the same objects but one is a production and another is a historical database.
> We then change the name for e.g. table1 to prod_table1 or wh_table1 according to the schema it came from. Some software that interacts with teiid can not distinguish between different schemas and can not handle duplicate table names. So for this reason, this would also come in handy.
> It would come in handy if it is possible to add a prefix to names while importing objects.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 9 months
[JBoss JIRA] (TEIID-4934) Allow importing VDBs with conflicting model
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4934?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4934:
----------------------------------
Fix Version/s: 10.3
(was: 10.x)
> Allow importing VDBs with conflicting model
> -------------------------------------------
>
> Key: TEIID-4934
> URL: https://issues.jboss.org/browse/TEIID-4934
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Affects Versions: 9.2.3
> Environment: * Wildfly 10
> * Teiid Server 9.2.3
> Reporter: Pedro Inácio
> Assignee: Steven Hawkins
> Fix For: 10.3
>
>
> It should be possible to import a model via "_import-vdb_" that conflicts with other models also imported via "_import-vdb_" if the conflicting model has the same version.
> This will allow greater model reuse, and not to have duplicated model definitions in multiple vdbs.
> Example:
> VDB 1:
> <code>
> <vdb name="OneVDB" version="1">
> <description>One VDB</description>
> <import-vdb name=ConflictingVDB" version="1"/>
> <import-vdb name="OtherVDB" version="1"/>
> </code>
> VDB 2:
> <code>
> <vdb name="TwoVDB" version="1">
> <description>TwoVDB</description>
> <import-vdb name=ConflictingVDB" version="1"/>
> <import-vdb name="YetOtherVDB" version="1"/>
> </code>
> VDB 3:
> <code>
> <vdb name="ThirdVDB" version="1">
> <description>Third VDB</description>
> <import-vdb name=OneVDB" version="1"/>
> <import-vdb name="TwoVDB" version="1"/>
> </code>
> Currently we cannot use the ThirdVDB as is, since there is a conflicting VDB (ConflictingVDB) defined in VDBS One and Two.
> Since both are using the same version, it should be possible to ignore the conflict (via a property for example).
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 9 months