Incremental Load for Salesforce History Tables

  • 140Views
  • Last Post 03 July 2017
Admin IT posted this 01 July 2017

Incremental Replication for Salesforce Data should also support History Tables,
which don't have a LastModified/SystemModstamp Attribute, but a CreateDate (and IsDeleted) attribute.

By the nature of history tables, thes tables don't have LastModifiedDate or SystemModstamp attributes,
as a historisation only adds new records, but never modifies existing ones.

Example objects from Propertybase Extension: pba__property__c and pba__property__History

Loading the whole history daily completely causes unnecessarily high volumes, which consumes a lot of time (duration) and resources and results in high operation costs.

OR: Alternatively for a daily scheduled job a conditional could be defined for the replication object. But for a dynamically correct behaviour, it would require the support of systemdate related attribute conditions like CreateDate => getdate() - 1

Mariia Zaharova posted this 03 July 2017

Thank you for your suggestion. We will consider it.

We will contact you if any results are available.