JDBC Connectivity
You will find all of our documented JDBC connectivity options under this category.
AWS Athena JDBC Driver
You can find the latest JDBC drivers on this page.
https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
If you require an older version of the JDBC driver, you can find them here.
https://docs.aws.amazon.com/athena/latest/ug/connect-with-previous-jdbc.html
Once downloaded, you will need to place the drivers in the appropriate locations, depending on your use case.
eg. Tableau will require you to place them here - other services may require different setups.
- MacOS:
~/Library/Tableau/Drivers - Windows:
C:\Program Files\Tableau\Drivers
Generally speaking, any specific BI vendor, will have JDBC setup instructions and binary locations documented.
Athena Workgroup Setting
Interact Advanced Analytics provides a separate Workgroup for each customer, and you need to specify the Workgroup when connecting to Interact Advanced Analytics.
Full documentation on the *AWS Athena JDBC Configuration can be found here.
https://s3.amazonaws.com/athena-downloads/drivers/JDBC/SimbaAthenaJDBC-2.0.16.1000/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf
Workgroup specifically can be found on page 104.
eg. AWS Athena JDBC with Tableau, achieve this by setting a key-value pair in the athena.properties file, in this location ~/My Tableau Repository/Datasources.
If the Workgroup name provided to you was Inc_Ltd, the contents of the file will need to look like this.
workgroup=Inc_Ltd
Depending on the BI vendor, you will either specify this in a similar fashion, via UI Additional Settings inputs, or via other means.
Interact Advanced Analytics Configuration
This will be provided to you as a part of the technical onboarding for Advanced Analytics, and will include the following details:
- Server: eg. athena.eu-west-1.amazonaws.com (can be retrieved from here https://docs.aws.amazon.com/general/latest/gr/athena.html <- can change over time)
- S3 Staging Directory: s3://{mybucket}-results/ (this is where the query results will be saved)
- Access Key ID: This is equivalent to the username
- Access Secret Key: this is equivalent to the password
- Workgroup: This needs to be set for the connectivity to work - each vendor will accept and pass this setting to the JDBC slightly differently.
- Database: This is the Athena database where your analytics data will be located.
- Table Name: This is the Athena table where your analytics data will be located.
Advanced ODBC Options
The JDBC connector is highly configurable. You can discover more options here:
https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver-advanced-connection-parameters.html
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.
Updated 7 days ago