How to integrate IBM Rational Asset Manager with your IBM Tivoli database

Steps to integrate with the Tivoli Change and Configuration Management Database

IBM® Rational® Asset Manager supports integration with the IBM® Tivoli® Change and Configuration Management Database (CCMDB). Developers can automatically create assets in Rational Asset Manager from existing configuration items (CIs) in CCMDB and use Rational Asset Manager as a Definitive Software Library (DSL) for storing software images. This article explains how to install and configure the Rational Asset Manager Integration module in a CCMDB environment.

Share:

IBM® Rational® Asset Manager supports integration with the IBM® Tivoli® Change and Configuration Management Database (CCMDB). You can automatically create assets in Rational Asset Manager from existing configuration items (CIs) in the CCMDB. You can also use Rational Asset Manager as a definitive software library (DSL) for storing software images.

When Rational Asset Manager creates an asset from a CCMDB CI, it is referred to as a remote asset. The remote asset will contain a link to the CI in the CCMDB, and, similarly, you can navigate to the asset in Rational Asset Manager from the CI in the CCMDB. The remote asset in Rational Asset Manager is a reference to a remote resource, meaning that the asset is managed in a remote repository. In addition to storing the reference in the remote resource, the Rational Asset Manager repository stores meta information for the asset, such as attributes and categories.

When the CCMDB creates new CIs from Rational Asset Manager assets, information is stored in the CI that indicates that the asset originated in Rational Asset Manager. If the Rational Asset Manager repository is then synchronized with the CCMDB repository and a remote asset is created from the CCMDB CI, the remote asset and the original asset become related assets: the original asset will have the "publish as" relationship to the remote asset, and the remote asset will have the "publish by" relationship to the original asset.

Remote assets in the Rational Asset Manager repository retain much of the metadata from the CCMDB CI. They are also given the asset type of Configuration Item and the category of CCMDB. These can be used as search filters to search for remote assets faster in the Rational Asset Manager repository.

For the CCMDB to create new CIs from Rational Asset Manager assets, the CCMDB must configure the Rational Asset Manager repository as a definitive software library, or DSL. A DSL is a storage location where approved versions of all software CIs are securely stored. A DSL might also contain items related to the software, such as licenses and documentation.

To configure the CCMDB to use a Rational Asset Manager repository as a DSL, you need to follow these steps:

  1. Install an integration module in the CCMDB to give the database the ability to search the Rational Asset Manager repository for software images.
  2. Create a discovery library adapter output file, which defines the assets that will be in the DSL.
  3. Load the DLA output file into the Tivoli Application Dependency Discovery Manager (TADDM).
  4. Use the IBM Tivoli Integration Composer (sometimes shown as ITIC in the interface) adapter to create an operational management product (OMP).
  5. Configure the integration module in the CCMDB to link to the OMP.
  6. Define an end point.
  7. Create a DSL.
  8. Synchronize CIs from the CCMDB to Rational Asset Manager.

1. Download and install the integration module

You can download the Rational Asset Manager integration module from the Extensions page of the Rational Asset Manager Web client.

  1. In the Change and Configuration Management Database Integration section, select the imram_x.x.zip file (where x.x is the version of Rational Asset Manager that you are using) to download the integration module.
  2. Recommendation: Back up the maxdb71 database and the registry on the CCMDB server:
    1. To back up maxdb71 in IBM® DB2®, in a DB command window, run the db2 backup db maxdb71 to C:\Temp.
    2. To back up the registry, follow this path:
      C:\Program Files\IBM\Common\acsi\bin>backupdb.cmd

