Skip to main content
Skip table of contents

How to Connect Excel to Alli Data (Redshift ODBC Driver Setup)

This article walks through the ODBC driver setup which allows you to connect to Alli Data within your excel on your computer.

You need to be connected to the PMG VPN (AWS VPN) before proceeding

AWS VPN Setup.docx


Before you can pull data from Alli into Excel you will need to download and install an ODBC driver using the Mac or Windows instructions below:

ODBC Driver Instructions

  1. Download the ODBC Driver using one of the following links and follow the instructions below

    1. Mac ODBC Driver

    2. Windows 64-bit ODBC Driver

  2. Walk through the ODBC Driver instructions below

Mac ODBC Driver

Submit a request to IT to receive an ODBC license key and Alli Service Desk for your Redshift credentials.


Download the Driver using this link:


Double click on the "Actual ODBC Pack.pkg" icon to run the installer.


Open the "ODBC Manager" located in your "/Applications/Utilities" folder.


Click on the "System DSN" tab and then the "Add" Button


Select the "Actual Open Source Databases" driver and click "ok". 


A new window will pop up. On this new window click "Licenses". Here you will enter the license key IT has provided you. Then click "Continue"


NOTE: in steps 8 and 9, you will need to enter the correct Redshift cluster you need access to. There are now different clusters containing different clients. Check the list here, if you’re unsure.

Enter your redshift connection configurations then click "continue". Note: you may be connecting to a different cluster than the one shown in this example


Copy the configurations as shown in the image below, making sure to use the correct server.
Note: you may be connecting to a different cluster than the one shown in this example.
Make sure you use your own redshift Login ID and Password provided by Alli Service Desk. Then click "Advanced Options".


Click the check box for "Connect using SSL encryption" then click "OK". (Leave the rest of the fields blank as shown below.) Now click "Continue".


Copy the configurations as shown in the image below. Click "Continue".


Click "Continue" on the last slide and your all set! Your ODBC driver is now ready allowing you to pull data from Redshift into Excel.

Windows ODBC Driver
  1. Go to

    “Install and configure the Amazon Redshift ODBC drive on Microsoft Windows”

  2. Select either the 32-bit or 64-bit ODBC driver. This MUST match with excel or any other tool that will use this driver.
    For example: You would download and install the 64-bit driver if you are using 64-bit excel.

  3. Amazon ODBC Installation Screenshots:

  4. Run the corresponding ODBC Data Sources (32 or 64).

  5. Select “Add” in the User DSN tab.

  6. Select the Amazon Redshift driver.

  7. Fill in the fields below and your individual User and Password.
    Data Source Name:
    (NOTE: you may need a different server, depending on the client. Please check this list and enter accordingly)
    Port: 5439
    Database: datawarehouse

  8. Select Test to verify your connection. If successful, select OK to save the configuration.

Pulling Data into Excel

  1. Open Excel and go to the “Data” Tab.

  2. Click “Get Data (Power Query)” and then click “From Database (Microsoft Query)”

  3. Select the redshift ODBC data source and click “OK”.

  4. Select any data source, click “Return Data”

  5. Select a cell for the data to populate into.

  6. If you see data loaded into Excel, everything is set up correctly!

Limits & Restrictions

  • Access Alli Redshift requires a whitelisted IP or VPN connection

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.