Follow the below steps to configure OBIEE to refer two databases dynamically.
- Prepare an Update statement which will update the DSN name of the Primary and Secondary Node.
- Create a Dynamic Repository Variable to refresh at the regular Interval and refer the DSN column from the above table. This will check the Active DSN name.
- Use the above variable reference in the Connection Pool so that It will refer the query to get the Active DSN every time.
- Now During the start and End of load execute the Update Statement created at the Step 1.
Automatically during the load the queries will be fired on the secondary server so that users can experience faster results even during the load time.
