Programmatic Access
Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval.
To connect programmatically, you need access to the AWS Athena APIs, which can be achieved either by:
- ODBC connectivity (eg. write bespoke .NET-based applications and scripts)
- JDBC connectivity (eg. write bespoke Java-based applications and scripts)
- AWS SDK (support for many languages and frameworks)
AWS Athena SDK
This is an SDK available in many different languages.
Python
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html
You could use this SDK for Python scripts, Jupyter Notebooks, etc.
.NET
https://docs.aws.amazon.com/sdkfornet/v3/apidocs/
https://docs.aws.amazon.com/sdkfornet/v3/apidocs/items/Athena/TAthenaClient.html
You could use this to write custom analysis in .NET etc.
Other SDKs
Many other AWS Athena SDKs exist and would allow you to connect to Interact Advanced Analytics and write bespoke scripts.
Ports
It is worth noting that whilst port 443 is used for communicating with the Data Lake, port 444 is usually used to stream query results back from the Data Lake to the BI tool, so both ports need to be open. This may of course differ based on the SDK implementation.
https://docs.aws.amazon.com/athena/latest/ug/odbc-v2-driver.html
Updated 7 days ago