---
title: Reconcile Data Stores
description: A central feature of IDM is reconciliation — comparing the contents of two data stores and deciding what to do, depending on the differences.
component: pingidm
version: 7.2
page_id: pingidm:getting-started:data-files
canonical_url: https://docs.pingidentity.com/pingidm/7.5/getting-started/data-files.html
llms_txt: https://docs.pingidentity.com/pingidm/llms.txt
docs_for_agents: https://developer.pingidentity.com/build-with-ai/docs-for-agents.md
superseded_by: https://docs.pingidentity.com/pingidm/7.5/getting-started/data-files.html
---

# Reconcile Data Stores

A central feature of IDM is reconciliation — comparing the contents of two data stores and deciding what to do, depending on the differences.

This scenario is based on two data files:

* `hr.csv` , which represents the Human Resources data store

* `engineering.csv` , which represents the Engineering data store

Reconciliation modifies the Engineering data store by adding the newly hired Jane Sanchez. As suggested by the following illustration, it will also address detailed differences between Jane's Human Resources account and the Engineering data store.

![Reconciliation can manage different categories of data.](_images/gsg-differences.png)Figure 1. Data Stores Can Have Different Categories of Data

This sample includes configuration files that map detailed information from the Human Resources data store to the Engineering data store. For example, the configuration maps the `firstName` entry in Human Resources to the `firstname` entry in Engineering.

|   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| - | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|   | Mapping between data stores may require additional configuration. You should find two `provisioner.openicf-*.json` files in the `/path/to/openidm/samples/getting-started/conf` subdirectory. The provisioner files configure connections to external resources, such as Active Directory, ForgeRock Directory Services (DS) or even the `engineering.csv` and `hr.csv` files used in this guide. For more information, see [Overview](../connector-reference/preface.html). |

In the admin UI, you can see how the different categories are reconciled for user Jane Sanchez. Log in to the admin UI at `https://localhost:8443/admin`. The default username is `openidm-admin` and default password is `openidm-admin`.

Click Configure > Mappings > `HumanResources_Engineering` > Edit.

In the *Sample source preview* text box, enter `Sanchez`. You should see a drop-down entry for Jane Sanchez that you can select. You should now see how IDM would reconcile Jane Sanchez's entry from the (source) Human Resources data store into the (target) Engineering data store.

![Reconciling accounts from different data stores.](_images/gsg-recon-details.png)Figure 2. Reconciling Differences for an Account

Scroll back up the same page. Click Reconcile.

When you reconcile the two data stores, IDM makes the change to the Engineering data store.

The [mapping](../synchronization-guide/mappings.html) for this example is configured in the `sync.json` file, in the `/path/to/openidm/samples/getting-started/conf` directory.