How can we help you?

Connect Tableau to Greenhouse Database

all_tiers.png

download.png Tableau Software creates tools that transform the way people use data to solve problems. They make analyzing data fast and easy, beautiful and useful.

If Tableau is your preferred business intelligence tool, your organization can connect the tool to Greenhouse Recruiting’s Amazon Redshift to pull all of your data and perform advanced data analytics. In this article, we will cover how to:

 

Whitelist IP Addresses and Retrieve Greenhouse Database Credentials

Greenhouse Recruiting has whitelisted most of Tableau Online's server IP addresses. If your organization experiences any connection issues, reach out to the Greenhouse Support team with the IP address of your team's instance.

Additionally, contact our Greenhouse Support team to whitelist any IP addresses that you will use to connect to the database

Note: For security reasons, Greenhouse is only able to whitelist the public IP addresses of your office. If your organization needs to access the database from a different IP address (e.g. for remote employees), please reach out to your IT team to explore other options, such as setting up VPN.

Contact your organization's Customer Success Manager to receive the necessary credentials to log into Greenhouse Recruiting's database hosted on Amazon Redshift. Your organization will need the following information:

Database Name
Database Username
Database Password

 

Connect Tableau to Greenhouse Database

Once all necessary IP addresses are whitelisted for your account and the credentials to access the Greenhouse Database are received, navigate to your Tableau account.

Double-click Amazon Redshift under the Connect header.

Picture1.png

Use the subsequent dialog box to configure the following settings for the new database:

Field Name Input
 Server  redshift.greenhouse.io
 Port  5439
 Database  Enter value shared by Greenhouse Support
 Username  Enter value shared by Greenhouse Support
 Password  Enter value shared by Greenhouse Support
 Require SSL  Check the box

Click Sign In when finished.

2.png

Select your organization's schema from under Schema,. This corresponds to the Username that was shared with you.

Note: You may see a list of other organizations under Schema but you will only be able to access your organization's schema. 

 

Common Connection Errors

3.png

 

Wrong password: Check the password and make sure there are no empty spaces before and after the password that were copied and pasted.

4.png

 

IP address not whitelisted. Please make sure that you are connecting from one of the whitelisted IP addresses.

5.png

 

You do not have access to the schema. If you select another organization from the list of schemas, you will run into this error.
6.png Tableau Online’s IP addresses have not been whitelisted for your site location. Please check the list here and write to us at support@greenhouse.io so we are able to whitelist them.