GuidesAPI Reference
Guides

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