LDAP Connector

Back Next

Capturing changed data in active directory

The can capture changed records from an LDAP source object. Change data capture (CDC) helps you identify and process the changed data. You can configure CDC in the source advance properties to capture changes while reading data from Active Directory for a specified time interval or from the last extraction point.

Active Directory uses the uSNChanged attribute to store the entry and the details of the changes made to the entry. You can track the changes made to the contents of a directory based on the update sequence number (USN) assigned by the local server after the last change to the object.

The determines the change type based on the values for uSNCreated, uSNChanged, isDeleted, whenCreated, and whenChanged attributes of an entry. Every entry in Active Directory contains the uSNCreated, uSNChanged, whenCreated, and whenChanged values. For an updated entry, the uSNChanged value increments to indicate the updated entry in the directory server. For a deleted entry, the isDeleted value sets to True to indicate the deleted entry from the directory server.

When you configure CDC, the captures the changes that are present under the specified base DN and extracts the changed data. The stores the change number for the last read entry in the CDC file.

You can apply a filter query to capture changed data for inserted or updated records fetched from LDAP directory server. You cannot use the query to capture changes for deleted records because the fetches only the RDN and the parent DN records for the deleted records.

Configuring changed data capture from the last extraction point

To fetch changes from the last extraction point, enable CDC and set the absolute path of the file that stores the change number for the last read changed entry.

By default, the fetches the changed data based on the last read uSNChanged value:

If the CDC file does not exist, or if the CDC file has an uSNChanged value as 0, the fetches all the changes in the base DN until the latest uSNChanged value and then updates the CDC file with the latest uSNChanged value.

If the CDC file has a uSNChanged value greater than 0, the fetches the changes that occur after the uSNChanged value read from the file. The then updates the CDC file with the latest uSNChanged value.

Configuring changed data capture for a specified time interval

To fetch changes for a specified time interval, you can set the following values in the advanced source properties:

Specify the CDC along with the start time and end time in the advanced source properties. The reads the CDC file from the uSNChanged value and fetches the changes that occur after the uSNChanged value read from the file, but according to the time interval you specify. The also updates the CDC file with the latest uSNChanged value.

When you provide only the start time, the fetches the changes from the specified start time to the latest changes.

If you provide only the end time, the fetches the changes from the beginning to the specified end time.

Reset change data capture

You can reset CDC to fetch the changes from the beginning. The ignores the uSNChanged value in the CDC file. The then updates the CDC file with the last uSNChanged value.

LDAP sources

CDC configuration scenarios in active directory

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal