Qlik Sense lets you to connect to your data, wherever it is stored, with a wide range of Qlik Connectors and other data connection types. When you create a data connection it is saved to Qlik Sense, so you can quickly select and load data from the data sources that you commonly use. Connect to databases, social media data, local files, remote files, and web files.
Create a connection
To select data from a data source, you can either create a new data connection or use a saved data connection. You can create data connections and access your saved connections from:
-
Add data in the data manager.
Add new data to your app quickly and get assistance creating associations.
-
Data connections in the data load editor.
Select data from a new or existing data connection, or use the script editor to load data from a data connection. You can also edit existing data connections.
Data connection types
Qlik Sense allows you to access your data wherever it resides. The following data connection types are available with Qlik Sense. You can download connectors from the qlik.com download site to use with Qlik Sense.
Many of the connectors that access these data sources are built into Qlik Sense, while others can be added. Each type of data connection has specific settings that you need to configure.
Attached filesAttach data files directly to your app by using drag and drop. |
Qlik Sense Enterprise |
Qlik DataMarketSelect current and historical weather and demographic data, currency exchange rates, as well as business, economic, and societal data. |
Qlik Sense Enterprise Qlik Sense Desktop |
Database connectorsConnect to an ODBC data source with preconfigured ODBC database connectors.
|
Qlik Sense Enterprise Qlik Sense Desktop |
EssbaseConnect to an Essbase dataset. |
Qlik Sense Enterprise Qlik Sense Desktop |
Local or network filesConnect to a local or network file to select and load data. |
Qlik Sense Enterprise Qlik Sense Desktop |
ODBC connections through DSNConnect to a Database Management System (DBMS) with ODBC. Install an ODBC driver for the DBMS in question, and create a data source DSN. |
Qlik Sense Enterprise Qlik Sense Desktop |
RESTConnect to a REST data source. The REST connector is not tailored for a specific REST data source and can be use to connect to any data source exposed through the REST API. |
Qlik Sense Enterprise Qlik Sense Desktop |
SalesforceConnect to your Salesforce.com account. |
Qlik Sense Enterprise Qlik Sense Desktop |
SAPLoad data from SAP NetWeaver. |
Qlik Sense Enterprise Qlik Sense Desktop |
Web filesConnect to a web-based data source on a web URL. |
Qlik Sense Enterprise Qlik Sense Desktop |
Web Storage Provider ConnectorsConnect to your file-based data from web storage providers.
|
Qlik Sense Enterprise Qlik Sense Desktop |
Third-party connectors
With third-party connectors, you can connect to data sources that are not directly supported by Qlik Sense. Third-party connectors are developed using the QVX SDK or supplied by third-party developers. In a standard Qlik Sense installation you will not have any third-party connectors available.
Where is the data connection stored?
Connections are stored in the repository database by the Qlik Sense repository service. In a Qlik Sense server deployment, you manage data connections with the Qlik Management Console. The Qlik Management Console allows you to delete data connections, set access rights, and perform other system administration tasks.
In Qlik Sense Desktop, all connections are saved in the app without encryption.
Limitations
It is not possible to name a data connection 'DM'. This name is reserved by the built-in Qlik DataMarket connector.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!