Configuring Bulk API Settings

The Simba Salesforce JDBC Connector supports the Bulk API, and provides a number of connection properties that you can use to fine-tune the connector's use of the Bulk API and the Primary Key (PK) Chunking feature:

• BulkBatchSize
• BulkQueryThreshold
• EnableBulkQuery
• EnableParallelBulkJob
• EnablePKChunking
• PKChunkSize
• PKChunkThreshold

You can configure the Bulk API settings to optimize connector performance for processing queries. The ideal configuration for your connection varies depending on the size of the retrieved data sets and the number of API calls that can be called. The following examples demonstrate a few ways that you can configure Bulk API settings to modify connector performance.

Example 1: Use the Bulk API with PK Chunking When Possible

This configuration provides the highest performance for large datasets, but also consumes the most Salesforce API calls.

To configure the connector to use the Bulk API with PK Chunking whenever possible, set a very high PK chunk size and then very low threshold sizes for invoking the Bulk API and PK Chunking.

For example:

Example 2: Use the Bulk API without PK Chunking

This configuration reduces the number of Bulk API calls that the connector uses, and might be preferred in scenarios where the number of API calls must be limited. However, disabling PK Chunking can slow down query processing, and you might encounter connection timeouts for any queries that cannot be completed within two minutes.

To configure the connector to use Bulk API without PK Chunking, disable the PK Chunking feature.

For example:

Example 3: Do Not Use the Bulk API

This configuration might be preferred in scenarios where you are low on Bulk API queries and want to preserve those API calls.

To configure the connector to not use the Bulk API, disable the Bulk API feature.

For example: