Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring Oracle BI Presentation Services >

Configuring Oracle BI Presentation Services to Access Multiple Repositories

Although users can have multiple repositories active on an Oracle BI Server machine, they can only access one repository per Oracle BI Presentation Services instance.

The following procedure shows how to configure Oracle BI Presentation Services to access multiple repositories.

To configure Presentation Services to access multiple repositories

1. Install the Oracle BI Presentation Services component on each machine that must serve as a web server.
2. Create a SAS NQSODBC driver on the Presentation Services machine to use the appropriate repository.
   • Configure a NQSODBC System DSN that points to the Presentation Services machine.
   • Within the ODBC configuration, check the box Change the default repository to.
   • Enter the repository to use for this Presentation Services machine (from the Logical Repository Name entry in the NQSConfig.INI REPOSITORY section).
3. In the instanceconfig.xml file on the Presentation Services machine, change the element <DSN> to be the name of the ODBC driver DSN defined in Step 2.
4. Start the Oracle BI Presentation Services.
5. Control the repository to access from a client browser by substituting the appropriate web server machine name or IP address in the URL:

   http://<machine_name_or_IP_address>/analytics/saw.dll?