The Qlik Salesforce Connector enables QlikView and Qlik Sense to efficiently load data into an app from a Salesforce.com data set. You must have a Salesforce.com account with current access credentials to access data. Once a connection to a Salesforce.com account has been created, data can be selected from tables available to the user’s account and then loaded into an app where it can be used in visualizations.
- Qlik Sense Desktop/Qlik Sense Mobile Client Managed
- Qlik Sense Business
- Qlik Sense Enterprise SaaS
- QlikView (Requires separate installation)
For a complete history of changes through all versions, see Version history.
Version 15.61.0 gives you the option to request user defined credentials from anyone accessing a Salesforce connector. This is only available in Qlik Sense SaaS.
Qlik Sense deployment
The Salesforce Connector is built into Qlik Sense. This means that when you install Qlik Sense, the Salesforce Connector is immediately available in the Data Manager and the Data load editor.
The Salesforce Connector must be installed manually for QlikView. For more information, see Install the Qlik Salesforce Connector for QlikView.
|Connector version||QlikView versions|
|14.8.1||April 2019, November 2018, November 2017, 12.10, 12.00|
|14.6||November 2018, November 2017, 12.10, 12.00|
|14.4||November 2017, 12.10, 12.00|
|14.3||November 2017, 12.10, 12.00|
|14.2||November 2017, 12.10, 12.00|
|14.1||November 2017, 12.10, 12.00|
Supported Salesforce API version
The Salesforce Connector supports up to Salesforce API version 52.
Supported Salesforce data types
The following Salesforce.com data types are supported by the Salesforce Connector and are available for selection through the user interface. Fields containing unsupported data types are not displayed.
- Lookup Relationship
- Picklist (Multi-Select)
- Roll-Up Summary
- Text (Area)
- Text Area (Long)
- Text Area (Rich)
- Text (Encrypted)
Geolocation is composed of two primitive data types: longitude and latitude. The Qlik Salesforce Connector supports Geolocation by displaying each of its primitive types in separate fields. When a table contains a field with the Geolocation data type, the field displays as empty. The component values of the Geolocation field are then displayed in the table as two separate fields.
In version 14.0 of the Qlik Salesforce Connector, NULL values in the Salesforce data source were loaded as empty strings. In version 14.1 of the Salesforce Connector, NULL values are loaded as real NULL values. You can force the Salesforce Connector to load NULL values as empty strings by adding the following code to your script in the Data load editor (Qlik Sense) or the Edit script dialog (QlikView):
null() AS From,
" AS To
MAP * Using EmptyRowsMapper;
Version 15.5 contains the ability to increase the interval between API calls made to Salesforce. It also contains bug fixes. It is for Qlik Sense only.
Version 14.8.1 contains user interface improvements and bug fixes.
Version 14.7 contains bug fixes for Qlik Sense only.
Version 14.6 contains bug fixes for QlikView only.
Version 14.4 contains bug fixes only.
Version 14.3 contains bug fixes only.
Version 14.2 contains bug fixes only.
Bulk API with PK Chunking are supported in this version. PK Chunking splits large queries into small chunks that are processed concurrently in a thread pool. Chunks are processed concurrently in a thread pool therefore improving query time and reducing timeout errors when processing large data tables.
The Qlik Salesforce Connector is built into Qlik Sense and Qlik Cloud.
- First version to be integrated with Qlik Sense. From now on it is not installed separately. When you install Qlik Sense, the connector is immediately available in Add data and Data load editor.
- The Qlik Sense Enterprise installation removes an earlier version of the Salesforce Connector if it is installed on the server. When you install the latest version of Qlik Sense Desktop, you must manually uninstall the Qlik Salesforce Connector 13.x if it is installed on the system. If the Salesforce Connector 13.x version is installed on a Qlik Sense Desktop system, it overrides the 14.0 version installed with Qlik Sense Desktop.