Configuring after installing Remedy OnDemand integration

Once you install the integration, you must perform the following actions in BMC Remedy Action Request (AR) System to use the integration.


To import CMDB schema to BMC Remedy AR System by using CMDB driver

  1. Download and copy extensions.zip file to any location in BMC Remedy AR System server. For information about how to download extensions.zip from EPD, see Downloading the installation files for Remedy OnDemand integration.
  2. Unzip and extract the extensions.zip file in a temporary directory in AR server.
  3. Go to BMC Remedy AR System server.
  4. Go to <ATRIUMCORE_INSTALLED_DIR>\cmdb\server64\bin directory and double-click cmdbdriver.exe. 

  5. Provide the following inputs and click Next.

    Field

    Value

    Command

    impdf

    Number of Import Items<0>

    Enter

    Import Option: Create/Overwrite

    2

    Filename containing import data

    C:\AR-Extensions\extensions\205-SCHEMAEXT\ BL2Atrium_Extension.xml

  6. Click Finish.

To import ARX files to BMC Remedy AR System

  1. Log on to the computer where the BMC Remedy AR System server is installed. The dataimporttool utility that is used to import the ARX files is present in the <ATRIUMCORE_INSTALLED_DIR> directory.
  2. Go to <ATRIUMCORE_INSTALLED_DIR> directory and double-click dataimporttool to open the tool.
  3. Log on into dataimporttool tool by using AR username and password.
  4. Click File > New Mapping.
  5. Click Source Data File and browse to ..\extensions\500-BLRule directory. 500-BLRule is in the temporary directory that you created in To import CMDB schema by using CMDB driver.
  6. Select an ARX file and click Open.
  7. Select Target Server.
  8. Copy Source From Name.
  9. Browse Target From Name and paste in the Name field.
  10. Select the value of first row and click OK.
  11. Click Automap.

  12. Click Start importing records from import file.

    ARX3.png

  13. Click OK.

    Note

    Perform the above steps for all ARX files except ****_95 ARX files. Do not import ****_95 ARX files.

To import KTR and KJB files to BMC Remedy AR System


    1. Download and copy AI-Jobs-ForRemedy9104.zip file to any location in BMC Remedy AR System server. For information about how to download AI-Jobs-ForRemedy9104.zip from EPD, see Downloading the installation files for Remedy OnDemand integration.
    2. Unzip and extract the AI-Jobs-ForRemedy9104.zip file in a temporary directory in AR server.
    3. Go to BMC Remedy AR System server and click BMC Atrium Integrator Spoon to launch the Pentaho Data Integration tool.
    4. Log on to BMC Atrium Integrator Spoon by using AR username and password.
    5. Go to File>Import form an XML file.
      Spoon2.png
    6. Select a KTR file and click Open. The KTR files are present in the temporary directory that you created in step 2 while extracing AI-Jobs-ForRemedy9104.zip file.
    7. In the menu, click save a current file.
      Spoon4.png
    8. Browse to Directory and right-click and click New sub-directory.
    9. In the Name field, enter BL2ATRIUM_REPO.
      spoon5.png
    10. Select BL2ATRIUM_REPO and click OK.

Note

Perform the above steps for all KTR and KJB files.


To create a new database connection in BMC Remedy AR System


    1. Go to BMC Remedy AR System server and click BMC Atrium Integrator Spoon to launch the Pentaho Data Integration tool.
    2. Log on to BMC Atrium Integrator Spoon by using AR username and password.
    3. Go to Database Connections.
    4. Right-click Database Connections and select New.

      NewDBcon1.png

    5. Provide the following information to create a new database connection:

      Parameter

      Description

      Connection Name

      BL_DB_CONNECTION

      Host Name

      Name or IP address of the server hosting the SQL Server database (for example, BMC Decision Support for Server Automation Database Host name).

      Database Name

      Name of the SQL Server database that contains TrueSight Server Automation discovered data (for example, TSSA_DW)

      Port Number

      Port number of the database server hosting the SQL Server database (for example, 1433 for SQL Server)

      User Name

      Name of the user that has an administrative account on the SQL Server database (for example, sa)

      Note: You must specify the user name of the BMC Decision Support for Server Automation database using the exact case.

      Password

      Password of the user that has an account on the SQL Server database

      NewDBcon2.png

    6. Click OK.

To update a database connection in BMC Remedy AR System

This step is applicable only if you are using multiple Remedy OnDemand instances with single TrueSight Server Automation application server.


    1. Go to BMC Remedy AR System server and click BMC Atrium Integrator Spoon to launch the Pentaho Data Integration tool.
    2. Log on to BMC Atrium Integrator Spoon by using AR username and password.
    3. Go to Database Connections.
    4. Double-click the the BL_AR_CONNECTION database connection. 

    5. Provide the following information to update the database connection and click OK.

      Parameter

      Description

      Connection Name

      BL_AR_CONNECTION

      TCP Port Number

      TCP port number of the AR server.

      RPC Port Number

      RPC port number of the AR server.

      User Name

      Name of the user that has an administrative account on the AR Server database.

      Authentication

      Authentication to be used.

      RoD_BLARConnection.png

    6. Double-click the the BL_DB_CONNECTION database connection. 

    7. Provide the following information to update the database connection and click OK.

      Parameter

      Description

      Connection Name

      BL_DB_CONNECTION

      Host Name

      Name or IP address of the server hosting the SQL Server database (for example, BMC Decision Support for Server Automation Database Host name).

      Database Name

      Name of the SQL Server database that contains TrueSight Server Automation discovered data (for example, TSSA_DW).

      Port Number

      Port number of the database server hosting the SQL Server database (for example, 1433 for SQL Server).

      User Name

      Name of the user that has an administrative account on the SQL Server database (for example, sa).

      Note: You must specify the user name of the BMC Decision Support for Server Automation database using the exact case.

      Password

      Password of the user that has an account on the SQL Server database.

      RoD.png

    8. Double-click the the PDIREPO database connection.

    9. Provide the following information to update the database connection.

      Parameter

      Description

      Connection Name

      PDIREPO

      TCP Port Number

      TCP port number of the AR server.

      RPC Port Number

      RPC port number of the AR server.

      User Name

      Name of the user that has an administrative account on the AR Server database.

      Authentication

      Authentication to be used.

      RoD_PDIRepo.png 

    10. Click OK

When you integrate TrueSight Server Automation with multiple Remedy OnDemand instances, the RECONCILIATION_IDENTITY server property is updated. RECONCILIATION_IDENTITY is the reconciliation identifier from CMDB.

For example, when you integrate a Remedy OnDemand instance (RoD1) with TrueSight Server Automation, the RECONCILIATION_IDENTITY saved in TrueSight Server Automation is OI-A8D6B44438CC4AE8B3009356A36EFB7C. When you integrate another Remedy OnDemand instance (RoD2) with TrueSight Server Automation, the value of the RECONCILIATION_IDENTITY is updated with the new value from CMDB, OI-B8D6Y43438XX4AE8H3009356A36EFB9D.

Where to go from here

Supporting-BMC-Atrium-Service-Context.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*