Connecting to data sources

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.

    For more information, see Adding data to the app.

  • 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.

    For more information, see Connect to data sources in the data load editor.

Note: You can only see data connections that you own, or have been given access to, for reading or updating. Please contact your Qlik Sense system administrator to acquire access if required.

Connecting to data sources from a private network

To request data from your data connections through a firewall, you need to add the DNS name for Qlik Cloud and the underlying IP addresses to your whitelist.

Data connection requests are made to DNS name: qlikcloud.com.

Underlying IP addresses:

  • 34.199.114.237

  • 34.198.15.5

  • 34.199.115.2

  • 13.55.8.53

  • 13.54.208.146

  • 13.54.129.200

  • 34.249.54.151

  • 34.248.202.198

  • 34.249.213.103

  • 34.253.190.0/28 (EU)

  • 34.201.223.48/28 (US)

  • 13.210.1.0/28 (APAC)

Data connection types

Qlik Sense allows you to access your data wherever it resides. The following data connection types are available with Qlik Sense Cloud. Some data connections are only available with a Cloud Business subscription.

Each type of data connection has specific settings that you need to configure.

Attached files

Attach data files directly to your app by using drag and drop.

For more information, see Attaching data files and adding the data to the app.

Data files

Load data from files that you have uploaded to your cloud.

For more information, see Adding data from uploaded data files.

Qlik DataMarket

Note:

Qlik Sense Cloud Business only.

Select current and historical weather and demographic data, currency exchange rates, as well as business, economic, and societal data.

To learn more about adding data from Qlik DataMarket, see Adding data from Qlik DataMarket.

Database connectors

Note:

Qlik Sense Cloud Business only.

Connect to an ODBC data source with preconfigured ODBC database connectors.

  • Amazon Redshift
  • Azure SQL
  • Google BigQuery
  • Microsoft SQL Server
  • Oracle
  • PostgreSQL

For more information, see Database.

Local or network files

Connect to a local or network file to select and load data.

To learn more about local and network files, see Loading files from local and network file folders.

REST

Note:

Qlik Sense Cloud Business only.

Connect 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.

To learn more about Qlik REST Connector, see REST.

Salesforce

Note:

Qlik Sense Cloud Business only.

Connect to your Salesforce.com account.

For more information, see Salesforce connector.

Qlik Web Connectors

Note:

Qlik Sense Cloud Business only.

Connect to social media or web-based data sources.

  • AYLIEN News
  • AYLIEN Text Analysis
  • Bitly
  • Dropbox Metadata
  • Facebook Fan Pages
  • Facebook Insights
  • GitHub
  • Google AdSense
  • Google AdWords
  • Google Analytics
  • Google Calendar
  • Google Search Console
  • JIRA
  • Mailbox IMAP
  • Mailbox POP3
  • MailChimp
  • MeaningCloud
  • Microsoft Dynamics CRM
  • Repustate
  • Sentiment140
  • Slack
  • SMTP
  • Strava
  • SugarCRM
  • SurveyMonkey
  • Twitter
  • Watson Natural Language Understanding
  • YouTube Data
  • YouTube Analytics

To learn more about Qlik Web Connectors, see Built-in Qlik Web Connectors.

Web Storage Provider Connectors

Note:

Qlik Sense Cloud Business only

Connect to your file-based data from web storage providers.

  • Dropbox

To learn about more about web storage, see Qlik Web Storage Provider Connectors.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?