This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

To view the latest 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.

Note

BMC Remedy AR System provides an Atrium Integrator adapter plug-in that enables you to create and run your own data transformations. For more information, see Atrium Integrator adapter for BMC Remedy AR System.


BMC provides out-of-the-box Atrium Integrator jobs, which can be configured.

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

    Description

    Activity_Process_Setup

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

    CI-CMDB

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

    Company

    Imports company and company alias records

    Change_Process_Setup

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

    Financials

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

    Foundation_Process_Setup

    Imports assignment and alternate records

    Generic_Catalog

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

    Geography

    Imports postal code records

    Incident_Process_Setup

    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

    LDAP_People

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

    Location

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

    OperationalCatalog

    Imports operational catalog and operational catalog association records

    People

    Imports people records

    PeopleOrg

    Imports people organization records

    Product_Catalog

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

    Release_Process_Setup

    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

    Support_Group

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

    System_Setup

    Imports pager service configuration records

    Task_Process_Setup

    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

    Transactional_Activity

    Imports activity and activity work information records

    Transactional_Asset

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

    Transactional_Change

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

    Transactional_Contract

    Imports contract records

    Transactional_Incident

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

    Transactional_Problem

    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

    Transactional_Release

    Imports release worklog, release signature, and release records

    Transactional_Shared_Components

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

    Transactional_Task

    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.

    Variable

    Value

    AR_USER

    BMC Remedy AR System server user name

    Note

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

    Recommendation

    If you have selected either the Transactional_Asset or CI-CMDB Atrium Integrator job, BMC recommends 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 DATSETID 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.

    Note

    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.

      Note

      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 sub-folders if required.
    4. Zip up your files and name the .zip file folderName.zip.

      Warning

      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.

      Note

      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.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments

  1. Arjun Nagabandla

    Hi Team,

    Can you please advise above mentioned jobs in section "To configure an Atrium Integrator job for a Load step" are provided Out of the box or Do I need to import them?

    We have 8.0 installed in our environment.

    Aug 24, 2015 10:30