Available for | Roles | Super Admin |
Permissions | • Manage Data Warehouse Sync integration | |
Packages | Advanced Analytics add-on |
In order to connect to your reporting data, you will need to connect to AWS Athena. This can be achieved in one of several ways:
- Using your business intelligence tool. Your BI tool should have supporting documentation on how to connect.
- Using an Amazon-provided driver like Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC).
- Using a third-party tool, such as DBeaver.
This guide walks through how to connect to AWS Athena on Windows using ODBC. If you are interested in learning more, check out our Data Warehouse Sync help article.
Configuring your connection to Athena using ODBC:
|
Data Warehouse Sync currently only supports the 1.x version of the ODBC driver. We are working on support for the 2.x version. |
- Download and install the latest 1.x version of the ODBC driver here: https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc-driver-and-documentation-download-links.html
- You should download the 64-bit version unless you are running an older version of Windows and are sure that you need the 32-bit version.
- Open the ODBC Data Sources utility
- Select the 'User DSN' tab and click Add...
- Select 'Simba Athena ODBC Driver' and click Finish
Add the following fields. Do not edit any other fields.
-
- Data Source Name: This can be anything you want, but it is recommended that you name is something descriptive, like "Lever Data Warehouse Sync"
- The following details are listed in Lever in Settings > Integrations and API > Reporting Warehouse.
-
AWS Region: This is the AWS region that you are connecting to.
- If your account is a US-based instance, the region is "us-west-2".
- If your account is an EU-based instance, the region is "eu-central-1".
- Workgroup: It's usually the same as the name of your Lever instance.
-
S3 Output Location: Copy and paste the following location exactly, substituting {accountID} with your own Lever accountID.
- For US-based instances:
s3://services.lever.us-west-2.production.etl/accounts/{accountID}/output/
- For EU-based instances:
s3://services.lever.eu-central-1.production.etl/accounts/{accountID}/output/
- For US-based instances:
-
AWS Region: This is the AWS region that you are connecting to.
- Select Authentication Options... and set the Authentication Type to 'IAM Credentials'; fill in the User and Password using the username and password listed in Lever in Settings > Integrations and API > Reporting Warehouse.
- Click OK and then click Test...
- If the connection fails, save the error message and send it to Lever Support for further diagnosis; if the connection succeeds, you should see a message similar to the one shown below.
If you are having troubles connecting, check out the troubleshooting section of our Data Warehouse Sync article.