Skip to main content

Salesforce continuous incremental replication

Use Salesforce Reader in Incremental or Automated mode to replicate Salesforce data to a target.

To switch from initial load to continuous incremental replication:

  1. Once initial load has completed, query the latest SystemModstamp value from the migrated table. If an object does not have SystemModstamp, use the latest LastModifiedTimestamp instead.

  2. Ensure the SystemModstamp is in UTC and formatted as YYYY-MM-DDThh:mm:ss.sssZ.

  3. Configure the new Salesforce Reader in Incremental Load mode, setting the startTimestamp to the value from step 1

  4. Deploy and start the incremental replication application.