Best practice for normalizing and reconciling ITSM data loaded through Data Management

Reconciliation process enables you to compare data from different data sources and to create one complete and correct production dataset. Before reconciling the BMC Helix ITSM CI and Asset data loaded through Data Management, you can choose to normalize the data to make sure that product names and categorization are consistent across different datasets and from different data providers. This step to normalize data is an optional step. The following image shows the Job Template for creating a job from the BMC Template:

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 Helix ITSM CI and Asset data 

We recommend that you normalize the data before reconciliation. For details, see To normalize data with value-mapper steps.

You must reconcile the data loaded through the below spreadsheets:

• Transactional_CI.xlsm
• Transactional_Asset.xlsm
• Transactional_CI_Express.xlsm

To run the reconciliation process, execute the steps listed below:

1. Select Atrium Core > Configuration Manager Dashboard > Manage Reconciliation.
2. From the jobs list, select BMC Asset Management CI DATA LOAD as the Data Management CI jobs push the data into CMDB with the dataset BMC.ITSM.CI.DATA after completing the jobs.
3. Run the BMC Asset Management CI DATA LOAD job. 

To schedule a reconciliation job, see Scheduling-data-load-jobs.