How to manually install and configure Data Direct ODBC Driver for CABI 3.1?

Document ID : KB000051353
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

This document explains the steps to install and configure Data Direct ODBC driver on a CABI 3.1 install.

Solution

On a stand alone CABI 3.1 installation, the data direct ODBC driver will be installed and configured during CA Business Intelligence Configuration.

Steps for installing and configuring the driver on a stand alone CABI installation:

  1. Run CA Business Intelligence Configuration from ServiceDesk media.
  2. Click Next on Welcome screen.
  3. Enter BI Admin Username.
  4. Enter BI Admin Password.
  5. Enter CA Service Desk Manager Admin Username.
  6. Enter CA Service Desk Manager Admin Password.
  7. Enter CA Service Desk Manager Primary Host.
  8. The default ODBC port number is 19987.
  9. Default ODBC install location will be C:\Program Files\CA\SC\CASD_ODBC , you can change the install location if needed.
  10. The option "Use Data Direct ODBC 6.0 Driver" will install the driver and configure the driver. If a previous version of driver exists on the system, it will update the driver to version 6.0 which is used by the CA ServiceDesk universe in R12.5 CA SDM.
  11. Click Finish (see Figure 1).

    Figure 1
  12. Figure 1

  13. After the configuration is complete, CA Service Desk Manager data source is available under the System DSN tab of ODBC Data Sources.
  14. Double click on the ODBC connection and click on Test Connect (see Figure 2).

    Figure 2
  15. Figure 2

  16. In the Data Source Username field enter the Service Desk's Privileged username.
  17. In the Data Source Password field enter the password for Service Desk's Privileged user and click OK.
  18. A message "Connection test was successful" will be displayed.