Devart Salesforce Destination

Devart Salesforce Destination component loads data into Salesforce objects. It has the following custom properties:

Property

Description

Action

A DML operation to apply to the target object. Default value is Insert. The following values are supported:

•	Insert - This is the most common operation.

•

Update - Devart Salesforce Destination component in the Update mode enables updating data in a data source. Peculiarity of this action consists in the fact, that performing it requires using primary key values of the target table (the Id value for cloud sources). Thus, when performing an update, you must know and specify the primary key values of the target table to update a record.

•	Delete - Devart Salesforce Destination component in the Delete mode enables deleting data from a data source. As well as for the update operation, you must know and specify the primary key values of the target table to delete a record.

•

Upsert - When executing an upsert, records are inserted if they do not exist in the Salesforce object; in case records do exist, then data update is performed. This action is based on an External ID field.

In order to use the Upsert option, the Salesforce object must have an External ID field, and the local storage must contain the corresponding unique column (usually this is a primary key in the database table). When configuring the component, you must map this unique column to the External ID field in the target Salesforce object.

•	HardDelete - Completely deletes data rows without the possibility to restore them. While the Delete operation only sets the IsDeleted property to True for deleted records, HardDelete actually deletes them.

AssignmentRuleId

The id of a Salesforce assignment rule that will be used when inserting data to Salesforce via this destination. If set, this rule is applied regardless of the connection's Use Assignment Rules parameter.

BatchSize

The maximal number of records to send as one batch to the server when performing an Insert operation. Not supported for some Salesforce objects. Default value is 5000. Actually the maximal volume of data to load in one batch is limited by two properties - BatchSize and BufferSize. Of these two limitations that one takes effect, the value of which is reached first.

BufferSize

The maximal size of a data packet sent to the server. Default value is 10485760. Actually the maximal volume of data to load in one batch is limited by two properties - BatchSize and BufferSize. Of these two limitations that one takes effect, the value of which is reached first.

ObjectName

The name of an Salesforce object to load data into.

ParallelBatchProcessing

Determines, whether the batches associated with a bulk load operation are processed by Salesforce in parallel or one-by-one.

UseBulkApi

Determines, whether to use Salesforce Bulk API or SOAP API.