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.
Updated over 3 years ago