Configuring › How to Implement CA Business Intelligence for CA SDM › Configure CA Business Intelligence › Configure Initial CA Business Intelligence Settings › Configure Failover Settings

Configure Failover Settings

This process is only applicable for advanced availability configuration. You can configure failover settings if multiple application servers are configured. You configure failover to redirect active user sessions to the other application server. You can also configure load balancing between multiple application servers.

Follow these steps:

1. Invoke the command prompt as an administrator.
2. Execute odbcad32.exe from the location C:\Windows\SysWOW64, on the CA Business Intelligence server.

   The DataDirect OpenAccess SDK ODBC Driver Setup dialog opens.

   Note: The specified path is valid for Windows 64-bit installation.

3. Enter the application server details in the General tab.
4. Enter the alternate application server details in the Failover tab with the following syntax:

   (Host=AppServer1:Port=19987,Host=AppServer2:Port=19987,..)

5. Select Load Balancing to distribute the load among the server. The load is balanced between servers whose details are provided in the General tab and the servers whose details are provided in the Failover tab. The servers are picked randomly.

   Note: Select Force SQL_DRIVER_NOPROMPT for failover or load balancing configuration.

6. Click Apply and OK.

   You have configured the post configuration settings for the advanced availability configuration.