Database for QlikView

The Database Connectors enable QlikView to efficiently load data into a QlikView 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.

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 QlikView. The TTU components required are: CLIV2, ICU, GSS, and TPT. The TTU must be acquired directly from the Teradata Download Center.