How to use tables from multiple schemas in RPD?

Question

Hi all,

I have 2 schemas A and B in database DB. I need to use table from both schemas in my RPD by connecting to DB. I have created a user U and provided grants to schema A and B. Now without creating synonyms of table from schema A in Schema B or vice versa what can I do so that I can use both schemas. Checking the "Request fully qualified table names" didn't work.

Gianni Ceresa · Answer

Hi,

You just define the schemas first inside your physical database in the RPD, you then add tables inside the schemas.

A schema isn't mandatory in the physical layer, but in that case all objects should be owned by the user you use to connect to the DB (and would require synonyms as you mentioned).

If you define the schemas A and B, you can then have tables of these schemas under each, while using a single connection pool with your user "U". If you use the import  metadata wizard it should create the schemas when importing tables/views.