OBIEE 11g Pointing Connection Pool to another data base in RPD.

Scenario : We need to point data source of OBIEE from one database to another database.

Solution: We can do this through RPD in RPD change the connection pool details and point this to another database

Connection Pool: Connection pool is an object in RPD physical layer that used to define the connection details between BI server and data source.

Double click on the connection pool that you want to edit.

If you are using OCI for connecting to database do the following

Edit the server details in tnsname file located in the below location or add new connection details.

D:\obiee11g\Oracle_BI1\network\admin

Add tns entry for new database and and save the file.

Now take the connection pool and edit the details

For Data source name give the name that you provided in the tns file. Then give the User name and Password for the connection.

After giving Password check the connection by updating row count of tables.


Another method for doing the same is gave the connection description in data source name itself