Qlik (ODBC)

Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval. To connect Qlik to Interact's Advanced Analytics Solution, you will need:

  • Qlik
  • AWS Athena ODBC Driver

The setup largely mimics the steps outlined in the ODBC Connectivity page, as this covers the in-depth ODBC configuration steps.

The Qlik AWS Athena setup is documented in quite a lot of detail on this page.
https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlik-sense-enterprise-documents/2508/1/Qlik%20and%20AWS%20Athena.pdf

Ports

It is worth noting that whilst port 443 is used for communicating with the Data Lake, port 444 is used to stream query results back from the Data Lake to the BI tool, so both ports need to be open.

https://docs.aws.amazon.com/athena/latest/ug/odbc-v2-driver.html