How do I configure the ODBC connections for installing the ITCM Universe for CABI?

book

Article ID: 50337

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Server Automation CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

Before you can install the ITCM Universe for CABI, you need to manually configure the ODBC connections to the ITCM MDB.

Solution:

To correctly set your ODBC Connections to the ITCM MDB, follow the steps below on the server where you have installed CABI.

  1. Open the 32 bit Data Source (ODBC).

    Please note if using a 64 bit OS, you will also have a 64 bit ODBC, please make sure that you only set the 32 bit Data Source (ODBC).

    This gets installed as part of the general CABI installation, and you can easily locate it by going to "Start -> All Programs -> BusinessObjects XI 3.1 -> BusinessObjects Enterprise -> 32-bit Data Source (ODBC)".

    <Please see attached file for image>

    Figure 1
     
  2. Once you open the ODBC window, click on the "System DSN" tab as shown below, then click "Add" to create a new "Data Source Name" (DSN).

    <Please see attached file for image>

    Figure 2
     
  3. Once you click "Add" a new window will pop up, scroll to the bottom and select "SQL Server" as the driver type as shown below, then click Finish.

    <Please see attached file for image>

    Figure 3
     
  4. The next window will prompt you for the Data Source Name, Description (optional), and the Server name of the MDB. You should name the data source, "CA_ITCM" and provide the server name of your database server for your mdb. Then click next.

    <Please see attached file for image>

    Figure 4
     
  5. The next screen you will setup authentication. You should choose SQL Server authentication, and use the ca_itrm account. The default password for the ca_itrm account for a new ITCM installation is NOT_changedR11. See TEC420826 for details on how to change this password if you have forgotten it.

    <Please see attached file for image>

    Figure 5
     
  6. When you click next, it will try to authenticate and connect to your SQL Server mdb, if it's successful, it will just move you to the next screen, if it fails, you will see an error message stating why it failed.
     
  7. Next, you must select the "Default database" that the ODBC will connect to.

    By default the checkbox will be unchecked and the ODBC connection will use the 'master' database as seen below.

    <Please see attached file for image>

    Figure 6

    This needs to be changed to 'mdb', by clicking the checkbox and using the drop down menu to select 'mdb', then click next.

    <Please see attached file for image>

    Figure 7
     
  8. The next screen's default values can be left as is, click Finish...

    <Please see attached file for image>

    Figure 8
     
  9. This will create another pop up window with a summary of your settings, use the "Test Data Source..." button on the bottom to test your connection, then click ok.

    <Please see attached file for image>

    Figure 9

    <Please see attached file for image>

    Figure 10
     
  10. When you are finished you should now see "CA_ITCM" in the list of System DSN's as shown below.

    <Please see attached file for image>

    Figure 11

    **Please Note: Before installing the ITCM Universe, please make sure you download the Microsoft ODBC .NET Data Provider which can be downloaded from the URL below


Environment

Release: UASIT.99000-12.5-Asset Intelligence
Component:

Resolution

Please Update This Required Field

Attachments

1558699335341000050337_sktwi1f5rjvs16jp6.gif get_app
1558699333594000050337_sktwi1f5rjvs16jp5.gif get_app
1558699331895000050337_sktwi1f5rjvs16jp4.gif get_app
1558699330013000050337_sktwi1f5rjvs16jp3.gif get_app
1558699328292000050337_sktwi1f5rjvs16jp2.gif get_app
1558699326471000050337_sktwi1f5rjvs16jp1.gif get_app
1558699324501000050337_sktwi1f5rjvs16jp0.gif get_app
1558699322400000050337_sktwi1f5rjvs16joz.gif get_app
1558699320522000050337_sktwi1f5rjvs16joy.gif get_app
1558699318671000050337_sktwi1f5rjvs16jox.gif get_app
1558699316988000050337_sktwi1f5rjvs16jow.gif get_app
1558699315261000050337_sktwi1f5rjvs16jov.gif get_app
1558699313437000050337_sktwi1f5rjvs16jou.gif get_app
1558699311494000050337_sktwi1f5rjvs16jot.gif get_app
1558699309679000050337_sktwi1f5rjvs16jos.gif get_app
1558699308068000050337_sktwi1f5rjvs16jor.gif get_app
1558699306343000050337_sktwi1f5rjvs16joq.gif get_app
1558699304598000050337_sktwi1f5rjvs16jop.gif get_app
1558699302946000050337_sktwi1f5rjvs16joo.gif get_app
1558699301109000050337_sktwi1f5rjvs16jon.gif get_app
1558699299321000050337_sktwi1f5rjvs16jom.gif get_app
1558699297153000050337_sktwi1f5rjvs16jol.gif get_app