Oracle^® Business Intelligence Enterprise Edition Deployment Guide > Clustering, Load Balancing, and Failover in Oracle Business Intelligence >

Integrating BI Publisher with Oracle BI Clustered Environment

The integration of BI Publisher with Oracle BI allows users to generate highly formatted reports based on Oracle BI data. The configuration of BI Publisher to enable this integration is described in the Oracle Business Intelligence Infrastructure Installation and Configuration Guide.

To integrate BI Publisher with Oracle BI deployed in a clustered environment, you must specify some of the parameters differently from what is necessary in a single server environment.

Setting the Oracle BI EE Data Source

The Oracle BI EE Data Source must point to the clustered BI Servers via the Cluster Controllers. 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. Update the Oracle BI EE Data Source setting by changing the Connection String parameter to the following:

   jdbc:oraclebi://<Primary Cluster Controller Host>:9706/PrimaryCCS=<Primary Cluster Controller Host>;PrimaryCCSPort=9706;SecondaryCCS=<Secondary Cluster Controller Host>;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.)
   • Username and Password fields are set to the Oracle BI Administrator credentials.
   • Database Driver Class field is set to oracle.bi.jdbc.AnaJdbcDriver.

Integrating with BI Presentation Services

The following procedure demonstrates how to specify the values for the BI Publisher URL to connect to Oracle BI. For example, http://bi.mycompany.com:80/analytics/saw.dll. This allows BI Answers requests to be visible in BI Publisher.

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.

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 to point to the clustered BI Servers via the Cluster Controllers.

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.

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