Search

PowerExchange for Salesforce User Guide

PowerExchange for Salesforce User Guide

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

Back Next

Advanced Properties

Advanced Properties

Use the advanced properties to specify the data object read operation properties to read data from Salesforce objects.

The following table describes the advanced properties that you configure in the data object read operation:

Property	Description
SOQL Filter Condition	Filters Salesforce source records.
CDC Time Limit	Time period, in seconds, that the Data Integration Service reads changed Salesforce data. When you set the CDC Time Limit to a non-zero value, the Data 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. Default is 0.
Flush Interval	Interval, in seconds, at which the Data Integration Service captures changed Salesforce data. Default is 300. If you set the CDC Time Limit to a non-zero value, the agent captures changed data from the source every 300 seconds. Otherwise, the Data Integration Service ignores this value.
CDC Start Timestamp	Start date and time for the time period. The Data Integration Service extracts data added or modified after this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ.
CDC End Timestamp	End date and time for the time period. The Data Integration Service extracts data added or modified before this time. Must be in the format YYYY-MM-DDTHH:MI:SS.SSSZ.
Row Limit	Specifies the maximum number of rows the Data Integration Service processes. Default is 0, which indicates that the Data Integration Services processes all records.
Use QueryAll	Runs a query that returns all rows, which includes active, archived, and deleted rows. Otherwise, the Data Integration Service returns active rows. The Use QueryAll property for Bulk API is available for Salesforce API version 39.0 and later.
Use SystemModstamp for CDC	Uses the SystemModstamp as the time stamp for changed records in Salesforce. Otherwise, the Data Integration Service uses the LastModifiedDate time stamp to identify changed records in Salesforce. Default is to use the LastModifiedDate time stamp.
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	Enable this feature to use the Salesforce Bulk API to read batch files containing large amounts of data. By default, the Data Integration Service uses the SOAP Salesforce API.
Enable PK Chunking	Use to extract from Salesforce sources when you use the Bulk API. Enables primary key chunking to optimize performance while replicating data from large data sets. Salesforce splits the data set into a number of chunks based on the record ID, creates multiple queries to extract data, and combines the result. Salesforce supports primary key chunking for custom objects and certain standard objects. For more information about supported objects for primary key chunking, see the Salesforce documentation.
PK Chunking Size	The number of records in a chunk. Default is 100,000. The maximum value is 250,000. Applicable if you select Enable PK Chunking.
PK Chunking startRow ID	The record ID from which you want to chunk the data set. By default Salesforce applies chunking from the first record. Applicable if you select Enable PK Chunking.
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. You can perform PK chunking on shared objects only if PowerExchange for Salesforce supports PK chunking on the parent objects. PK Chunking Parent Object name is case sensitive. The name must start with an uppercase letter followed by lowercase letters.

Output Properties of the Data Object Read Operation

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.