ODBC databases
The Qlik ODBC Connector Package contains database connectors that enable Qlik Sense to efficiently load data into an app from databases accessed through supported ODBC (Open Database Connectivity) drivers.
The ODBC Connector Package does not support single sign-on (SSO)
Qlik Data Gateway - Direct Access
Data source connectors that support Qlik Data Gateway - Direct Access appear twice in the Add data connection dialog. Once with just the data source name and once with the data source name followed by (via Direct Access gateway). Qlik Data Gateway - Direct Access eliminates the need to open inbound firewall ports, allowing Qlik Sense SaaS applications to securely access firewalled data. If your enterprise data source is located behind a firewall and can be accessed via Qlik Data Gateway - Direct Access, it is strongly recommended to connect to it via the Direct Access gateway.
All ODBC data sources, except ServiceNow are supported with Qlik Data Gateway - Direct Access.
For more information on Qlik Data Gateway - Direct Access, see Data gateways.
Databases
The following databases are supported with ODBC drivers.
- Amazon Athena
- Amazon Redshift
- Apache Drill
- Apache Hive
- Apache Phoenix
- Apache Spark
- Azure SQL Database
- Cloudera Impala
- Google BigQuery
- Microsoft SQL Server
- MongoDB
- MySQL Enterprise Edition
- Oracle
- PostgreSQL
- Presto
- ServiceNow
- Snowflake
- Teradata