Oracle^® Business Intelligence Enterprise Edition Deployment Guide > Clustering, Load Balancing, and Failover in Oracle Business Intelligence > Configuration of BI Components for Clustering, Load Balancing, and Failover >

Modifying BI ODBC Data Sources For Communication With BI Cluster

The BI ODBC Data Sources must be modified for communication to occur with the BI cluster, depending on your environment:

• In environments with a single Oracle BI Server, the BI ODBC Data Source points to the BI Server instance.
• In an environment where multiple BI Server instances participate in a BI cluster, the BI ODBC Data Source must point to the Primary and Secondary Controllers.

The following components use the BI ODBC Data Source:

• BI Presentation Services
• BI Administration Tool

Modify the BI ODBC DSN on the following machines:

• All machines that host BI Presentation Services.
• The machine that hosts the BI Administration Tool used to connect to the clustered environment.

After the BI ODBC client is configured to communicate with the BI cluster, the Administration Tool will connect to the repository on the Master BI Server.

Modifying the BI ODBC Data Source under Windows

By default, the BI ODBC Data Source Name (DSN) is AnalyticsWeb. The DSN is modified using the ODBC Data Source Administrator control panel, as shown in the following procedure.

To modify the ODBC data source under Windows

1. On the ODBC Data Source Administrator Systems DSN tab, select the AnalyticsWeb DSN.
2. Click the Configure button to open the Oracle BI Server DSN Configuration window.
3. Check the box "Is this a clustered DSN" and enter the names of the Primary Cluster Controller and Secondary Cluster Controller machines in the Primary Controller and Secondary Controller text boxes respectively.
4. Set the Controller Port field as appropriate.

   The default value is 9706. This port value must match the port number set for the CLIENT_CONTROLLER_PORT parameter in the NQClusterConfig.INI file.

Modifying the odbc.ini file under Linux or UNIX

On Linux and UNIX machines, the odbc.ini file is located in the OracleBI_HOME/setup directory.

• Modify odbc.ini as follows:

  IsClusteredDSN=Yes
  PrimaryCCS=BI-CCS-01
  PrimaryCCSPort=9706
  SecondaryCCS=BI-CCS-02
  SecondaryCCSPort=9706
  Regional=No

  • Set the PrimaryCCS parameter to the Primary Cluster Controller host.
  • Set the SecondaryCCS parameter to the Secondary Cluster Controller host.
  • Set the ports to the port number specified in the CLIENT_CONTROLLER_PORT parameter in the NQClusterConfig.INI file. The default is 9706.