You need to use the Tivoli base services to install the integration module on the CCMDB repository:

  1. Open a command line.
  2. Change the directory (type cd) to the CCMDBInstallation\bin directory.
  3. Run solutionInstallerGUI.
  4. Install the Rational Asset Manager IM (imram_x.x.zip) by using the CCMDB's Process Solution Installer (PSI):
    1. Select Language on the Tivoli base services GUI.
    2. Click Next and choose a PSI installable package.
    3. Select imram_x.x.zip.
    4. Click Next and accept the license agreement.
    5. Enter the required user IDs and passwords.
    6. Click Next, and verify that all of the requirements associated with development operation have been satisfied.
    7. Click Next and proceed with the Rational Asset Manager integration module installation.
    8. Verify that the package was successfully deployed.
    9. Click Done.
  5. Log into Maximo (http://host_name/maximo) and click Help ? System Information.
  6. Verify that the Rational Asset Manager integration module is installed.

2. Create a discovery library adapter output file

The topics in this section provide instructions for manually generating the DLA output file and for installing and configuring a discovery library adapter that will create a DLA output file by searching the Rational Asset Manager repository.

Note:
You must be a repository administrator or a community administrator to create a connection.

  1. Create a DLA output file that uses a search filter to define a set of assets for the DSL:
    1. In the Rational Asset Manager Web client, click Administration.
    2. Click the name of the community that you want to connect to the CCMDB. For example, you could create a RAMCCMDB community.
    3. Click Connections.
    4. In the Change and Configuration Management Database section, click New Connection.
    5. On the connection properties page, complete the form with these details of the CCMDB installation:
      • Name: Type RAM-CCMDB for the connection name. The name "RAM-CCMDB" is merely an example.
      • Description: Optionally, type a detailed description of the connection. The description can include spaces and special characters.
      • URL: Enter the fully qualified URL, including the port number, to use when accessing the CCMDB application. For example: https://www.example.com:9443/meaweb/services
      • Login: Type the user ID of a user authorized to access the CCMDB.
      • Password: Type the user's password for accessing CCMDB.
      • Default asset owner: Click Select Owner to choose the Rational Asset Manager user who will own the assets that are created in the Rational Asset Manager repository from the CCMDB CIs.
      • Synchronization schedule: Click Edit to modify how frequently the Rational Asset Manager repository will synchronize with the CCMDB repository. You can choose to synchronize daily or weekly at a specific time or at an interval specified in minutes or hours.
    6. Click OK.

When configuring CCMDB to use the Rational Asset Manager repository as a DSL, you can generate a DLA output file that contains a list of specific software assets that CCMDB will use. To specify which assets will be included in the DLA output file, you must define a search shortcut that uniquely identifies those assets:

  1. Click Assets to go to the Search for Assets page.
  2. Search for the approved assets.
  3. Click the View search shortcut icon (the magnifying glass) below the search text field.

A text field opens beside the icon, as shown in Figure 1, with the search shortcut: ramSearch:(1fState,approved)

Figure 1. Rational Asset Manager search text field
shortcut field selected
  1. Copy the entire search shortcut from the text field.
  2. Return to the Connection Properties page and paste the search shortcut into the Search Text field.
  3. To create an output DLA file to be saved on the file system, click Generate DLA Output, as shown in Figure 2.
Figure 2. Discovery library adapter generation

3. Load the discovery library adapter output file into the TADDM

A DSL requires an operational management product (OMP). To create an OMP in the CCMDB, you must use the TADDM to propagate information contained in a Rational Asset Manager DLA output file to the CCMDB.

  1. Load the Rational Asset Manager DLA output file to TADDM. On the TADDM server, from a command line, navigate to the cmdb\dist\bin folder and run the following command:
    loadidml -f <dla_output_file>
    where <dla_output_file> is the full path to and name of the discovery library adapter file
  2. You can verify that the DLA output file was loaded:
    1. Launch the TADDM application and click Start Product Console. If prompted, enter your user ID and password.
    2. Click Edit MSS.
    3. The MSS list should contain an entry that matches the DLA output file. The product name in the MSSName entry will be Rational Asset Manager.
    4. Select the MSS and click List Configuration Items (CIs)

The Configuration Item list in Figure 3 shows the Rational Asset Manager assets.

Figure 3. List of Rational Asset Manager CIs
table with 4 columns

4. Map actual CIs from TADDAM to CCMDB using the ITIC adapter

IBM Tivoli Integration Composer (ITIC) uses information from the Rational Asset Manager DLA output file to create the OMP in CCMDB.

First, set up the CI type adapter:

  1. Create a CI type schema in the database.
    1. In a DB command window, run the appropriate createTADDM71CITypeDataSchema file for your database (located in the <ITIC_root_dir>\data\dataschema folder).
  2. Create a TADDM data source.
    1. Start the ITIC application (for example, in the <ITIC_root_dir>\bin folder, run startFusion.bat (for Microsoft® Windows®) or startFusion.sh (for UNIX®-based systems).
    2. Click Define New Data Source.
    3. Select TADDM CI Type.
    1. For the data source name, enter TADDMCIType.
    2. Select Connection Method: IBM Configuration and Tracking API.
      • Host name: Type the host name for the TADDM server (not the database).
      • Port: Type the RMI port for the TADDM server. The default value is 9530. If you are using SSL, the default value is 9531.
      • User name: Type the user name for a TADDM account with administrator privileges.
      • Password: Type the password for the TADDM use
    3. Click Test Connection.
    4. Click OK.
  3. Define a new data schema for Maximo.
    1. Go to the ITIC application.
    2. Click Define New Data Schema.
    3. Type a data schema name: CCMDB71Classification.
    4. Select the appropriate connection method for the database:
      • DB2: IBM DB2 JDBC Driver
      • Oracle: Oracle JDBC Thin Driver
      • SQL server: i-net OPTA JDBC Driver for Microsoft® SQL Server 7/2000
    5. Host name: Type the host name for the CCMDB database server.
    1. Port: Type the port number for the machine. The default values are:
      • DB2: 50005
      • Oracle: 1521
      • SQL server: 1433
    2. Database: Type the name of the database: maxdb71.
    3. User name: Type the user name for the user who created the Maximo tables in the database.
    4. Password: Type the user's password.
    5. Table owner: Type the user name for the user who created the Maximo tables in the database.
    6. Click Test Connection.
    7. Click OK.
  4. Finalize the CI type schema.
    1. In a database command window, run the appropriate qualifierCCMDB71Classification file for your database (located in the <ITIC_root_dir>\data\dataschema folder).
    2. Create CI type mappings.
      • Go to ITIC application.
      • Select Create New Mapping.
      • Source: TADDMCIType
      • Target: CCMDB71Classification
      • Name: taddm-2-ccmdb-citypes
    3. Import CI Type mapping file.
      • Select action Import.
      • Select the mapping file: TADDM71CITypeToCCMDB71Classification.fsn
      • Select action Save.
      • Close and reopen the ITIC application.
    4. Execute the CI type mapping.
      • Go to a cmd prompt.
      • Change directory (cd) to the integration composer\bin directory.
      • Run commandline taddm-2-ccmdb-citypes maximo password administrator collation maximo password where <password> is the password for the Maximo database user.
      • View the logs if want to verify your actions: <installdir>\data\fusion.log

Next, activate the CI types:

  1. Log into the Base Services/CCMDB application (http://host_name/maximo).
  2. Click Go To > Administration > CI Type.
  3. Search for these files:
    • APP.SOFTWAREIMAGE
    • SYS.COMPUTERSYSTEM
    • SYS.OPERATINGSYSTEM
    • APP. DEFINITESOFTWARELIBRARY
  4. Using the Change Status icon, change the status to Active.
  5. Click Save.

Then set up the actual CI adapter:

  1. Create that actual CI schema in the database:
    1. In a database command window, run the appropriate createTADDM71ActualCIDataSchema for your database (located in <ITIC_root_dir>\data\dataschema folder).
  2. Create TADDM data source:
    1. Start the ITIC application (for example, in the <ITIC_root_dir>\bin folder, run startFusion.bat (for Windows) or startFusion.sh for UNIX-based systems).
    2. Click Define New Data Source.
    3. Select TADDM CI Type.
    4. For the data source name, enter TADDMActualCI.
    5. Select Connection Method: IBM Configuration and Tracking API
    6. Host name: Type the host name for the TADDM server (not the database).
    7. Port: Type the RMI port for the TADDM server. The default value is 9530. If using SSL, the default value is 9531.
    8. User name: Type the user name for a TADDM account with administrator privileges.
    9. Password: Type the password for the TADDM user.
    10. Click Test Connection.
    11. Click OK.
  3. Define new data schema for Maximo:
    1. Go to ITIC application.
    2. Click Define New Data Schema.
    3. Type a data schema name: CCMDB71ActualCI.
    4. Select the appropriate connection method for the database:
      • DB2: IBM DB2 JDBC Driver
      • Oracle: Oracle JDBC Thin Driver
      • SQL server: i-net OPTA JDBC Driver for Microsoft SQL Server 7/2000
    5. Host name: Type the host name for the CCMDB database server.
    6. Port: Type the port number for the machine. These are the default values:
      • DB2: 50005
      • Oracle: 1521
      • SQL server: 1433
    7. Database: Type the name of the database: maxdb71.
    8. User name: Type the user name for the user who created the Maximo tables in the database.
    9. Password: Type the user's password.
    10. Table owner: Type the user name for the user who created the Maximo tables in the database.
    11. Click Test Connection.
    12. Click OK.
  4. Import the data schema:
    1. Select Import Data Schema: CCMDB71ActualCI.schm.
    2. Fix any errors, and then click OK.
    3. Click Save.
  5. Finalize the actual CI schema:
    1. In the database command window, run the appropriate qualifierCCMDB71ActualCI file for your database (located in <ITIC_root_dir>\data\dataschema folder).
  6. Create actual CI mappings:
    1. Go to the ITIC application.
    2. Select Create New Mapping.
    3. Source: TADDMActualCI
    4. Target: CCMDB71ActualCI
    5. Name: taddm-2-ccmdb-actualci
  7. Import the actual CI mappings file:
    1. Select Import.
    2. Select the mapping file: TADDM71CITypeToCCMDB71ActualCI.fsn
    3. Click Save.
    4. Close and reopen the ITIC application.
  8. Run the CI type mapping:
    1. Go to a cmd prompt
    2. Change directory (cd) to the integration composer\bin directory
    3. Run commandline taddm-2-ccmdb-atualci maximo password administrator collation maximo password, where <password> is the password for the Maximo database user.
    4. View the logs if necessary: <installdir>\data\fusion.log
  9. Verify the mapping:
    1. Start the ITIC application adapter.
    2. Click Open Existing Mapping.
    3. Verify the taddm-2-ccmdb-atualci and taddm-2-ccmdb-ci types mapping names, as shown in Figure 4.
Figure 4. Sample ITIC mapping
Open Mapping view lists 2 items

Now verify that the data was imported into CCMDB:

  1. In CCMDB, click Go To > IT Infrastructure > Actual Configuration Items.
  2. Search for items that should have been imported and confirm that they are present. If you find them, then you have successfully imported the data.

5. Configure the integration module in the CCMDB

Create and configure the integration module in the CCMDB.

Set up Web services

To set up Web Services in CCMDB:

  1. Click Go To > Integration > Web Services Library.
  2. Open the Web Services Library page.
  3. In the Select Action menu, select Create Web Service > Create WS from Object Structure.
  4. Create the following Web services:
    • MXAUTHCI
    • MXCLASSIFICATION
    • MXOMP
  5. On the List page, click Records. See Figure 5.
  6. Check the Web services created in the earlier step.
  7. In the Select Action menu, click Deploy Web Service.
Figure 5. Web Services Library view
cursor in Name field

Set up the Integration module

  1. Select Go To > Integration > Integration Modules.
  2. Search for RAMIM.
  3. On the Integration Module page:
    1. Click the Logical Management Operations tab and verify that the IMPORTSOFTWAREIMAGE operation is added, as Figure 6 shows.
    2. Click the Operational Management Products tab.
    3. Click the New Row under Operational Management Products for RAMIM to add the OMP.
Figure 6. Integration Modules view
Logical Management Operations section circled

6. Define an end point

  1. Click the button next to the End Point field and select Go To End Points. (See Figure 7.)
Figure 7. Operational Management Products page
Option circled in lower-right corner
  1. On the End Points page:
    1. Click New End Point to create a new end point.
    2. Enter RAMENDPOINT as name of the end point.
    3. Click the Handler icon to select the Handler.
    4. Select RAMHANDLER (com.ibm.ram.ccmdb.im.ram.RAMHandler).
    5. In the Properties for the End Point, complete the following fields as shown in Figure 8:
      • URL: Enter the URL of the Rational Asset Manager server application; for example, http://host:port/com.ibm.ram.repository.web.was, where host is the fully qualified name or IP address of the server and port is the port number. The repository location can be found on the Extensions page of the Rational Asset Manager Web client in the Eclipse Client Plug-in section.
      • PASSWORD: Type the password for a Rational Asset Manager administrator.
      • USERNAME: Type the user ID for a Rational Asset Manager repository administrator.
      • Click Save to save the end point.
      • Click Return With Value.
Figure 8. End points page
Shows fields described
  1. On the Integration Module page, click Save to save the integration module configuration.

7. Create the definitive software library

  1. In CCMDB, click Go To > Release > Definitive Software Library.
  2. Click Create DSL.
  3. In the Name field, type RAM TEST as the name of the DSL configuration.
  4. Optionally, type a description for the DSL.
  5. In the Owner field, click Select Value and select maxadmin as owner for the DSL.
  6. In the Details section:
    1. In the Classification Path field, click Classify.
    2. In the Classify window, select the Rational Asset Manager Repository entry. The classification is from the Rational Asset Manager integration module that was installed in the CCMDB.
  7. In the Scope section, check Source Code and Binary.
  8. In the Management Application section:
    1. In the Name field, click Select OMP.
    2. In the Select OMP window, select the Rational Asset Manager OMP to use for this DSL.
  9. Click Save DSL.
  10. Click on the Software Images page:
    1. Click Select from OMP.
    2. Select the Software Images and click OK.
    3. Click Save DSL.

8. Synchronize the asset from the CCMDB with Rational Asset Manager

  1. Log into Rational Asset Manager Web client.
  2. Go to the RAMCCMDB community.
  3. Go to the Change and Configuration Management Database Connections section.
  4. Click Synchronize.
  5. Click the Assets page.
  6. Search for the remote asset.
  7. The search returns the CCMDB CIs.
  8. The CIs shown in Figure 9 synchronized from the Tivoli CCMDB to Rational Asset Manager.
Figure 9. Synchronized the assets
Results of search for assets
  1. Go to any remote asset.

The remote assets in the Rational Asset Manager repository retain much of the information from the CCMDB CI. Figure 10 shows the Rational Asset Manager details synchronized from the CCMDB.

Figure 10. Rational Asset Manager asset from the CCMDB
Updated view confirms synchronization

Click to see larger image

Figure 10. Rational Asset Manager asset from the CCMDB

Updated view confirms synchronization

Conclusion

The Rational Asset Manager Integration Module is now installed and configured in the CCMDB environment, so you can now create CIs in CCMDB from existing assets in the repository. The CCMDB CIs have successfully synchronized with the Rational Asset Manager server.

Acknowledgements

The author thanks the following people for their technical contributions to this article.

  • Saurabh Agarwal
  • Barbara Fierro
  • Tracey Brown Burton

Abbreviation definitions

CCMDB: Change and Configuration Management Database

CI: configuration item

DSL: definitive software library

ITIC: IBM Tivoli Integration Composer

OMP: operational management product

PSI: Process Solution Installer

TADDM: Tivoli Application Dependency Discovery Manager

Resources

Learn

Get products and technologies

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Rational software on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Rational, Tivoli
ArticleID=359949
ArticleTitle=How to integrate IBM Rational Asset Manager with your IBM Tivoli database
publish-date=12232008