Permissions: 

Product tier: Available to Expert tier

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.

IP address setup

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

See this article for more information on connecting to Greenhouse's Amazon Redshift instance.

Connect Domo to Greenhouse's Redshift

Once the credentials to access the Greenhouse Database are received, you'll need to complete the following setup in Domo:

Navigate to your Domo account, click the + in the upper right corner, and select Data from the dropdown menu.

1.png

Click Database and then select Amazon Redshift.

2.png

Click Get the Data on the next page.

3.png

Enter the following information in the appropriate fields:

 Field Name  Input
 JDBC Driver  Select the latest driver
 Host Listed on the Redshift Setup page in Greenhouse Recruiting.
 Database Listed on the Redshift Setup page in Greenhouse Recruiting.
 Username Listed on the Redshift Setup page in Greenhouse Recruiting.
 Password Generated on the Redshift Setup page in Greenhouse Recruiting.
 Certificate Format Select No Certificate - Please use Default Certificate

When you're finished, click Connect at the bottom of the window.

5.png

Common connection errors

Click here for solutions to common errors when connecting to the Business Intelligence Connector.