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

book

Article ID: 51353

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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. <Please see attached file for image>

    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. <Please see attached file for image>

    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.

Environment

Release:
Component: ARGIS

Attachments

1558711629428000051353_sktwi1f5rjvs16sbs.gif get_app
1558711627396000051353_sktwi1f5rjvs16sbr.gif get_app