QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

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.

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 and use data connections that you own. You cannot change the owner of a connection.

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 Services and the underlying IP addresses to your whitelist.

Data connection requests are made from DNS name: <tenantname>.<region>.qlikcloud.com.

Underlying IP addresses (US):

  • 18.205.71.36

  • 18.232.32.199

  • 34.237.68.254

Underlying IP addresses (EU):

  • 34.247.21.179

  • 52.31.212.214

  • 54.154.95.18

Underlying IP addresses (APAC):

  • 13.210.43.241

  • 13.236.104.42

  • 13.236.206.172

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.

Data files

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

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

Database connectors

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

  • Amazon Redshift
  • Apache Drill (Beta)
  • Apache Hive
  • Apache Phoenix (Beta)
  • Apache Spark (Beta)
  • Azure SQL
  • Cloudera Impala
  • Google BigQuery
  • Microsoft SQL Server
  • MongoDB (Beta)
  • MySQL Enterprise
  • Oracle
  • PostgreSQL
  • Presto
  • Snowflake
  • Teradata

For more information, see Database.

Essbase

Connect to an Essbase dataset.

To learn more about Essbase, see Essbase connector.

Qlik Associative Big Data Index

The Qlik Associative Big Data Index (QABDI) Selector provides access to a big data source that has been indexed with QABDI.

To learn more, see Use the indexed data in an app.

REST

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

Connect to your Salesforce.com account.

For more information, see Salesforce connector.

SAP

Connect to SAP NetWeaver.

  • SAP SQL

To learn more about SAP connectors, see Qlik Connector for use with SAP NetWeaver.

Qlik Web Connectors

Connect to social media or web-based data sources.

  • AYLIEN News
  • AYLIEN Text Analysis
  • Bitly
  • Facebook Fan Pages
  • Facebook Insights
  • GitHub
  • Google AdSense
  • Google AdWords
  • Google Analytics
  • Google Calendar
  • Google Search Console
  • JIRA
  • Mailbox IMAP
  • MailChimp
  • MeaningCloud
  • 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.

Limitations

Some of the data connection types available in Qlik Sense Enterprise are not available in Qlik Cloud Services. To see which connectors are available, see About Qlik 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?