PowerExchange for Salesforce User Guide for PowerCenter

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

Configuring a Session with a Salesforce Source

You can configure the session properties for a Salesforce source on the Mapping tab. Define the properties for each source instance in the session.

The following table describes the session properties you can configure for a Salesforce source:

Property Name	Description
SOQL Filter Condition	Enter a filter condition to filter Salesforce source records.
CDC Time Limit	Time period, in seconds, that the PowerCenter Integration Service reads changed Salesforce data. When you set the CDC Time Limit to a non-zero value, the PowerCenter Integration Service performs a full initial read of the source data and then captures changes to the Salesforce data for the time period you specify. Set the value to -1 to capture changed data for an infinite period of time. Default is 0.
Flush Interval	Interval, in seconds, at which the PowerCenter Integration Service captures changed Salesforce data. Default is 300. If you set the CDC Time Limit to a non-zero value, the PowerCenter Integration Service captures changed data from the source every 300 seconds. Otherwise, the PowerCenter Integration Service ignores this value. The minimum recommended value for Flush Interval is 60 seconds.
CDC Start Timestamp	Start date and time for the time period. The PowerCenter Integration Service extracts data that was added or modified after this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ. You can also use the $Paramstart mapping variable in a parameter file to specify the CDC start time.
CDC End Timestamp	End date and time for the time period. The PowerCenter Integration Service extracts data that was added or modified before this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ. You can also use the $Paramend mapping variable in a parameter file to specify the CDC end time.
Row Limit	The maximum number of rows the PowerCenter Integration Service processes. Default is 0. 0 indicates that there is no row limit, and the PowerCenter Integration Service processes all records.
Use queryAll	Runs a query that returns all rows, including active, archived, and deleted rows that are available in the recycle bin. Otherwise, the PowerCenter Integration Service returns only active rows. The PowerCenter Integration Service ignores this property when you configure the session to use the Enable Bulk Query option or to perform change data capture.
Use SystemModstamp for CDC	Uses the SystemModstamp as the timestamp for changed records in Salesforce. Otherwise, the PowerCenter Integration Service uses the LastModifiedDate timestamp to identify changed records in Salesforce. Default is to use the LastModifiedDate timestamp.
CDC Flush Interval Offset	The number of seconds that you want to offset the CDC flush interval. Captures real-time data that is submitted within the CDC time limit but not committed by Salesforce within the time limit.
Enable Bulk Query	Uses the Salesforce Bulk API to read Salesforce source data. By default, the PowerCenter Integration Service uses the standard Salesforce API.
Enable PK Chunking	Select to enable the primary key chunking. When you enable primary key chunking, the Bulk API splits the data set into multiple chunks based on the record ID and creates extract queries for each chunk.
PK Chunking Size	The number of records in a chunk. Default is 100000. The maximum value is 250000. Applicable only if you select Enable PK Chunking.
PK Chunking startRow ID	The row ID from where the chunking starts. By default, Salesforce applies chunking from the first record.
PK Chunking Parent Object	Specify the parent object to enable PK chunking for queries on a shared object. For example, for CaseHistory, specify Case as the parent object. PK chunking is supported for shared objects only if the parent object is supported. PK Chunking Parent Object name is case sensitive. The name must start with an uppercase letter followed by lowercase letters.