API used in Salesforce Connector available in Azure Data Factoryv2


  • I am trying to use the Salesforce connector available in ADFv2 to integrate & ingest data from Salesforce. However, I am not able to know the underlying API mechanism (REST vs BULK API) the connector uses. Unlike the SSIS connectors (available) which provides the capability to force using BULK API, the Azure Salesforce connector doesn't provide such a setting.

    Does anyone know how the Azure Salesforce connector works and which API it uses internally?

    Sunday, July 29, 2018 9:10 AM


All replies

  • Hi,

    You can use REST API to work with the Salesforce connector, click this link for more information.


    Monday, July 30, 2018 4:42 AM
  • Generally, ADF tries to use BULK API as much as possible, but may fall back to REST API in certain constraint.
    Monday, July 30, 2018 6:21 AM
  • Hi,

    Thanks for your answer. I would like to understand couple of things

    1. What are the constraints in which ADF Salesforce connector falls back to REST API
    2. Is the behaviour of the Salesforce connector documented? If yes, can you kindly provide the link which provides this information.

    Tuesday, July 31, 2018 7:27 PM