Enabling Incremental Reconciliation from Trusted Source IDCS to Oracle Identity Governance

Oracle Cloud hovering above a laptop

Oracle Identity Governance (OIG) 12c uses connectors to reconcile user data from trusted source applications like Oracle Identity Cloud Service (IDCS). By default, OIG will perform a full reconciliation and sync all users from the source application.

What is Incremental Reconciliation?

The incremental reconciliation is a concept in IDM demography were during the reconciliation of data from a source, only the delta is picked by OIM connector which has been changed after last reconciliation timestamp. So, let’s say that if the reconciliation from IDCS to OIM has been triggered on 10th Oct,2022 at 2:00pm PST and next scheduled run of reconciliation is on 14th Oct,2022 at 2:00 pm PST, then, the data which has been modified/changed after 2:00pm PST 10th Oct,2022 will be picked up by the connector and will be reconciled in OIM. Therefore, in this article, you will know on how to enable this functionality of delta reconciliation from IDCS to OIM.

This article explains how to configure OIG to perform incremental reconciliation from IDCS, syncing only users that have changed since the last reconciliation run. We will show you how to enable this functionality of delta reconciliation from IDCS to OIM.

Pre-Requisites

The OIG 12c – IDCS connector should be installed in respective OIM instance as Trusted Source through AoB/Application Onboarding approach. Refer then below screenshot.

User Reconciliation in OIG 12c Step 1

The Scheduled Task named as: IDCSTrusted REST Application Trusted User Reconciliation should be present in respective environment of OIG.  

User Reconciliation in OIG 12c Step 2

Enabling Incremental Reconciliation for IDCS Trusted Source in OIG

  1. Login to Identity – Self Service Console using XELSYSADM user.

User Reconciliation in OIG 12c Step 3

  1. Navigate to Manage Tab. Click on Manage.

User Reconciliation in OIG 12c Step 4

  1. You will get below page.

User Reconciliation in OIG 12c Step 5

  1. Click on Applications tile.

User Reconciliation in OIG 12c Step 6

  1. Below page will be rendered.

User Reconciliation in OIG 12c Step 7

  1. Perform the blank search on this page by clicking on “Search” button.

User Reconciliation in OIG 12c Step 8

  1. Results will be displayed as shown in below screenshot. Note that search result will differ as per your OIG environment and list of connectors you have installed through AoB approach.

User Reconciliation in OIG 12c Step 9

  1. Look for Generic REST connector installation which is configured as Trusted source for IDCS.

User Reconciliation in OIG 12c Step 10

  1. Select the Connector and click on Edit.

User Reconciliation in OIG 12c Step 11

  1. Below page will be rendered.

User Reconciliation in OIG 12c Step 12

  1. Scroll down till you see the Advanced Settings section.

User Reconciliation in OIG 12c Step 13

  1. Expand the Advanced Settings section.

User Reconciliation in OIG 12c Step 14

  1. Below page will be rendered.

User Reconciliation in OIG 12c Step 15

  1. Search for “relURLs” configuration.

User Reconciliation in OIG 12c Step 16

  1. The existing relURLs configuration will be as follows.

Existing relURLs configuration

“__ACCOUNT__.SEARCHOP=/admin/v1/Users?$(Filter Suffix)$&attributes=name.givenName,name.familyName,displayName,userName,employeeNumber,userType,organization,id,active,emails[primary+eq+%22true%22].value&count=200”

 

  1. Change the relURLs to below value

New relURLs configuration

“__ACCOUNT__.SEARCHOP=/admin/v1/Users?$(Filter Suffix)$&attributes=name.givenName,name.familyName,displayName,userName,employeeNumber,userType,organization,id,active,emails[primary+eq+%22true%22].value,meta.lastModified&count=200”

  1. Update the configuration in relURLs parameter of Advanced Settings.

User Reconciliation in OIG 12c Step 17

  1. Once updated, scroll up and click on Apply.

User Reconciliation in OIG 12c Step 18

  1. You will get below message.

User Reconciliation in OIG 12c Step 19

  1. Then, login to OIG – System Admin Console.

User Reconciliation in OIG 12c Step 20

  1. Click on Scheduler.

User Reconciliation in OIG 12c Step 21

  1. Below popup will be rendered.

User Reconciliation in OIG 12c Step 22

  1. Search for Scheduler named using search string as: *IDCS*.

User Reconciliation in OIG 12c Step 23

  1. Click on Search button.

User Reconciliation in OIG 12c Step 24

  1. You will get below results.

User Reconciliation in OIG 12c Step 25

  1. Click on Scheduler named as : IDCSTrusted REST Application Trusted User Reconciliation.

User Reconciliation in OIG 12c Step 26

  1. The scheduled task will be opened.

User Reconciliation in OIG 12c Step 27

  1. Enter the Incremental Recon Attribute as: lastModified

User Reconciliation in OIG 12c Step 28

  1. Apply the changes.

User Reconciliation in OIG 12c Step 29

  1. Apply the changes.

User Reconciliation in OIG 12c Step 30

  1. The changes will be applied successfully and Incremental Recon Attribute will be updated successfully in scheduled task.

User Reconciliation in OIG 12c Step 31

Incremental reconciliation is an important feature to optimize reconciliation performance. This article walked through the steps to enable incremental reconciliation from IDCS to OIG 12c, configuring the Generic REST connector and reconciliation scheduled task. With incremental reconciliation enabled, OIG will pick up only modified user data from IDCS, greatly improving reconciliation efficiency.

Author: Rohit Wekhande, IDMWORKS, Sr AIM Consultant