ODBC databases

The Qlik ODBC Connector 套件 contains database connectors that enable Qlik Sense to efficiently load data into an app from databases accessed through supported ODBC (Open Database Connectivity) drivers.

Qlik 資料閘道 - 直接存取

Data source connectors that support Qlik 資料閘道 - 直接存取 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 資料閘道 - 直接存取 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 資料閘道 - 直接存取, it is strongly recommended to connect to it via the Direct Access gateway.

For more information on Qlik 資料閘道 - 直接存取, 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

• Azure Synapse Analytics

• Cloudera Impala

• Databricks

• DynamoDB
• Google BigQuery
• Microsoft SQL Server
• MongoDB
• MySQL Enterprise Edition
• Oracle
• PostgreSQL
• Presto
• ServiceNow
• Snowflake
• Teradata