When making a query to Salesforce in BULK mode, Qlik Salesforce Connector consumes a large number of API calls. As a result, your Salesforce API limit might be exceeded, which prevent using other Salesforce API clients while reloading a QlikView/ Qlik Sense app with Salesforce Connector.
In a closer look, Salesforce Connector sends a lot of the following two API queries:
GET_BATCH_INFO and
GET_JOB_STATUS. For example, when loading a Salesforce table that contains 1.6M records, the following API consumption might be observed on Salesforce side:
- CREATE_BATCH: 25
- CREATE_JOB: 25
- GET_BATCH_INFO: 9061
- (...)
- GET_JOB_STATUS: 9012
Salesforce does not inform the connector when the batch is ready on Salesforce side after connector submitted job / batch to Salesforce server. Instead, the connector has to constantly make calls like
GET_BATCH_INFO and
GET_JOB_STATUS to know when the batch is ready.
The issue has been investigated in bug
QVXSF-579. R&D is considering a configurable parameter, for example
"Status Call Interval" in seconds, which decides how often the connector should query Salesforce for the current batch status. This is an improvement ticket for future releases of the connector.
Environment:
- Qlik Salesforce Connector as of version 14.4.0
This behavior is working as designed as of the latest version of Qlik Salesforce Connector (14.4).