Normalization and reconciliation: recommended procedure for ITSM CI data Loaded through Data Management
From the Data Management > Job Console, when you create a job using the BMC templates for CI-CMDB and Asset data existing in the Transactional_CI.xlsm, Transactional_Asset.xlsm, and Transactional_CI_Express.xlsm spreadsheets, you need to run reconciliation process manually or schedule the reconciliation process after completing the load, validate, and promote steps successfully.
Reconciliation process enables you to compare data from different data sources and to create one complete and correct production dataset. Before reconciling the BMC Remedy ITSM CI and Asset data loaded through Data Management, you may choose to normalize data to make sure that product names and categorization are consistent across different datasets and from different data providers. Normalizing data is optional.
The Transactional_CI.xlsm, Transactional_Asset.xlsm, and Transactional_CI_Express.xlsm spreadsheets are located at Data Management > Spreadsheet Management > Spreadsheet Type > BMC Template.
Normalizing and reconciling the BMC Remedy ITSM CI and Asset data
BMC recommends that you normalize data before reconciliation. For details, see Normalizing data.
You must reconcile the data loaded through the below spreadsheets:
To run the reconciliation process, execute the steps listed below:
- Choose Atrium Core > Atrium Core Console > Application Launcher > Advanced > Reconciliation.
- From the jobs list, select BMC Asset Management CI DATA LOAD as the Data Management CI jobs push the data into BMC Atrium CMDB with the dataset BMC.ITSM.CI.DATA after completing the jobs.
- Click BMC Asset Management CI DATA LOAD job. to run the
To schedule a reconciliation job, see Creating a reconciliation job schedule.