This documentation supports the 22.1 version of Action Request System.
To view an earlier version, select the version from the Product version menu.

Configuring an Atrium Integrator job for a Load step

To import data from various sources, you must create an Atrium Integrator job for each Load step. These jobs provide the details that are required to find the source data store, transform the data using the specified rules, and store the data in the required target data store.


To configure an Atrium Integrator job for a Load step

  1. In the Load Parameters panel in the Step (New) window, select the required Atrium Integrator job name from the following choices:

    Job name



    Imports activity template, activity configuration rules, and activity configuration notification rule records


    Imports computer system, processor, product, and operating system CIs


    Imports company and company alias records


    Imports the following records: approver lookup, change template, change template support group association, change template associations, and task template association


    Imports configuration cost center repository and cost center user-defined association records


    Imports assignment and alternate records


    Imports generic catalog, generic product service associations, and generic company module association records


    Imports postal code records


    Imports the following records: incident template, incident template support group association, incident template associations, scripts, group event mapping, decision tree, decision tree main branch, decision tree branch, and decision tree branch item

    Load Service Agreement

    Imports service agreement and its associated milestone, action, and penalty rewards records

    Load Service Target

    Imports service target and its associated milestone, action, and goal schedule records

    Load SLM Contract

    Imports BMC Service Level Management contract


    Imports people from an LDAP server to the CTM:LoadPeople form


    Imports site, site alias, region, site group, and site company association records


    Imports operational catalog and operational catalog association records


    Imports people records


    Imports people organization records


    Imports the following records: product catalog, product alias, product company association, product model version, product model version patch, and product catalog alias mapping


    Imports the following records: release milestone exit criteria, release approver lookup, release template, release template associations, release template support group associations, release configuration rules, release configuration prioritization, release configuration notification rules, release milestone phases


    Imports the following records: support group, support group assignment, support group alias, support group on call, business work days, and business holiday


    Imports pager service configuration records


    Imports the following records: task group template, task template, task association template, task flow template, task assignment configuration, task variable template, and task variable mapping


    Imports activity and activity work information records


    Imports asset work log, asset to asset relationship, asset people, and CI records


    Imports infrastructure change, change work log, change impacted areas, and signature records


    Imports contract records


    Imports incident, incident association, incident work log, and incident impacted area records


    Imports the following records: problem investigation, problem investigation work log, problem impacted areas, problem known error, problem known error work log, problem solution database, problem solution alias, problem solution work log, and problem solution database additional mapping


    Imports release worklog, release signature, and release records


    Imports support group associations for broadcasts, and financial data (including costs and payments) for applications.


    Imports tasks, task group, and task work information records

    The Variables panel displays the following information which is used by Atrium Integrator to connect the BMC Remedy AR System server with the import process.




    BMC Remedy AR System server user name

    You only need to make this change once. If you modify AR_USER, the new value propagates to all the Load steps.

    Best practice

    If you have selected either the Transactional_Asset or CI-CMDB Atrium Integrator job, we recommend that you keep BMC.ITSM.CI.DATA, which is the default, as the DATASETID variable to ensure that the data is reconciled correctly with the production dataset. You will need to highlight the DATASETID variable in the Variables table to display the DATASETID entry field.

    Do not load data directly to the BMC.ASSET production dataset.

  2. Select either the name of the User's data spreadsheet (created using Spreadsheet Management) that will be attached to the Atrium Integrator job from the Spreadsheet drop-down list or click Add to browse locally and manually add the spreadsheet as an attachment.
    This process will also pull in the attachments .zip file if one exists for the spreadsheet.

    If you have attachment fields with data in your ARX files or Excel spreadsheets, you must add an attachment .zip file. To load spreadsheets with attachments:

    1. In the attachment columns in your spreadsheet, enter the following path for your files and save your changes: optionalSubFolderName\fileName
    2. Create a folder on your local hard drive.
      If you are attaching files that have a shared file name you must put these in separate local sub-folders before zipping them. Your spreadsheets will need to reference these sub-folders.

    3. Put all of the files that you want to attach to the staging form record, and have identified in the attachment columns of your spreadsheet, in this folder. You can create subfolders if required.
    4. Zip up your files and name the .zip file


      The file must be a .zip file. No other compression formats are supported.

      When you export an ARX file, the attachment directory is automatically created and you can make a zip file by zipping up the directory.


      If you remove a spreadsheet, by clicking Remove, you will also remove the attachments .zip file.

  3. To save the step, click Save.
    After your Data Management job has a status of Built, and you choose to run the job, the Atrium Integrator job runs. When the job finishes running, the Load step is set to Completed.

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