SalesforceSOQL Extract

This extract type allows the definition of a generic SOQL query. A Salesforce Connector License and a Connection to Salesforce is required for this extract type.

Salesforce uses the proprietary query language SOQL (Salesforce Object Query Language) for data retrieval. It has similarities to the SELECT commands of SQL (Structured Query Language), but it is not compatible with ANSI-SQL.

Notes

  • Comments are not supported in SOQL queries.
  • If the SOQL extract does not return any records, the field structure will be used for the row headers and an info message "No records returned by query, using field structure for headers..." will be displayed in the monitor. If the field structure is undefined or incomplete, an error message "No records returned by query and the field structure is empty or incomplete!" will be displayed.

For more information on SOQL, see SOQL SELECT Syntax.

Settings

Connection A connection of type Salesforce
SOQL query With an arbitrary SOQL Select Statement, data can be read from the database. All options of the SOQL syntax (e.g. for filtering, sorting, and joining) can be used.

Example: SELECT Name, Department, Birthdate, Account.Name, Account.Phone FROM Contact
Field structure The resulting field structure of the Salesforce SOQL extract can be generated with the option Update Field Structure. The number and the (original) name of all columns are displayed. For each column, you can optionally define:
  • Field Name: an alternative name to the original name of the column. The field will be referenced with this name for the rest of the Jedox Integrator process.
  • Default: defines a first basic mapping. A plank, several blanks, or a null value will be mapped to this default value.
Use bulk API
 		Use the Bulk API provided by Salesforce for processing large numbers of records asynchronously. If not set, the (classic) REST API from Salesforce will be used; this API may result in better performance for small and medium data volumes.
Use caching Memory, disk, or none (default). See Caching in Extracts for more information.

Updated January 29, 2024