Where is the UseBulkAPI setting?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
Ashatzen
Posts: 4
Joined: Mon 04 Jul 2022 18:21

Where is the UseBulkAPI setting?

Post by Ashatzen » Wed 07 Sep 2022 23:45

According to this web page:
https://www.devart.com/ssis/docs/index. ... nation.htm...
"UseBulkApi" is a setting that is available under "Custom Properties" in the Devart Salesforce Destination object.
However, in my "Advanced Editor for Devart Salesforce Destination" dialog box, UseBulkApi does not appear. I see all the other settings, but not that one. Was this setting moved or removed recently from the latest version of dotConnect for SalesForce?

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Where is the UseBulkAPI setting?

Post by DmitryGm » Mon 03 Oct 2022 17:38

You are probably using dotConnect for Salesforce. It contains SSIS Components for Salesforce.

But this documentation (https://www.devart.com/ssis/docs/) is related to a different product: SSIS Data Flow Components for Salesforce.
https://www.devart.com/ssis/salesforce/
It has similar functionality but is slightly different.

Note that dotConnect for Salesforce always uses Bulk API.

Ashatzen
Posts: 4
Joined: Mon 04 Jul 2022 18:21

Re: Where is the UseBulkAPI setting?

Post by Ashatzen » Mon 03 Oct 2022 17:51

Thank you for your reply. Do I need to purchase SSIS Data Flow Components as an add-on to dotConnect? Or does SSIS Data Flow Components replace dotConnect?

Thanks again,
Amy

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: Where is the UseBulkAPI setting?

Post by DmitryGm » Tue 04 Oct 2022 10:30

dotConnect for Salesforce includes SSIS Data Flow Components as an additional.

"SSIS Data Flow Components for Salesforce" - another product.
https://www.devart.com/ssis/salesforce/
It doesn't replace dotConnect for Salesforce.
"SSIS Data Flow Components for Salesforce" applies to SSIS only and doesn't have dotConnect functionality.
UseBulkApi option is available in "SSIS Data Flow Components for Salesforce".

dotConnect for Salesforce always uses Bulk API and doesn't have UseBulkApi option.
To have UseBulkApi option you should have "SSIS Data Flow Components for Salesforce" product.
https://www.devart.com/ssis/salesforce/

Post Reply