Oracle^® Business Intelligence Enterprise Edition Deployment Guide > Deploying Oracle Business Intelligence for High Availability >

Integrating BI Publisher with Oracle BI Clustered Environment

This topic describes the settings for the integration parameters when BI Publisher integrates with an Oracle BI environment deployed in a cluster.

Perform this task in the BI Publisher application.

To set the Oracle BI EE data source in BI Publisher

1. In the BI Publisher application, in the Admin tab, click the link JDBC Connection under Data Sources.
2. On the JDBC tab of the data sources page, select the Oracle BI EE Data Source.
3. Update the Oracle BI EE Data Source setting by changing the Connection String parameter to the following:

   jdbc:oraclebi://BI-CCS-01:9706/PrimaryCCS=BI-CCS-01;PrimaryCCSPort=9706;SecondaryCCS=BI-CCS-02;SecondaryCCSPort=9706

   where:

   • PrimaryCCS parameter is set to the Primary Cluster Controller.
   • SecondaryCCS parameter is set to the Secondary Cluster Controller.
   • PrimaryCCSPort and SecondaryCCSPort parameters are set to the port specified in the CLIENT_CONTROLLER_PORT parameter in the NQClusterConfig.INI file. (The default is 9706.)
4. Set the Username and Password fields to the Oracle BI Administrator credentials.
5. Verify that the Database Driver Class is set to the following:

   oracle.bi.jdbc.AnaJdbcDriver

   Click Apply.

Integrating with BI Presentation Services

Perform this task in the BI Publisher application.

NOTE:  The Oracle BI credentials specified in Administrator Username and Administrator Password fields are used to log in.

To specify the values for the BI Publisher URL to connect to Oracle BI

1. In the BI Publisher application, in the Admin tab, click the link Oracle BI Presentation Services under Integration.
2. From the Server Protocol dropdown, select http or https.
3. From the Server Version dropdown, select v4.
4. For the Server field, enter the server host name or Virtual IP for your Oracle BI environment. For example: bi.mycompany.com
5. Enter the port for the server in the Port field. For example, 80.
6. In the Administrator Username and Password fields, specify the Oracle BI Administrator credentials.
7. Set the URL Suffix field to the default value of analytics/saw.dll.

NOTE:  This allows BI Publisher to access BI Presentation Services by building the URL using <Server Protocol>://<Server>:<Port>/<URL Suffix. Login occurs using the Oracle BI credentials specified in the Administrator Username and Password fields.

Integrating with BI Server Security

If you have defined BI Server Security as the security model in BI Publisher, you must modify the JDBC connection string in the BI Publisher Enterprise application to point to the clustered BI Servers using the Cluster Controllers.

NOTE:  This procedure assumes that you have BI Server Security already set up.

For more information on setting BI Publisher to integrate with BI Server Security, refer to the Oracle Business Intelligence Publisher User's Guide.

To modify the JDBC connection string in BI Publisher

1. Log in to the BI Publisher Enterprise application as administrator.
2. In the Admin tab, go to the Security Configuration page.
3. Modify the Connection String as follows:

   jdbc:oraclebi://BI-CCS-01:9706/PrimaryCCS=BI-CCS-01;PrimaryCCSPort=9706;SecondaryCCS=BI-CCS-02;SecondaryCCSPort=9706

   where:

   • PrimaryCCS points to the Primary Cluster Controller.
   • SecondaryCCS points to the Secondary Cluster Controller.
   • PrimaryCCSPort and SecondaryCCSPort are set to the port specified in the CLIENT_CONTROLLER_PORT parameter in the NQClusterConfig.INI file.