I have a few questions related to salesforce connector built by Qlik (not from other party such as QVSource, etc.).
We're currently using Qlikview 11.12.0 with Qlikview SalesForce Connector v11 and considering upgrading to the latest Qlik SalesForce Connector available from Qlik website (13.1). However, from reading the "QlikSalesforceConnector13.0_InstallationAndUserGuide.pdf", it seems we can only have 1 query at a time using the same "user account".
Can anyone help clarifying if this "user account" refers to either:
1. the "domain service account" hosting the Qlikview Server?; OR
2. the SalesForce account used in the connection string? (I''m guessing the answer is this, but I'd like to make sure).
3a. Are we limited to 1 query per user account, regardless of which SalesForce Environment we're trying to do query on?
Assuming we have 3 SalesForce Environments: Test, UAT, & Production. Can we run parallel extractions, using 2 different QVW extraction files, run from the same Qlikview Server (meaning the same Qlik domain service account), one extracts "Account table" from "Test" environment, and the other extract "Account table" from "Production" environment.
If we cannot do scenario 3a above, is any scenario below possible?
3b. The same Qlikview Server, have 2 extract QVWs hitting the same "Production" environment, BUT with 2 different SalesForce accounts in each of the connection string.
3c. 2 Qlikview Server (both servers having the same Qlikview domain service account), have 2 extract QVWs hitting 2 different environments, BUT using the same SalesForce account in the connection string.
4. Do you have any experience extracting "Case", "Work Order", "Opportunity" tables using SalesForce Connector 13.1, and even though there's nothing in the log (as if the extraction process is completed successfully), it only returned partial number of records (for example, only return 156,000 records instead of the total 210,000 records)?
Sorry for posting these long questions, but I'm hoping to