Salesforce.com object requirements for delta extractions

To use the Pack for Salesforce.com to extract updated or deleted data, you need to add a custom object to your Salesforce.com organization that includes the fields required by the Pack.

To support delta extraction (getUpdated or getDeleted operations), create a custom object called DataStage in your Salesforce.com organization. Include the following fields in the DataStage object:

extractId

This field identifies a particular job that performs a delta extraction. The Pack for Salesforce.com uses this field to track the last time this ID performed a delta extraction. The time of the last delta extraction determines which data the query returns to a particular ID.

For example, a Salesforce.com organization might have an AccountManager user who runs an extraction job weekly and a SalesRep user who runs another job daily. Both jobs might extract data from the same Salesforce object. Setting up a unique extractId for each job lets the Pack for Salesforce.com return the data that has changed in the last week to the AccountManager user, and the data that has changed in the last day to the SalesRep.

The extractId can be any text string. The field is limited to 80 characters. You enter the extractId at design time. Optionally, you can save the extractId as a job parameter. This field has the type of Text. This field is Unique Case Insensitive, and it is an External ID field.

lastextracttime

This field stores the date and time when a user, identified by a unique extractId, last ran a particular delta extraction job. This field has the type of datetime.

object

This field stores the name of the Salesforce object for the delta extraction. It has the type of Text Field with 40 characters