SAS BI (ODBC)

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

• SAS BI
• 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 setup is documented in quite a lot of detail on this page.
https://www.cdata.com/kb/tech/athena-odbc-sas.rst

Here you can also find a paper by SAS, on connecting AWS Data Lake technologies with SAS.
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4634-2020.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