Business Intelligence Connector is designed for companies with robust analytics requirements that prefer a flexible, hands-on approach to analyzing their data.
We've collected answers to some common questions about Business Intelligence Connector.
Getting started
Which companies are successful with Business Intelligence Connector?
Our most successful Business Intelligence Connector organizations have an established goal for how they want to use their Greenhouse data to drive their organization's goals.
This often includes having a perspective about the KPIs and recruiting data before purchasing Business Intelligence Connector. In most cases, these organizations have a data analyst or business intelligence resource who is prepared to dedicate significant time to using the data sent with Business Intelligence Connector.
In some cases, these customers are already exporting Greenhouse Recruiting data and spending significant time manipulating it to create unique reports for their Greenhouse Recruiting goals, such as metrics over time, department-level views, and so on.
How do I enable Business Intelligence Connector?
Check out Enable Business Intelligence Connector for detailed instructions.
What can I do with Business Intelligence Connector?
If you don't have an established goal with Business Intelligence Connector, that's okay! Because it's your organization's data, you can use it however you see fit. Here's a list of the most common uses of Business Intelligence Connector:
- Understand the impact of recruiting efforts, communicate progress, diagnose bottlenecks, drive decision-making, and predict future performance.
- Access most of your raw recruiting data, including some additional data that is not easily available in Greenhouse applications.
- Create a variety of visualizations (such as trends over time, pie charts, bar graphs, and so on)
- Slice and dice data with a variety of filters (for example, department, office, recruiter)
Technical details
What data is included with Business Intelligence Connector?
Business Intelligence Connector offers a wide variety of Greenhouse Recruiting and Greenhouse Onboarding data. Check out our Guide to Business Intelligence Connector for an overview of the data you can expect to see.
Can I choose which data appears in Business Intelligence Connector?
With Business Intelligence Connector, you can choose whether to include PII data or Greenhouse Onboarding data in your nightly ETL. Beyond this, you should use your data development tool to manage permission to your data.
Who hosts the data?
With Redshift, Greenhouse hosts the data in our Amazon Redshift instance and will provide your organization with credentials to access your data. With S3, your organization hosts and controls all the data in your own database. Learn more.
When is the data updated?
Data is synced to Amazon Redshift or S3 each night and should be complete by 10am ET | 14:00 UTC. Data will show results from the end of the previous day.
You can sign up for a completion notification so you know exactly when the data has loaded for your organization each day.
Can I modify the data in Business Intelligence Connector?
Business Intelligence Connector data is a read-only export of data. For any changes to data, update it in Greenhouse Recruiting or Greenhouse Onboarding.
Can I manage access to data in Business Intelligence Connector?
With Business Intelligence Connector, you can choose some optional tables in your nightly ETL. Beyond this, you should use your data development tool to manage access and permission to your data.
Is the data in Business Intelligence Connector backed up?
We don't create backups of Business Intelligence Connector data because Greenhouse Recruiting data is already backed up and retained for 30 days.
Can I access the files through my own S3 bucket instead of Redshift?
Yes, you can configure Business Intelligence Connector to connect to an Amazon S3 bucket that you create and manage. Your organization can then access your S3 bucket to download your files locally daily after the transfer to Amazon Redshift completes.
I'm in the EU. Is there anything I should know?
If you're working out of the EU silo on Greenhouse Recruiting, you'll only be able to access your data through the Amazon S3 option. Greenhouse does not offer Redshift in the EU silo. Learn more.
Troubleshooting
I reset my Redshift password. Why can't I access my data?
If you generate a new password for Redshift on Business Intelligence Connector, you won't be able to access your data until the next Business Intelligence Connector refresh. Data is refreshed every 24 hours.
Why is my data not showing up in Business Intelligence Connector?
If you're seeing mismatched data between Greenhouse and Business Intelligence Connector, try the following:
- Verify the time that the new data was entered. Since data is refreshed nightly, trying to view data in Business Intelligence Connector on the same day it was entered in Greenhouse Recruiting or Greenhouse Onboarding isn't possible.
- Check status.greenhouse.io to see if there's a current incident impacting updates.
- Verify with your development team that everything is functioning correctly with your data development tool and storage method.
- If you're still having issues, contact Greenhouse Technical Support.
Who should I contact if I need help?
| Issue | Contact |
| An error or technical issue in Greenhouse Recruiting or Greenhouse Onboarding | Greenhouse Technical Support |
| An organizational issue with your Greenhouse Recruiting or Greenhouse Onboarding instance (such as data being entered incorrectly) | Your organization's Site Admin |
| An error or technical issue with your data development tool | Your internal IT department or the support team for your data development tool |
| Enabling Business Intelligence Connector | Coordinate with the data analysts at your organization and use Enable Business Intelligence Connector. |