Best practice for normalizing and reconciling ITSM 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. 

Related topics

Normalization best practices to achieve improved performance

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.

CI-CMDB job creation.PNG

The Transactional_CI.xlsm, Transactional_Asset.xlsm, and Transactional_CI_Express.xlsm spreadsheets are located at Data Management > Spreadsheet Management > Spreadsheet Type > BMC Template.

Asset sppread sheets.PNG

Normalizing and reconciling the BMC Remedy ITSM CI and Asset data 

BMC recommends that you normalize 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 > Atrium Core Console > Application Launcher > Advanced > Reconciliation. 
  2. 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.
  3. Click Start job.PNG to run the BMC Asset Management CI DATA LOAD job. 

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*