The PowerCenter Integration Service can capture changed data from a Salesforce object that is replicateable and contains CreatedDate and LastModifiedDate fields. If you configure a session to capture changed data from a Salesforce object that is not replicateable or does not contain CreatedDate and LastModifiedDate fields, the session fails. For more information about replicateable objects, see the Salesforce documentation.

When the PowerCenter Integration Service captures deleted data, it returns only the ID of the deleted record and sets the row notification to delete.

Use one of the following methods to capture changed data:

By default, change data capture is disabled. To enable a particular method, specify the required attributes in the session properties. Configure the attributes for one CDC method. You should not define two different CDC methods in one session.

You can configure the LastModifiedDate or SystemModstamp field as the timestamp that determines when a Salesforce record was last modified.

Configuring a session to perform change data capture overrides the Use queryAll session property.