Connections > Salesforce connection > Salesforce source properties
  

Salesforce source properties

You can use a Salesforce object as a source in a data loader task.
The following table describes the Salesforce source properties:
Property
Description
Connection
Name of the source connection.
Select a source connection or create a new connection.
Row Limit
The maximum number of rows the agent processes. Default is 0. The default value indicates that there is no row limit, and the agent 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 agent returns active rows.
The Use queryAll property for Bulk API is available for Salesforce API version 39.0 and later. The agent ignores this property when you configure the session to perform change data capture.
Enable Bulk Query
Uses the Salesforce Bulk API to read Salesforce source data.
By default, the agent uses the standard Salesforce API.
Enable Bulk 2.0 Query
Uses the Salesforce Bulk API 2.0 to read large amount of data from Salesforce.

Rules and guidelines for primary key fields and watermark fields

When you read data from Salesforce, the primary key fields and watermark fields are detected. You can also manually define the primary key fields and watermark fields. The default value is Automatically detect from source.