Error: Invalid spaceKey on retrieving a related space config.

Importing data from BMC Atrium CMDB

You can import configuration items (CIs) and relationships from BMC Atrium Configuration Management Database (BMC Atrium CMDB) into BMC Remedyforce CMDB 2.0 by using Atrium Integrator with a customized Pentaho package. The Pentaho package is available on the BMC Communities website.

The following topics provide information about importing data from BMC Atrium CMDB into BMC Remedyforce CMDB:

Note

For information about the BMC Atrium CMDB versions that BMC Remedyforce supports, see Supported browsers, mobile devices, and integrations.

Before you begin

 Before you can import data from BMC Atrium CMDB into BMC Remedyforce CMDB, you must perform the following tasks:

To import CIs from BMC Atrium CMDB

  1. Log on to BMC Remedy AR System and access the Atrium Integrator Console.
  2. To launch the Atrium Integrator Spoon, click .
  3. To create a new folder in Atrium Integrator to store your KTR and KJB files, perform the following actions:
    1. Go to Tools > Repository > Explore.
    2. Right-click the window, and select New Folder.
    3. Enter a name for the folder in which you want to save the KTR and KJB files that you have downloaded from the BMC Communities website, and click OK.
      For example, create a folder called Remedyforce.
  4. To save the KTR and KJB files in the folder, perform the following actions for each file:
    1. Click File > Open URL and browse to the folder in which you have saved the job files that you downloaded from the BMC Communities website.
    2. Open the KJB and KTR files for the required CI type, such as computer system.
    3. Click File > Save As.
    4. In the Directory field, click .
    5. Click OK.
  5. In the KJB file, double-click the AtriumtoCMDB_<CI type> step.
    For example, double-click the AtriumtoCMDB_ComputerSystem step.
  6. In the Job entry details for this transformation window, in the Specify by name and directory option, click , and select the KTR for the opened KJB file from the folder that you have created.
    For example, Remedyforce > AtriumToCMDB_ComputerSystem.ktr.
  7. Click File > Open, and open the required KTR file.
  8. In the KTR file, enter the information to access BMC Remedy AR System, the SQL server that BMC Atrium CMDB uses, and your Salesforce organization.

     Click here to see the detailed steps.
    StepActionDetails
    a.Enter the information required to access BMC Remedy AR System.Perform the following actions:
      1. Double-click the ARInput step.
      2. In the Connection field, click Edit.
      3. In the Settings section, enter the AR System server access details.
      4. (Optional) To test the connection with the server, click Test.
      5. Click OK.
    b.Enter the information required to access the SQL server that BMC Atrium CMDB uses.Perform the following actions:
      1. Double-click the Table Source step.
      2. In the Connection field, click Edit.
      3. In the Database Connection window, if you are using another database type, in the Connection Type list, select the required connection type.
        Based on the database type that you are using, the query written in the Table Source step might change. In the step, the Oracle database query is also provided in a commented form. To use the Oracle query, remove the comment marks from the query and comment the MS SQL query.
      4. In the Settings section, enter the logon information of the SQL server that the BMC Atrium CMDB database uses.
      5. (Optional) To test the connection with the database, click Test.
      6. Click OK.
    c.Enter the information required to access your Salesforce organization.Perform the following actions:
      1. Double-click Salesforce Input[CMDB_Class].
      2. In the Connection section, enter the Salesforce organization access details.
      3. (Optional) To test the connection, click Test connection.
      4. To save your changes and close the window, click OK.
      5. Double-click Salesforce Upsert.
      6. In the Connection section, enter the same Salesforce organization access details.
      7. (Optional) To test the connection, click Test connection.
      8. To save your changes and close the window, click OK.

    Note: BMC recommends that you do not change the default API version in the Salesforce Webservice URL.

  9. To save the KTR and KJB files, click .
  10. Navigate back to the Atrium Integrator Console.
  11. Select the job that you have set up, and click 
    While the data is being imported, the following log files are generated:
    • Job-level logs: Created in the Atrium Integrator Console.
    • Success, process, and error logs: Created as CSV files in the Log Files folder that you created before importing CIs from BMC Atrium CMDB. For more information, see Before you begin.
      The failure log is created only if an error occurs in inserting a record in BMC Remedyforce. The delta_value log stores the time stamp of the last time you imported data. Rejected logs are also created if records with blank unique identifier values exist.

