none
Salesforce Data connector and BULK API

    Question

  • Does the Salesforce connector in Azure Data Factory use the Bulk API or is there anyway to do so?

    I am only getting about 3-4 Mbps going from Salesforce to Azure SQL DB (East US).  I have tried using the query method (which is our preferred method because we do delta loads) and the Object method, but both a still very slow.

    Just looking for ways to speed this up.

    Wednesday, August 8, 2018 3:08 PM

All replies

  • Hi,

    According to this post: ADF tries to use BULK API as much as possible, but may fall back to REST API in certain constraint.

    To improve the performance, you could use parallel copy and staged copy. Hope this link gives you right direction.

    Thanks.


    Thursday, August 9, 2018 1:13 AM
  • What conditions does it use to specify which API is used? It would be helpful if we were able to determine if the Bulk API is used or not.
    Thursday, August 9, 2018 6:47 PM