Configuring Bulk Load
- Last Updated: January 17, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The Salesforce driver supports DataDirect Bulk Load, a feature that allows your application to send large numbers of rows of data to a Salesforce instance. The driver uses the Salesforce Bulk API for bulk load operations. You can specify which type of bulk load operation will be performed when a load method is called by setting the operation property using the setProperties() method of the DDBulkLoad interface. See Specifying the Bulk Load Operation.
In addition, you can configure the Salesforce driver to use the bulk load protocol when it encounters a request to execute a single Insert, Update, or Delete statement that affects multiple rows. See Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver).
The following table summarizes the connection properties that affect how bulk load works with the Salesforce driver.
| Property | Description |
|---|---|
| BulkLoadAsync |
Determines whether the driver treats bulk load operations as synchronous or
asynchronous. The default is |
| BulkLoadBatchSize | Provides a suggestion to the driver for the number of rows to load to
the database at a time when bulk loading data. The default is
10000. |
| BulkLoadConcurrencyMode | Determines whether multiple batches associated with a bulk load
operation are processed by Salesforce in parallel or one at a time. The default is
parallel. |
| BulkLoadPollInterval | Specifies the number of seconds the driver waits to request bulk
operation status. This interval is used by the driver the first time it requests
status and for all subsequent status requests. The default is 10
(seconds). |
| BulkLoadThreshold | Sets a threshold (number of rows) that, if exceeded, signals the
driver to use bulk load for insert, update, delete, or batch operations. The default
is 4000 (rows). |
| EnableBulkLoad | Specifies whether the driver can use the bulk load protocol for
insert, update, delete, and batch operations. The default is
false. |
See Using DataDirect Bulk Load for additional information on bulk load functionality.