How can we help you?

Domo

all_tiers.png

download.png Domo is a cloud-based business management suite that integrates with multiple data sources, including spreadsheets, databases, social media and any existing cloud-based or on-premise software solution.

If Domo 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

Unlike other BI Tools, Greenhouse Recruiting does not need to whitelist your organization's IP addresses. Additionally, Greenhouse Recruiting has already whitelisted Domo's IP addresses so your organization can easily access Redshift via Domo.

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 Domo to Greenhouse's Redshift

Once the credentials to access the Greenhouse Database are received, navigate to your Domo account and click the + in the upper right-hand corner. Select Data from the dropdown menu.

1.png

Click Database and then select Amazon Redshift.

2.png

From the subsequent page, click Get the Data.

3.png

Use the subsequent dialog box to enter the following information in the appropriate fields:

 Field Name  Input
 JDBC Driver  Select the latest driver
 Host  redshift.greenhouse.io
 Database  Value shared by your Customer Success Manager
 Username  Value shared by your Customer Success Manager
 Password  Value shared by your Customer Success Manager
 Certificate Format Select No Certificate - Please use Default Certificate

5.png 

Click Connect when finished.

 

Common Connection Errors

Wrong Password

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

6.png

IP Address Not Whitelisted

Greenhouse Recruiting has whitelisted Domo's IP address listed here. If you see this error message, please contact the Greenhouse Support Team.

7.png