ODBC Connector Package

The Qlik ODBC Connector Package contains database connectors that enable QlikView and Qlik Sense to efficiently load data into an app from databases accessed through supported ODBC (Open Database Connectivity) drivers. When using one of the ODBC database connectors in the Qlik ODBC Connector Package, you do not need to create a DSN connection before connecting to the ODBC database.

Note: Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

What's new in this version

For a complete history of changes through all versions, see Version history.

6.25

This release contains new and updated ODBC drivers. The new drivers are for Snowflake. The updated drivers are for Apache Hive, Cloudera Impala, and Presto. It also contains improvements to error messages.

Note:

The ODBC Connector Package does not support single sign-on (SSO) in:

  • QlikView
  • Qlik Sense Desktop
  • Qlik Cloud
Note: single sign-on (SSO) does not work with QlikView.

The database versions supported by the drivers are:

  • Amazon Redshift
  • Apache Drill (Beta)
  • Apache Hive (0.11 to 3.1)
  • Apache Phoenix (4.4.0 to 4.7.0)
  • Apache Spark (1.6 to 2.3)
  • Azure SQL (2005 to 2014)
  • Cloudera Impala (1.0.1 to 3.0)
  • Google BigQuery
  • IBM DB2 (V10.5, V10.1, V9.5)
  • Microsoft SQL Server (2012 to 2017)
  • MongoDB (3.4, 3.6, and 4.0)
  • MySQL Enterprise (5.6, 5.7, and 8.0)
  • Oracle (12c, 11.2)
  • PostgreSQL (9.0 - 9.6)
  • Presto ( 0.206 and earlier)
  • Snowflake
  • Sybase ASE (16, 15.7)
  • Teradata (14.10, 15.0, 15.10, 16.0, 16.10, and 16.20)

Qlik Sense compatibility

Starting from version 1.1, the ODBC Connector Package is installed automatically with Qlik Sense. This means that the included database connectors are directly available in the Data Manager and the Data load editor.

Connector version Qlik Sense versions
6.25 September 2019
6.16 June 2019
5.18 April 2019
5.18 February 2019
5.12 November 2018
5.8 September 2018
5.2 June 2018
4.8 April 2018
4.0 February 2018
3.0 November 2017
2.0

3.2,3.1, 3.0

1.2

3.1, 3.0

1.1

3.0

1.0

2.x

QlikView compatibility

The Qlik ODBC Connector Package must be installed manually for QlikView.

Connector version QlikView versions
6.16 April 2019, November 2018, November 2017, 12.20, 12.10, 12.00
5.12 November 2018, November 2017, 12.20, 12.10, 12.00
5.8 November 2017, 12.20, 12.10, 12.00
5.2 November 2017, 12.20, 12.10, 12.00
4.8 November 2017, 12.20, 12.10, 12.00
4.0

November 2017, 12.20, 12.10, 12.00

3.0

12.20, 12.10, 12.00

2.0 -
1.2

12.10, 12.00

1.1 -
1.0

12.00

Databases

The following databases are supported with ODBC drivers.

Version history

6.16

This release contains new and updated ODBC drivers for Apache Hive, Cloudera Impala, MySQL Enterprise, PostgreSQL, Presto, Oracle, Apache Drill, Google BigQuery, Apache Spark, MongoDB, Apache Phoenix, Amazon Redshift, Microsoft SQL Server, and Teradata. The single sign-on (SSO) support for the Microsoft SQL Server Connector, the Cloudera Impala Connector and the Apache Hive Connector is no longer in beta-level. The Google BigQuery Connector has been enhanced.

5.18

This release adds beta-level single sign-on (SSO) support for the Microsoft SQL Server Connector, the Cloudera Impala Connector and the Apache Hive Connector.

5.12

This release adds support for the NTLM (NT LAN Manager) security protocol to the Microsoft SQL Server connector.

5.8

This release contains new and updated ODBC drivers. The new drivers are for Apache Hive, Cloudera Impala, MySQL Enterprise, Azure SQL, and Teradata.

5.2

This release contains new ODBC drivers. One new driver is fully implemented: Presto. The other new drivers are beta versions: Apache Drill, Apache Spark, Apache Phoenix, and MongoDB.

4.8

This release contains new and updated ODBC drivers. The new drivers are for Apache Hive, Cloudera Impala, MySQL Enterprise, and Teradata.

4.0

This release contains new and updated ODBC drivers. The new drivers are for Oracle and PostgreSQL.

3.0

This release contains two new ODBC drivers: Amazon Redshift and Google BigQuery. There are no changes to the other drivers with this release.

This release updates all the ODBC drivers for Qlik Sense and QlikView.

2.0

This release updates all the ODBC drivers for Qlik Sense.

1.2

This release contains updated ODBC drivers and provides for data filtering when selecting data in the Qlik Sense Data manager.

Supported database versions:

  • Apache Hive ( CDH 1.1, CDH 0.9x)
  • Cloudera Impala (2.3, 1.0)
  • IBM DB2 (V10.5, V10.1, V9.5)
  • Microsoft SQL Server (2014, 2012, 2008 R1, R2)
  • MySQL Enterprise (5.7 server, 5.1 server)
  • Oracle (12c, 11.2)
  • PostgreSQL (9.4, 9.2, 8.4)
  • Sybase ASE (16, 15.7)
  • Teradata (15.0, 14.0, 12.0)

1.1

This is a version for Qlik Sense only, and it is the first version when the connector is installed automatically with Qlik Sense. The included database connectors are directly available in the Data Manager and the Data load editor.

Supported database versions:

  • Apache Hive ( CDH 1.1, CDH 0.9x)
  • Cloudera Impala (2.3, 1.0)
  • IBM DB2 (V10.5, V10.1, V9.5)
  • Microsoft SQL Server (2014, 2012, 2008 R1, R2)
  • MySQL Enterprise (5.7 server, 5.1 server)
  • Oracle (12c, 11.2)
  • PostgreSQL (9.4, 9.2, 8.4)
  • Sybase ASE (16, 15.7)
  • Teradata (15.0, 14.0, 12.0)

1.0

Supported database versions:

  • Apache Hive (CDH 0.9x)
  • Cloudera Impala (1.0)
  • IBM DB2 (V10.1, V9.5)
  • Microsoft SQL Server (2012, 2008 R1, R2)
  • MySQL Enterprise (5.1 server)
  • Oracle (11.2)
  • PostgreSQL (9.2, 8.4)
  • Sybase ASE (15.7)
  • Teradata (14.0, 12.0)