Page 1 of 1

Where is the UseBulkAPI setting?

Posted: Wed 07 Sep 2022 23:45
by Ashatzen
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?

Re: Where is the UseBulkAPI setting?

Posted: Mon 03 Oct 2022 17:38
by DmitryGm
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.

Re: Where is the UseBulkAPI setting?

Posted: Mon 03 Oct 2022 17:51
by Ashatzen
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

Re: Where is the UseBulkAPI setting?

Posted: Tue 04 Oct 2022 10:30
by DmitryGm
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/