5.1.2 Performing Limited Reconciliation

Limited or filtered reconciliation is the process of limiting the number of records being reconciled based on a set filter criterion.

By default, all target system records that are added or modified after the last reconciliation run are reconciled during the current reconciliation run. You can customize this process by specifying the subset of added or modified target system records that must be reconciled. You do this by creating filters for the reconciliation module.

This connector provides a Filter Suffix attribute (a scheduled task attribute) that allows you to use any of the attributes of the target system to filter target system records. You specify a value for the Filter Suffix attribute while configuring the user reconciliation scheduled job.

Due to the limited functionality support of SAP Fieldglass target system with respect to filtering query for string data type fields, the connector only supports equalTo filter. Below is the example for the filters:

Filter Suffix Value: equalTo('__NAME__','<User Name>')

Example: equalTo('__NAME__','John')

In this example, all records whose User Name is 'John' are reconciled.