Salesforce
- Juliane Wetzel
INFO
Prerequisites
INFO
Configuring Salesforce as a Connection
Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
Select "Salesforce" from the drop-down and confirm with "Next". The type is displayed in the drop-down.
Select the web service protocol to be used from the drop-down.
Enter the host address and the port, where the web service is running on.
Enter the root path.
To authenticate, click on “Authorize Datameer to retrieve data”. You are then taken to the http://salesforce.com portal to generate an OAuth access token for Datameer. The OAuth code is automatically transferred to the appropriate field.
Confirm with “Next”.
If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.
Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Salesforce connection is finished.
Importing Data with the Salesforce Connector
Applicable Custom Properties
INFO
You can use custom properties to modify the importing process to your needs.
| Custom Property | Example Value | Default Value | Description |
|---|---|---|---|
| datameer.plugin-webservice.read-timeout.ms | 120000 (~2 minutes) | 120000 |
|
| datameer.salesforce.maxrecords-per-result-request | 600000 | determined by the Salesforce API endpoint |
|
| datameer.salesforce.max-parallel-result-request | 2 | 1 |
|
Importing Data with the Salesforce Connector
Click the + (plus) button and select Import Job or right-click in the browser and select Create new > Import Job.
Click Select Connector, choose the Salesforce connector, and click Next.
Enter a search Salesforce Query (SOQL) and click Next.
Review the defined fields and click Next.
Review the schedule and advanced properties for the job and click Next.
Create a description for the import job and click Save.