summary
This is a help page for ETL Configuration of Data Destination of records managed in Salesforce, such as Opportunities, Leads, Business Partners, and Custom Objects.
constraints
Setting items
STEP1 Basic settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Salesforce Connection Configuration | Yes | - | Select the previously registered Salesforce Connection Configuration that has the necessary permissions for this ETL Configuration. |
| API Version | Yes | 54.0 | Enter the version of the Salesforce API. |
| object | Yes | - | Enter the name of the object containing the data you wish to transfer. You can also load a list from the Load Object List. |
| Object Acquisition Method | Yes | - | Select one of the following options: transfer****all object items or write a query (SOQL) and transfer. |
| query | Yes | - | This is displayed when you write a query (SOQL) and select transfer. Write your query in SOQL (Salesforce Object Query Language) format. For information on how to create a SOQL, see How to Create a SOQL from the Developer Console. |
| Extraction of deleted and archived records | Yes | non-extractive | Select whether or not to include records that have been deleted or archived in Salesforce in the extraction. When "Extract" is selected, records that have been deleted or archived are also included in the extraction. |
| type conversion mode | Yes | Use type guess results | Select the type conversion mode. |