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.

What's new in this version

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

5.12

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

The database versions supported by the drivers are:

  • Amazon Redshift
  • Apache Drill (Beta)
  • Apache Hive (CDH 5.5, CDH 1.1, CDH 0.9x)
  • Apache Phoenix (Beta)
  • Apache Spark (Beta)
  • Azure SQL (2005 to 2014)
  • Cloudera Impala (2.3, 1.0)
  • Google BigQuery
  • IBM DB2 (V10.5, V10.1, V9.5)
  • Microsoft SQL Server (2005 to 2014)
  • MongoDB (Beta)
  • MySQL Enterprise (5.7 server, 5.1 server)
  • Oracle (12c, 11.2)
  • PostgreSQL (9.0 - 9.6)
  • Presto
  • Sybase ASE (16, 15.7)
  • Teradata (16.20, 15.10, 15.0, 14.10, 14.0)

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
5.12 November 2018, September 2018
5.8 September 2018
5.6 June 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
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

5.8

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

5.6

This release contains one new ODBC drivers: Azure SQL. The Azure SQL Database Connector is available in Qlik Sense Cloud only.

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)