How to configure Data Direct ODBC Version 6.0 for Service Desk r12.5 implemented in a cluster.

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
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This document explains the steps to configure the Data Direct ODBC driver to work with Service Desk R12.5 CA SDM cluster.

Solution:

The CA Service Desk Manager installation will install the Data Direct ODBC driver on the local host. On a stand alone BOXI installation, the CA Business Intelligence Configuration program will install the Data Direct driver. This driver connects to the Service Desk server using the Service Desk server host name and cannot recognize the alias name of the cluster. Therefore, a driver for each Service Desk cluster node must be manually created.

Steps to install and configure Data Direct ODBC Driver for Service Desk r12.5 CA SDM installed in a cluster

1. On the BOXI server, run the CA Business Intelligence Configuration program from the DVD#2 install media
   
   
2. On the Welcome Screen click Next
   
   
3. Enter the BI Admin Username
   
   
4. Enter the BI Admin Password
   
   
5. Enter the CA Service Desk Manager Admin Username.
   
   
6. Enter CA Service Desk Manager Admin Password.
   
   
7. In CA Service Desk Manager Primary Host field enter the host name of the active Service Desk node.
   
   
8. Accept the default port number and install location.
   
   
9. Make sure the Create Default users and Use Data Direct ODBC 6.0 driver options are checked.
   
   
10. Click Finish
    
    

    <Please see attached file for image>

    
    
    
11. Open ODBC Data Sources window from Administrative tools and go to System DSN tab.
    
    
12. Notice that a Data Direct ODBC driver with the server name of the active node has been created.
    
    

    <Please see attached file for image>

    
    
    
13. Click on Add
    
    
14. From the Create New Data Source window, select the CA Service Desk Manager driver and click Finish
    
    
15. In the Data Source Name field enter the server name of Service Desk in the following format: casd_XXX
    
    
16. In the Service Host field enter the host name of secondary Service Desk node.
    
    
17. In the Service Port field enter 19987
    
    
18. Click the ? button to select the Default Service Data Source
    
    
19. Select Apply and Ok to save the changes
    
    

    <Please see attached file for image>

    

Environment

Release:
Component: ARGIS