Is it possible to specify which database schema to use in ModelMetaData / ConnectorManager?

[ichanjasper]

Hi,

I am trying to join 2 databases together, but they both have a few schema in each database.

For example:

Database1:

     schema_1

          table_1

          table_2

     schema_2

          table_1

          table_2

Database2:

     schema_1

          table_1

          table_2

     schema_2

          table_1

          table_2

Currently, after combining Database1 and Database2 using Teiid, Database1 and Database2 would become schema and it contains tables like Database1_schema_1_table_1, Database1_schema_1_table_2....

Is it possble to create 4 schema instead of 2?  like the following:

Database1_schema_1

          table_1

          table_2

Database1_schema_2

          table_1

          table_2

Database2_schema_1

          table_1

          table_2

Database2_schema_2

          table_1

          table_2

Is it possible to specify which database schema to use in ModelMetaData / ConnectorManager?

Thanks,

Man-Kit

[shawkins]

Are you asking about Designer or with dyanmic vdbs?  The approach would be similar for each. 

In the dynamic case you would need to add 1 model for each schema and then in the import properties limit the import to only those objects matching your desired schema (schemaPattern=schema_x).  You would also tell the import to not use fully qualified names (useFullSchemaName=false).  Just be sure to use the same translator/connection for each of the models coming from the same database, so that the engine will know that they can be treated as a single source.

Steve

[ichanjasper]

Thank you so much!  Your solution works great!  =)

- Man-Kit