Skip to main content

Connecting to data sources

ON THIS PAGE

RELATED LEARNING

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.

  • Data sources in shared spaces in the cloud hub

    Add data from a new connection to a shared space. You can also edit existing data connections.

    For more information, see Managing data sources in spaces.

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 Sense Enterprise on Kubernetes 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.

Load data into Qlik Sense Enterprise on Kubernetes from files in NFS networked drive provisioners.

For more information, see NFS connector.

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.

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.

  • Amazon S3 Metadata
  • AYLIEN News
  • AYLIEN Text Analysis
  • Azure Storage Metadata
  • Bitly
  • Facebook Fan Pages
  • Facebook Insights
  • GitHub
  • Google AdSense
  • Google AdWords
  • Google Analytics
  • Google Calendar
  • Google Drive and Spreadsheets
  • 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 Sense Enterprise on Kubernetes. To see which connectors are available, see About Qlik Connectors.

 

Related learning: