I work as a Developer in Cloud Platform Integration and work predominantly in building and maintaining CPI adapters. Adapters are used to integrate systems with different platform. I specialize in CPI Successfactors Adapter, which is used to integrate systems with Successfactors.

Why This Article:

We found users of CPI Successafctors adapter finding it difficult to understand how to fetch delta records from Successafctors system.

So i thought it would be good if i write a step by step instructions explaining how to do the same.

What to expect in this article:

In this article we will explain how to configure CPI successafctors Adapter to fetch Delta records from Successfactors System.

What are Delta Records:

Delta in mathematical term mean Change or Difference.

So a Delta on database records equates to records that have changes.

How does it work:

When a Query operation is performed with Delta, CPI Successfactors adapter fetches all the records in the first run and in the second run it fetches only those records that are modified after the first run.

In this example we are fetching delta records from Successfactors Soap adapter and the records are sent to SFTP server.

2. Model Delta Query operation

Enter Successfactors connection details and click on Select.

Model operation requires you to connect to the Successfactors system. Enter the Successfactors connection details and click on Connect.

In the Entity Selection dialog, Select the table that needs to be queried. In our scenario we are querying User table.

Select the Columns that needs to be fetched from User table.

Select the Filter tab and under “Filter by” column select the filed from the User table, using which Delta operation will be performed. The filed that is selected should be of DateTime type, no other filed is eligible for Delta operation.

In our example we have selected “Lastmodified” column, whose value will be used to determine the Delta operation.

Under “Operator” column select “>”

Under “Input Type” column select “Delta Sync”, the value column will be auto populated with “maxDateFromLastRun”.