function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AnzarAnzar 

incremental data load using Apex Data Loader from Sf.com to Oracle or vice-versa

Hi,

 

How we can configure process-config.xml and database-conf.xml file to fetch/upload INCREMENTAL data from Salesforce.com to Oracle table and vice-versa using Apex Data Loader.

 

I can see the 2 below line code in sample database-conf.xml file for incremental data load.

WHERE LAST_UPDATED > @process.lastRunDate@

 

and

 

<entry key="process.lastRunDate" value="java.sql.Timestamp"/>

 

I can also see the one line code inside process-conf.xml. But for both mentioned configuration, details are not available in document.

 

But I am not able understand how @process.lastRunDate@ will be replaced with actual value.

 

I can also see the below line code in process-config.xml, when this line of code is required. Is this required for incremental dataload?

 

 <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>

 

Can anybody help, please?

 

Thanks

John s.John s.
Hello Anzar,

Maybe this link will help you: http://www.codeulike.com/2015/01/automating-salesforce-data-imports-with.html

best regards john s.