Programmatic access
Overview
Interact Advanced Analytics uses AWS Data Lake technologies for data querying, analysis and retrieval.
To connect programmatically, you need access to the AWS Athena APIs. You can achieve this in one of these ways:
- ODBC connectivity — for example, to write bespoke .NET-based applications and scripts
- JDBC connectivity — for example, to write bespoke Java-based applications and scripts
- AWS SDK — supports many languages and frameworks
AWS Athena SDK
The AWS Athena SDK is available in many languages.
Python
See the Boto3 Athena reference.
You can use this SDK for Python scripts, Jupyter Notebooks and similar.
.NET
See the AWS SDK for .NET API reference and the AthenaClient reference.
You can use this to write custom analysis in .NET.
Other SDKs
Many other AWS Athena SDKs exist. Each lets you connect to Interact Advanced Analytics and write bespoke scripts.
Ports
Port 443 is used to communicate with the Data Lake, and port 444 is usually used to stream query results back from the Data Lake to the BI tool. Both ports must be open. This may differ depending on the SDK implementation. See the Athena ODBC v2 driver documentation and the Athena JDBC v2 driver documentation.