Data reconciliation allows to check the integrity of the loaded data. A successful data reconciliation process should only specify whether or not the data is correct. It will not indicate why the data is not correct. Whereas Data Reconciliation process answers “what” part of the question, not “why” part of the question.

PROLIM Data Reconciliation helps to identifies misalliances across any database management system and provides drill down reports on the same. The Reconciliation Framework comprises a set of reconciliation jobs that will allow tracing of records from the source systems to the target systems.

The objective of the reconciliation is to check if the records that were sent from the source systems were either received by the target systems or identified in the error logs.

Types of Data Reconciliations

Business Reconciliation

Patterned done to verify that the business objects at the target systems are same as the business objects at the source.

Technical Reconciliation

is a sequence of checks on the state of an specific record as it is administered through one system to another system.

Features of the Data Reconciliation includes:

  • It allows Rule based reconciliation all kinds of any number of business modules
  • Quick Identification of discrepancies in data
  • Reconciliations process can be performed steadily and regularly
  • Data Reconciliation process is formalized and automated
  • Quick Transparency and visibility of reconciliation processes and the results thereof.
  • Quick and smart analyses impact of  inaccurate data on Business
  • User friendly interface to execute the process