Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add custom domain limitation

...

  • SOQL: This configuration allows to use of a custom SOQL (Salesforce Object Query Language) to query and filter data. With SOQL, you can retrieve the data from a single object or multiple objects that are related to each other. You can pick specific columns and filter or sort the output with your own conditional statement. As a limitation, our data connector doesn’t support SOQL syntax such as count() FROM Object and SELECT * from salesforceObject.
  • Bulk API limits: Bulk API offers faster ingestion but also has a limitation of 10,000 batch allocations within a 24-hour period. If your target is large, your entire available batch allocation might be consumed, causing your job to fail eventually. If you try to use the Bulk API, and the result is the ingestion of all records, consider enabling the synchronous transfer only option and using REST API. The use of REST API avoids the batch allocation limitation but might be slower.

  • OAuth: OAuth doesn't support custom domains. Thus if you are using a custom domain, please use credential as the authentication method.

Support

SFDC import supports these authentication types:

...

Excerpt

These instructions guide you to locate the client ID and client secret that is necessary to authenticate using credentials.

Info

This is the guide for Lightning Experience UI.

  1. Go to Setup > Apps > App Manager.

  2. Select New Connected App.

  3. Set some values and check Enable OAuth Settings. Then, grant OAuth permission scope.Image Added
  4. Image RemovedClick Save. Activation can take up to 10 minutes.

  5. Go to Setup > Apps > App Manager.
  6. Locate the connected app, click , and then select View.
  7. Write down or copy your Consumer Key (client_id) and Consumer Secret (client_secret).

...