To import relationships from BMC Atrium CMDB

Before importing relationships from BMC Atrium CMDB, perform all the actions listed in Before you begin and import all the CIs from BMC Atrium CMDB.

  1. Log on to BMC Atrium Action Request System and access Atrium Integrator Console.
  2. To launch the Atrium Integrator Spoon, click .
  3. To save the KTR and KJB files in the folder on Atrium Integrator, perform the following actions for each file:
    1. Click File > Open URL and browse to the folder in which you have saved the job files that you downloaded from the BMC Communities website.
    2. Open the AtriumtoCMDB_BaseRelationship.kjb and AtriumtoCMDB_BaseRelationship.ktr files.
    3. Click File > Save As.
    4. In the Directory field, click .
    5. Click OK.
  4. In the KJB file, double-click the AtriumtoCMDB_BaseRelationship step.
  5. In the Job entry details for this transformation window, in the Specify by name and directory option, click , and select the AtriumtoCMDB_BaseRelationship.ktr from the folder where you have saved the KTR file.
  6. Click File > Open, and open the AtriumtoCMDB_BaseRelationship.ktr file.
  7. In the AtriumtoCMDB_BaseRelationship.ktr KTR file, enter the information to access BMC Remedy AR System, the SQL server that BMC Atrium CMDB uses, and your Salesforce organization.

     Click here to see the detailed steps.
    StepActionDetails
    a.Enter the information required to access BMC Remedy AR System.Perform the following actions:
      1. Double-click the ARInput step.
      2. In the Connection field, click Edit.
      3. In the Settings section, enter the AR System server access details.
      4. (Optional) To test the connection with the server, click Test.
      5. Click OK.
    b.Enter the information required to access the SQL server that BMC Remedy AR System uses.Perform the following actions:
      1. Double-click the Table Source step
      2. In the Connection field, click Edit.
      3. In the Database Connection window, in the Connection Type list, select MS SQL Server.
        If you are using another database type, select the required connection type and enter details in the Settings section.
      4. In the Settings section, enter the SQL server access details.
      5. (Optional) To test the connection with the database, click Test.
      6. Click OK.
    c.Enter the information required to access your Salesforce organization.Perform the following actions:
      1. Double-click the Salesforce Upsert step
      2. In the Connection section, enter the same Salesforce organization access details.
      3. (Optional) To test the connection, click Test connection.
      4. To save your changes and close the window, click OK.

    Notes:

    • BMC recommends that you do not change the default API version in the Salesforce Webservice URL.
    • To enable the creation of relationships in BMC Remedyforce, do not change the mapping of the UniqueCIRelationshipID_c, UniqueDestinationCIIDc, and UniqueSourceCIID_c fields.
  8. If you have created custom relationships in the database used by BMC Atrium CMDB, perform additional actions.

     Click here to see the detailed steps.
    1. In Salesforce, navigate to Setup > Create > Objects.
    2. In the Label column, click Base Relationship.
    3. In the Custom Fields & Relationships section, click Type.
    4. On the Base Relationship Custom Field Type page, in the Picklist Values section, click New.
    5. Enter the name of the BMC Atrium CMDB custom relationship, and click Save.
    6. Repeat step 8d and step 8e for all custom relationships that you are importing.
    7. Navigate to the Atrium Integrator Spoon.
    8. In the AtriumtoCMDB_BaseRelationship.ktr file, double-click the Read Response Variable step.
    9. Copy and paste the last "else if" statement.
      For example, else if(endsWith(ClassIdUpper,"BMC_SETTINGOF")){TypeScript="Setting Of";}
    10. Replace the first class string with the class ID of the custom relationship and the second text string with the value that you have added in the Type field, and save the step.
      For example, say that you are importing the mobile custom relationship type from BMC Atrium CMDB and in the Type field, you have added the Atrium Mobile value. In the Read Response Variable step, replace the text strings with the following text:

      else if(endsWith(ClassIdUpper,"MOBILE")){TypeScript="Atrium Mobile";}

      Ensure that the first text string is in uppercase. In this statement, ClassIdUpper is the name of the custom relationship in BMC Atrium CMDB, and TypeScript is the value that you have entered in the Type field.
    11. Repeat step 8i and step 8j for all custom relationships that you are importing.
  9. To save the KTR and KJB files, click .
  10. Navigate back to the Atrium Integrator Console.
  11. Select the job that you have set up, and click .
    While the data is being imported, the following log files are populated:
    • Job-level logs: Created in the Atrium Integrator Console.
    • Success, process, and error logs: Created as CSV files in the Log Files folder that you created before importing CIs from BMC Atrium CMDB. For more information, see Before you begin.
      The error log is created only if an error occurs in inserting a record in BMC Remedyforce. The delta_value log stores the time stamp of the last time you imported data. Rejected logs are also created if records with blank unique identifier values exist.

