Export from Salesforce and bulk Load protocol

Posted by Jan Zaruba on 27-Feb-2018 05:33

Hi there,
I have this scenario:

  • Connect64XE for ODBC driver is set up to use bulk load (parameters EnableBulkLoad=1, BulkLoadBatchSize=X).
  • The data source system is Salesforce.
  • The application exports/queries data from Salesforce.

Question: What protocol is used to export data? Is it the specific Salesforce Bulk API?

The documentation specifies the bulk load import uses Salesforce Bulk API. However the documentation is not clear whether for export is used the same protocol.

Regards,

Jan

DataDirect Connect - Forum
Posted by Avadhoot Kulkarni on 27-Feb-2018 06:32

Hi Jan,
 
The Connect XE 7.1 ODBC Driver for Salesforce currently do not support Bulk API for Fetch. Currently the Bulk is only supported for Insert, Update and Delete operations. The driver is currently using SOAP APIs to export the data out of Salesforce.
 
We are working on to add this functionality in the next Salesforce ODBC driver release to support this functionality. The release currently expected to happen in Q2 2018.
 
Thanks and Regards,
Avadhoot
 
 

Posted by Avadhoot Kulkarni on 23-Aug-2018 03:38

Yes, this feature is getting implemented in Salesforce JDBC driver as well.

Currently this feature is in preview state and expected to be GA in Q4 2018 (both ODBC and JDBC).

All Replies

Posted by Avadhoot Kulkarni on 27-Feb-2018 06:32

Hi Jan,
 
The Connect XE 7.1 ODBC Driver for Salesforce currently do not support Bulk API for Fetch. Currently the Bulk is only supported for Insert, Update and Delete operations. The driver is currently using SOAP APIs to export the data out of Salesforce.
 
We are working on to add this functionality in the next Salesforce ODBC driver release to support this functionality. The release currently expected to happen in Q2 2018.
 
Thanks and Regards,
Avadhoot
 
 

Posted by Shalini Sinha on 20-Aug-2018 05:33

Can we have same functionality implemented for Salesforce JDBC driver. If yes could you please share an ETA.

Regards,

Shalini

Posted by Avadhoot Kulkarni on 23-Aug-2018 03:38

Yes, this feature is getting implemented in Salesforce JDBC driver as well.

Currently this feature is in preview state and expected to be GA in Q4 2018 (both ODBC and JDBC).

Posted by Jan Zaruba on 22-Nov-2018 14:12

Hi there,

just curious,  is the feature already out? I can't see anything in the release notes.

Jan

Posted by Avadhoot Kulkarni on 23-Nov-2018 08:55

Thanks for checking back Jan!

This feature will be part of the Salesforce JDBC 6.0 GA Release which expected by first week of December.

The Salesforce ODBC 8.0 GA with this features is still expected to be available in Q1 2019.

The Salesforce ODBC 8.0 preview with this feature is available today to try out on Windows, Linux and AIX operating systems. If you are interested to try out the preview of Salesforce ODBC 8.0, Please let your Sales or Support representative know.

Regards,

Avadhoot

This thread is closed