Home›Analytics & data›SAS BI (ODBC)

SAS BI (ODBC)

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

Before you start

To connect SAS BI to Interact Advanced Analytics, you need:

  • SAS BI
  • 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 setup is documented in detail in CData: Athena ODBC and SAS.

For more background, see the SAS paper on connecting AWS Data Lake technologies with SAS.

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