The RAE is a relational database that is located within Ohio State's Amazon Web Services (AWS) environment. Any tool capable of connecting to an Amazon Redshift database can connect to the RAE. For example, tools like Tableau, DBeaver, SAS, and other advanced query tools are compatible with the RAE.
DBeaver is an open-source database browsing tool that can be used to connect to and query data within the RAE. The instructions below outline how you can use DBeaver to connect to the RAE. Other database query tools will function very similarly to DBeaver. Thus, this document can used as a guide when using other tools such as Tableau.
- Launch DBeaver and find the Database Navigator on the left side
- Click Create a new connection
- Select "All" and search for Redshift.
- Select Redshift
- Reference the "Connection Details" section below to configure the following fields on this screen:
- Host = redshift-prd.rae.osu.edu
- Port = 5439
- Database = rsprd
- User (your own, individual user IDM account)
- Password (for your individual user IDM account)
- For information on how to find your RAE username and password, please review Retrieving Your Password to the RAE
- All connections to the RAE database must be SSL-enabled. To finish configuring your DBeaver connection, enable SSL.
- Click "Network settings"
- Click the "SSL" tab
- Check "Use SSL"
- Click "< Back" to return
- Test your connection using the "Test Connection..."
- REMEMBER: You will need to be connected to OSU VPN using the OSULAN or DS-ACCESS profile to be able to authenticate with Redshift; this is true for any desktop application that you may be using including Tableau, SAS, or other database query tool
- On your first attempt to connect, DBeaver should offer to download the Redshift driver. Click "Download."
- When testing your connection, once you receive a successful response, click "Finish".
You will now be able to connect to Redshift by double-clicking the database you just set up in the Database Navigator pane.
Important Information
For MITS customers, DBeaver is available to install in Microsoft Endpoint Manager as a self-service installation package. For others, please contact your helpdesk about installing directly from the DBeaver site.