RPD Developement (two tables from different schemas)

Sisanda

Good day,

Please kindly assist is it possible to create a single subject area from two tables that sit in two different schemas in the database.

I created two separate connection pools to pull the tables. Schema names ADMPROD1 and PXRPT1

Schema.PNG

Jagadeeshrr

Hi User_B4S9A,

@Gianni Ceresa has already provided the solution. If you still need with simple practical example, please visit the link https://obiee-oraclebi.blogspot.com/2024/04/join-two-tables-from-different-schemas.html

Gianni Ceresa

Yes you can.

What you generally do is to define them as 2 different physical databases (so not 2 connection pools in the same physical database), define the joins as you need (you can join objects of different databases) and then you unify them into a single logical model.

Or in your case, just grant access to the same database account to the 2 schemas.

The tool doesn't handle multiple connection pool in that way (2 different users to connect to 2 schemas), it handle the multiple connection pool for variable and other things like that.