Business Intelligence Connector provides additional insight into an organization's Greenhouse data and is designed for companies with robust analytics and business intelligence requirements.
You need to enable Business Intelligence Connector in order to receive your data.
Before you begin
You need to be a Greenhouse Recruiting user who can manage and configure BIC.
Next, decide whether to use Amazon S3 or Redshift to receive your data. Business Intelligence Connector will perform a nightly ETL to the method of your choosing.
Tip: Check out Redshift vs. S3 to see which might best serve your organization's needs.
Enable Business Intelligence Connector
When you're ready, log in to Greenhouse Recruiting and click the Configure icon on your navigation bar.
Click Dev Center.
Click Business Intelligence Connector.
Next, choose your ETL method.
You can enable Business Intelligence for S3 or for Redshift.
For S3
To enable Business Intelligence Connector for S3, click Configure beside S3.
Choose the AWS region for your organization from the dropdown.
Enter your S3 bucket name, and click Next.
Click Copy bucket policy, then paste the policy to your S3 console.
Tip: Read more about using bucket policies with your S3 console in the AWS User Guide.
Click Send test file, and Greenhouse Recruiting will place a test file in the bucket you provided.
Use your S3 console to find the confirmation code, and paste it into the Confirmation code field.
Click Save and enable S3.
Business Intelligence Connector will be enabled for your organization.
You can now manage Business Intelligence Connector settings that determine which data is delivered in your ETL.
For Redshift
Note: Redshift is not available for organizations in the EU or on Silo 101.
To enable Business Intelligence Connector for Redshift, click Configure beside Redshift.
Use the toggle to enable Redshift.
Copy the Redshift credentials that appear to a secure location. You'll use these to establish a connection with your data development tool later.
Next, enter the IP addresses to allowlist access to your Business Intelligence Connector data.
Tip: Read more about allowlisting IPs for data security here.
When finished, click Save.
Business Intelligence Connector will be enabled for your organization.
In your data development tool, create a new connection to Redshift using the details you copied.
Note: If you generate a new password for Redshift access, you won't be able to access your data until the next Business Intelligence Connector ETL, which occurs once per day. Learn more.
You can now manage Business Intelligence Connector settings that determine which data is delivered in your ETL.
Use Business Intelligence Connector
Once enabled, Business Intelligence Connector will deliver a nightly ETL with your most up-to-date data. You can use data development tools to perform complex analyses of your organization's processes.
Check out the following resources for more information on what to expect in your ETL:
- Data schema: Use our latest Business Intelligence Connector schema to understand the expected tables and columns in your ETL.
- Entity relationship diagram. Use our ERD to understand the relationships between data in your ETL.
- Business Intelligence Connector settings. Use Business Intelligence Connector settings to manage error notifications, as well as to configure additional private candidate data (PII) to be delivered with your ETL.