Connect Tableau to Greenhouse database

Permissions: --

Product tier: Available to Expert subscription tier

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:

If you're having trouble, click here for solutions to some common connection errors. If you're running into any issues with Tableau, contact that vendor for further assistance.

Allowlist IP addresses and retrieve Greenhouse database credentials

Contact our Greenhouse Support team to allowlist any IP addresses you will use to connect to the database.

Note: For security reasons, Greenhouse is only able to allowlist 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.

Additionally, 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 allowlisted for your account and the credentials to access the Greenhouse Database are received, configure Tableau to pull data from the S3 or Redshift instance.

You can use the following credentials when configuring Tableau and Greenhouse's Amazon Redshift instance.

Field Name Input
 Server redshift.greenhouse.io
Port 5439
 Database The value entered in Greenhouse Recruiting
 Username The value entered in Greenhouse Recruiting
 Password The value entered in Greenhouse Recruiting
 Require SSL Required

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