Enable Bulk API Queries
EnableBulkQuery
Key Name | Default Value | Required |
---|---|---|
|
Selected ( |
No |
Description
When this option is enabled (1
), the connector attempts to use the Bulk API to retrieve data. The query must be executable through the Bulk API, and the number of results returned must be equal to or greater than the value set for the BulkQueryThreshold
option. If data retrieval fails, then the connector falls back to using the REST API to retrieve the data.
Note:
This option is only available when the connector parses queries as SQL statements. For more information see Parse Method.
- Bulk API Query At This Many Records
- BulkBatchSize
- Advanced Driver Configuration Options on page 1
- Configuring Advanced Options
- Creating a Data Source Name
- Configuring a DSN-less Connection
- Using a Connection String