During a data migration project, it is possible that the data that is leaving the target system and data entering the source system is not in agreement.
This can be due to a variety of factors like.
- Missing records
- Missing values
- Incorrect values
- Duplicated records
These issues if left unchecked can severely damage the overall data quality. MDO data reconciliation work bench helps business monitor the data that is being transferred from source to target system during data migration projects. MDO reconciliation reports helps business ensure that data that leaving the source system and being migrated into the target system are in agreement.
To configure a Reconciliation workbench, follow below steps:
- Login to MDO with login credentials
- Click on setting icon located on top right section.
- Click on Advanced
- Click Reconciliation
- Click “Add New Report” button, system will open the log view page which have various columns which are discussed below:
|Description||User can provide description for the report in this section.|
|Source Module||This list gives the list of all modules configured in MDO. Select the module which contains the data pulled in from the source system in this field.|
|Target Module||This list gives the list of all modules configured in MDO. Select the module which contains the data to be transferred to the target system in this field.|
- Click on “Next” to move to the next section of the process.
- This section shows the list of all the fields in both source and target module. Map the fields from source module to their corresponding fields in target system.
Below is the list of actions you can perform in this section.
|Auto Map by Desc||Using this option, MDO automatically maps together fields in source and target module having similar description saving time & efforts and helps in reducing the risk of error in mapping.|
|Add Mapping||Using this option user can manually map fields in source module with their corresponding fields in target module.|
|Show selected||This option highlights the list of all the fields that are mapped together.
- Click on “Finish” to save the report.
- Click on “Activate” to activate the report.
- Go to “Run” In this section user’s can run reconciliation reports on datasets.
- Click on “Add New” to schedule reconciliation run.
Below is the list of options a user can perform in this section.
|Run ID||Unique ID for every run. Run ID is auto generated by the system.|
|Description||User can provide description for the run in this section.|
|Reconciliation Rule||This column shows the list of all configured reconciliation reports. Users can select the report they want to run the rule on.|
Once the above columns are filled a row gets automatically added to the “Module and Variant” section.
Below is the list of actions user can perform in this section.
|Action||Click on “Remove” button to remove a reconciliation variant from the run.|
|Module ID||This column contains the module id of the source module.|
|Module name.||This column contains the module name of the source module for the selected reconciliation report.|
|Variant detail.||This column allows users to select the data set on which the report is to be run.|
|All data||This option schedules a reconciliation run for all the records in the source module.|
|Custom Variant||This option allows users to define a data set in which the rule is to be run.|
Below is the list of actions a user can perform in this section.
|Search fields||This column contains the list of all the fields in the source module. User can select the field based on which reconciliation rule criteria is to be defined.|
|Operator||This list contains two values.
Equals – This option checks whether the value for the selected field under the “Search Fields” section is equal to the value entered in the “Value” section.
Not Equals – This option checks whether the value for the selected field under the “Search Fields” section is not equal to the value entered in the “Value” section.
|Value||This column allows users to specify the value for the for the selected field under the “Search Fields” section for which the rule is to be run/not run|
|Add||This option allows users to add the criteria/define new criteria|
- Click on ‘‘Save’’ to save the rule.
- Click on “Run” to run the reconciliation report.