Skip to Content

Of late there have been a few discussion topics raised on how does Deltasync work in SuccessFactors.

Now Deltasync is only available for SFAPI entities – Compound Employee, FO_objects. For OData there are custom options available.

Out-of-the-box

A sender adapter polls SuccessFactors periodically (this could be hourly or daily or could be even based on a schedule you set up for the Sender Communications Channel to poll at 7 AM then 12 PM and then again towards close of day at 6 PM – totally up to requirements and business hours). This will then fetch all the changes to the Entity via the Deltasync option (which is based on the last_modified_on element).

For example, the following is the select statement from SuccessFactors for the Location Foundation Object –

SELECT address_state, end_date, externalCode, last_modified_on, name, start_date, status FROM FO_location WHERE  last_modified_on > to_datetime(‘${deltasync.maxDateFromLastRun}’)

In the Advanced tab of the Sender Communications Channel, switch on Use Additional Settings and enter the parameter deltasync.maxDateFromLastRun and a value from where you want the fetch to happen from (thanks to Heiko Konert for posting the below picture on another discussion).


Delta Sync.jpg

And that is it!


A lot of Integration aficionados (including myself) have wondered where is this data held at? It is a parameter that cannot be modifiable! And perhaps for a good reason too.

The only way you can “change” it is by creating a totally new Communications Channel for your scenario. So that tells me that the  Communications Channel name must be a part of the key here. Thanks to Heiko Konert  for diligently finding out the parameters SFSF + Party + Service + Communications Channel Name + Channel Object Id.

This is the most basic scenario supported by SuccessFactors. What if for some reason the query needs to be executed at a different time (earlier time) from the value set in deltasync.maxDateFromLastRun?

We will take a look at potential solutions in another blog.

Kevin Laevers you may find this blog useful!

Regards

Arijit

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ambrish Mishra

    Hi Arijit, Good to see that you have compiled a blog on deltasync option.

    I have a query. I am trying to replicate User as SFAPI entity and want to delta sync but the lastModified option does not work.

    WHERE lastModified > to_datetime(‘${deltasync.maxDateFromLastRun}’).

     

    The error is┬ájava.text.ParseException: Unparseable date: “2012-01-11T17:2419.000Z”. Probably the date format is incorrect? Can you please suggest

    (0) 
  2. Nitin Deshpande

    Hello Ambrish,

     

    The date format mentioned by you is wrong. Please give the you are suppose to mention the time only till seconds and must not include milliseconds. Please go through the screenshot again for more info.

    Regards,

    Nitin Deshpande

     

    (0) 

Leave a Reply