To schedule import jobs from the Atrium Integrator Console

  1. Go to the Atrium Integrator Console.
  2. Save the combined job KJB files in the Atrium Integrator folder in which you saved the KJB and KTR files for CIs and relationships.
  3. In the KJB and KTR files for all the CIs, provide the information required to access the BMC Remedy AR System, SQL database used by BMC Remedy AR System and your Salesforce organization.
    For more information, see To import CIs from BMC Atrium CMDB and To import relationships from BMC Atrium CMDB.
  4. Schedule the jobs (the combined job KJB files) in the following sequence:
    • AtriumToCMDBComputerSystem&Hardware
    • AtriumToCMDBComputerSystem&SoftwareServer
    • AtriumtoCMDB_BaseRelationship

KJB and KTR files for importing data from BMC Atrium CMDB

The Pentaho package contains job (KJB) and transformation (KTR) files that are created in the Pentaho Data Integration tool. The KJB files (jobs) and KTR files (transformations) store metadata in XML format. A KJB file contains a series of transformations that are run in a sequence. A KTR file contains a single transformation. The KJB (job) files retrieve data from external sources into BMC Remedyforce CMDB.

KJB files in the Pentaho package

The Pentaho package includes different KJB (job) files for importing different types of CIs, such as computer systems and LAN endpoints, from BMC Atrium CMDB. These job files are bundled with related files and provided to you in folders. The folder names correspond to CI types in BMC Remedyforce CMDB.

The following table provides information about the job files that you must run to import specific CI types to BMC Remedyforce CMDB:

Folder name (CI Type)

Job file

Job description

Application

AtriumToCMDB_Application.kjb

Transfers information about the
BMC_Application CI type.

ApplicationService

AtriumToCMDB_Application
Service.kjb

Transfers information about the
BMC_ApplicationService
CI type.

BusinessService

AtriumToCMDB_Business
Service.kjb

Transfers information about the
BMC_BusinessService CI type.

Cluster

AtriumToCMDB_Cluster.kjb

Transfers information about the
BMC_Cluster CI type.

ComputerSystem

AtriumToCMDB_Computer
System.kjb

Transfers information about the
BMC_ComputerSystem
CI type.

Concrete Collection

AtriumToCMDB_Concrete
Collection.kjb

Transfers information about the
BMC_ConcreteCollection
CI type.

Database

AtriumToCMDB_Database.kjb

Transfers information about the
BMC_Database CI type.

IPConnectivitySubnet

AtriumToCMDB_IPConnectivity
Subnet.kjb

Transfers information about the
BMC_IPConnectivitySubnet CI type.

IPEndPoint

AtriumToCMDB_IPEndPoint.kjb

Transfers information about the
BMC_IPEndPoint CI type.

LANEndPoint

AtriumToCMDB_LANEndPoint.kjb

Transfers information about the
BMC_LANEndpoint CI type.

NetworkPort

AtriumToCMDB_NetworkPort.kjb

Transfers information about the
BMC_NetworkPort
CI type.

Offering

AtriumToCMDB_Offering.kjb

Transfers information about the
BMC_Offering
CI type.

