Enable Business Intelligence Connector

Permissions: Basic and above who can manage and configure BIC

Product tier: Available to Expert subscription tier

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'll need to enable Business Intelligence Connector in order to begin receiving your data.

Before you begin

To enable Business Intelligence Connector, you'll need to be a user who can manage and configure BIC.

Next, you'll need to decide whether to use Amazon S3 or Redshift to receive your data. Business Intelligence Connector will perform nightly ETLs to the method of your choosing. Check out Redshift vs. S3 for Business Intelligence Connector for more information on which method might best serve your organization's needs.

When you're ready, log in to Greenhouse Recruiting and click the Configure icon on your navigation bar.

Click Dev Center.

Configure page with Dev Center highlighted in marigold emphasis box

Click Business Intelligence Connector.

Dev Center page with Business Intelligence Connector highlighted in marigold emphasis box

Next, choose your ETL method.

Business Intelligence Connector page showing two ETL methods called S3 and Redshift

For S3

To enable Business Intelligence Connector for S3, click Configure beside S3.

Business Intelligence Connector for S3 showing marigold emphasis box around Configure button

Choose the AWS region for your organization from the dropdown.

Enter your S3 bucket name, and click Next.

S3 Settings showing AWS region AF-region selected from dropdown, with an example bucket name in the Bucket Name field

You'll be presented with a bucket policy. Click Copy bucket policy, then paste the policy to your S3 console.

Copy bucket policy button highlighted by a marigold emphasis box

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.

Send test file button highlighted by a marigold emphasis box

Use your S3 console to find the confirmation code, and paste it into the provided field.

Click Save and enable S3.

Save and enable S3 button highlighted in marigold emphasis box with exmaple confirmation code entered in field

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 on the EU silo or on Silo 101.

To enable Business Intelligence Connector for Redshift, click Configure beside Redshift. Redshift Business Intelligence Connector method with Configure button in marigold emphasis box

Use the toggle to enable Redshift.

Copy the Redshift credentials that appear. You'll use these to establish a connection with your data development tool.

Example Redshift credentials showing Redshift server, Redshift port, database, schema, username, and password fields

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.

An example allowlisted IP address of 123.456.789 showing in IP field with Save button highlighted in marigold emphasis box

Business Intelligence Connector will be enabled for your organization.

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 refresh. Data is refreshed every 24 hours. 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 ETLs every evening 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.