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