Connecting to Data Warehouse Sync using ODBC

Follow
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:

  1. Using your business intelligence tool. Your BI tool should have supporting documentation on how to connect.
  2. Using an Amazon-provided driver like Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC).
  3. 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.

ODBC data sources utility

  • Select the 'User DSN' tab and click Add...

User DSN tab on ODBC Data Source Administrator modal with arrow pointint to Add button

  • Select 'Simba Athena ODBC Driver' and click Finish

Create new data source modal with Simba Athena ODBC Driver selected

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/
  • 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.

Authentication options modal with IAM Credentials in Authentication Type field

  • 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.

Test Results modal with success message

If you are having troubles connecting, check out the troubleshooting section of our Data Warehouse Sync article.

Was this article helpful?
0 out of 0 found this helpful