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.
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 Integrating and migrating data.
BMC provides out-of-the-box Atrium Integrator jobs, which can be configured.
To configure an Atrium Integrator job for a Load step
- In the Load Parameters panel in the Step (New) window, select the required Atrium Integrator job name from the following choices:
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.
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
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.
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.
- 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:
- In the attachment columns in your spreadsheet, enter the following path for your files and save your changes: optionalSubFolderName\fileName
- 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.
- 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.
- Zip up your files and name the .zip file folderName.zip.
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.
- 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.