Devart Salesforce Source

Devart Salesforce Source extracts data from Salesforce objects. It has the following custom properties:

Property

Description

BatchSize

The number of records to fetch in one batch. Default value is 1000.

BulkQuery

Determines whether to use Bulk API for loading data to query large data sets and reduce the number of API requests. Default value is False, which means that SOAP API is used.

Note that when Bulk API is used, the OptimizeQuery property is ignored.

Bulk API does not support the following features:

•

COUNT

•

ROLLUP

•

SUM

•	GROUP BY CUBE

•

OFFSET

•	Nested queries

•	Relationship fields

•	Compound fields

•	Deleted records

If anything from this list is used in a query, (for example, you query multiple entities or an Address field, which is a compound field, SOAP API is used for the query.

IncludeDeleted

Determines whether to query records with IsDeleted = True. Default value is False.

OptimizeQuery

Determines whether to use optimizations for retrieving large amount of data. If True, provider tries to apply ORDER BY and LIMIT to get parts of result set step by step to avoid possible timeouts. Default value is False.

SelectStatement

An SQL SELECT statement that queries Salesforce objects.