Database for Qlik Sense

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

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

The following databases are supported with version 3.0 and earlier of the ODBC drivers and the specific versions that have been tested are in parentheses.

  • Amazon Redshift
  • Apache Hive (CDH 5.5, CDH 1.1, CDH 0.9x)
  • Cloudera Impala (2.3, 1.0)
  • Google BigQuery
  • IBM DB2 (V10.5, V10.1, V9.5)
  • Microsoft SQL Server (2005 to 2014)
  • 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)
To use the Teradata ODBC driver, the Teradata Tool Utilities (TTU) V16.0 or later version must be installed on the machine with Qlik Sense. The TTU components required are: CLIV2, ICU, GSS, and TPT. The TTU must be acquired directly from the Teradata Download Center.