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.
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
hr.csv files used in this guide. For more information, see Overview.
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
Select 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.
Scroll back up the same page. Select Reconcile.
When you reconcile the two data stores, IDM makes the change to the Engineering data store.
The mapping for this example is configured in the
sync.json file, in the