In prior releases, the Adapter for Salesforce.com used a REST API to issue SOQL (Salesforce Object Query Language) commands to retrieve data. This technique is acceptable for direct reporting against Salesforce or for migrating modest data volumes.
However, Salesforce.com recommends using the BULK API capability bulk query to efficiently query large data sets and reduce the number of API requests
Bulk Query can now be enabled from the settings panel for the adapter under Bulk Services by selecting ON from the new BULKQUERY pull-down menu. Additional options allow you to enable PK (Primary Key) chunking and to set the chunk size.
Bulk query can also be enabled or disabled with the following command:
ENGINE SFDC SET BULKQUERY {ON|OFF}When this option is selected, queries that meet the salesforce.com requirements (such as no aggregation) use bulk query.
To extract extremely large data sets, the Bulk API capability PK Chunking can be enabled with the following command:
ENGINE SFDC SET PKCHUNKING {ON|OFF} When this option is enabled, the Primary Key of the object is used to retrieve data in chunks, allowing retrieval of larger data volumes.
When PK chunking is enabled, the chunk size can be set using the following command:
ENGINE SFDC SET PKCHUNKSIZE {n|100000}where:
Where n is an integer between zero (0) and 250000. When PKCHUNKSIZE is set to zero or not set, the default chunk size (100,000) is used.
| WebFOCUS | |
|
Feedback |