Home›Analytics & data›Qlik (ODBC)

Qlik (ODBC)

Connect Qlik to Interact Advanced Analytics using the AWS Athena ODBC driver.

Before you start

To connect Qlik to Interact Advanced Analytics, you need:

  • Qlik
  • The AWS Athena ODBC driver

Interact Advanced Analytics uses AWS Data Lake technologies for data querying, analysis and retrieval.

Overview

The setup largely follows the steps in ODBC connectivity, which covers the ODBC configuration in depth.

The Qlik AWS Athena setup is documented in detail in Qlik and AWS Athena.

Ports

Port 443 is used to communicate with the Data Lake, and port 444 is used to stream query results back from the Data Lake to the BI tool. Both ports must be open. See the Athena ODBC v2 driver documentation.

Section: Analytics & data