Developer forum

Forum » Integration » Data Integration Last Run Time

Data Integration Last Run Time

E-mail notifications
Casper Andersen
Reply
Posted on 23/08/2016 15:30:51

Hi

i am creating a custom source reader / provider that is reading some data from a CRM system and adding it to the AccessUser table via the User Provider already built into the Data Integration, what i need to do is to check all the users which have a special switch flipped (this works already) and if they have been updated since the last time the integrations service has run. So if a user in the CRM system has been created at 23/08/2016 @ 14:00 and the last time the integration was run was 23/08/2016 @ 13:00 then the user should be added. What is the best way to determine the last time the integration has been run ?

Regards Casper Andersen


Replies

 
Jonas Krarup Dam
Posted on 24/08/2016 10:19:14
Reply

The only way to see when a job was last run, is to parse the names of the logfiles.

 
Jonas Krarup Dam
Posted on 24/08/2016 10:23:41
Reply

I would recommend doing a two-way integration, and saving the DynamicwebUserID in your CRM, if at all possible - that way, you can simply export user that do not have a DynamicwebID.

Alternatively, you might consider simply updating all users every time - assuming this is a one-way integration (CRM-> Dynamicweb), this shouldn't cause problems with wrong information, and unless you have many hundreds of thousands of users, the performance should be acceptable.

 

You must be logged in to post in the forum