2 Replies Latest reply on Jul 19, 2012 7:32 PM by Ivan Chan

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

    Ivan Chan Apprentice

      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