OperatingSystem

AtriumToCMDB_Operating
System.kjb

Transfers information about the
BMC_OperatingSystem CI type.

Printer

AtriumToCMDB_Printer.kjb

Transfers information about the
BMC_Printer CI type.

Processor

AtriumToCMDB_Processor.kjb

Transfers information about the
BMC_Processor
CI type.

Product

AtriumToCMDB_Product.kjb

Transfers information about the
BMC_Product CI type.

Rack

AtriumToCMDB_Rack.kjb

Transfers information about the
BMC_Rack CI type.

SoftwareServer

AtriumToCMDB_Software
Server.kjb

Transfers information about the
BMC_SoftwareServer CI type.

VirtualSystemEnabler

AtriumToCMDB_VirtualSystem
Enabler.kjb

Transfers information about the
BMC_VirtualSystemEnabler CI type.

Combined Packages

  • AtriumToCMDB_Computer
    System&Hardware.kjb
  • AtriumToCMDB_Computer
    System&Software Server.kjb
  • AtriumToCMDB_Computer
    System&Hardware.kjb
    This file transfers information the BMC_ComputerSystem, BMC_Cluster. BMC_ConcreteCollection, BMC_IPConnectivitySubnet, BMC_IPEndPoint, BMC_LANEndPoint, BMC_NetworkPort, BMC_Printer, BMC_Processor, BMC_Rack, and BMC_VirtualSystem CI types.
  • AtriumToCMDB_Computer
    System&Software Server.kjb

    This file transfers information about the BMC_ComputerSystem, BMC_OperatingSystem, BMC_SoftwareServer, BMC_ApplicationService, BMC_Product, BMC_Database, BMC_BusinessService, BMC_BusinessOffering,BMC_Application CI types.

BaseRelationship

AtriumToCMDB_Base
Relationship.kjb

Transfers information about relationships in BMC Atrium CMDB.

KTR files in the Pentaho package

Each KJB file (job file) that is provided for importing data from BMC Atrium CMDB contains the following steps:

  • Start
  • AtriumToCMDB_<CI type>

The AtriumToCMDB_<CI type>.ktr file (AtriumToCMDB_<CI type> step) contains the following steps to import data from BMC Atrium CMDB.

Step

Description

ARInputGets time stamp for this package and saves it in the NGIE:Delta form of the BMC Remedy AR System server.
Table SourceFetches information from the Microsoft SQL server that is used by BMC Remedy AR System about CIs that are modified after the time displayed in the stored time stamp. When you import data for the first time, all CIs are imported.
Read Response Variable

Facilitates JavaScript transformations, such as appending or trimming field values.

For example, in the BMC Remedy AR System, the value of the Mark As Deleted field is stored as a boolean value (0 or 1); whereas in BMC Remedyforce, the value of the field is stored as True or False. In this step, 0 or 1 is changed to True or False.

Salesforce Input[CMDB_Class]Accepts the Salesforce organization access details to fetch the details of the BMC Remedyforce CMDB classes.
Get CMDB Class IDFetches the class ID of the BMC Remedyforce CMDB class for the source record. For example, if the source is a computer system record, it fetches the class ID of the BMC_ComputerSystem class from the BMC Remedyforce CMDB.

Unique Identify Filter

Removes all records that have a blank unique identifier field and saves the records in a CSV file that is defined in the rejected records as a reference log.

Salesforce UpsertAccepts the Salesforce organization access details where you want to save the imported data. This step also displays field mapping between BMC Remedyforce and BMC Atrium CMDB fields.
Success loggingStores the rows that are imported successfully.
Error loggingStores the error code, error description, error fields, and field values for the rows that are not imported successfully.
Identify last row in a streamFetches the last record from the successfully imported records (sorted by the date they were modified).
AROutputSaves the modified date of the record fetched in the Identify last row in a record stream step into the NGIE:Delta form record that correspond to the running KTR.

Related topics

Overview of how is data imported in BMC Remedyforce

Applying models while importing CIs and assets

Troubleshooting common issues when importing data

Was this page helpful? Yes No Submitting... Thank you

Comments