To call the Devart Salesforce Source Editor, double-click the Devart Salesforce Source data flow object.

The Devart Salesforce Source Editor dialog box is displayed:

This dialog box has the following components:

• The Salesforce Objects area allows you to view the existing Salesforce tables, expand their nodes to view columns, and drag Salesforce objects from this area to the Query area.

  • The Refresh Objects button updates the list of Salesforce objects.
• The Variables area allows you to view the system and user variables grouped in the corresponding nodes, and if necessary, drag them to the Query area.

• The Query area is intended for creating a query to be executed against the Salesforce database. You can drag the required Salesforce objects and variables to this area, or write the query yourself.

  • The Preview Data button calls the Preview Data window that displays the query execution result.
• The Properties area displays properties of the currently selected Salesforce object, column or variable.
• The Salesforce Connection drop-down list is intended for selecting the corresponding Devart Salesforce Connection Manager.
• The Batch Size field defines the number of rows loaded by the provider in one roundtrip. This value is defined in the provider's connection string. The default value is 500.
• The Include Deleted Records check-box defines whether the result should contain all records, including the deleted ones.