Permissions: Basic users and above who can manage and configure BIC

Product tier: Available to Expert subscription tier

You can configure various notification and data transfer settings for Business Intelligence Connector.

Manage Business Intelligence Connector settings

Note: You need the developer permission 'manage and configure BIC' to access Business Intelligence Connector settings. Site Admin can assign this permission to people under Configure > Users. Learn more.

To manage Business Intelligence Connector settings, click the Configure icon on your navigation bar, then click Dev Center on the left.

On the Configure page, the Dev Center button highlighted in marigold emphasis box

Click Business Intelligence Connector.

Business Intelligence Connector button highlighted in marigold emphasis box

Click Edit beside Settings.

Business Intelligence Connector settings button highlighted in marigold emphasis box

You can configure the following settings for Business Intelligence Connector:

Upload status notification

You can configure an automatic notification email to be delivered to a designated address when your ETL completes, or if the ETL has not been completed by a specified time.

Enter the notification recipient and define a notification time if needed.

Business Intelligence Connector settings button shows email address and notification time highlighted in marigold emphasis boxes

Note: Status notification times are in UTC. Greenhouse expects ETLs to complete daily by 14:00 UTC.

When finished, click Save.

Include additional optional tables

You can also include additional optional tables in your ETLs.

Check the box beside each table you'd like to include in your data.

Business Intelligence Connector shows additional tables to include

Check out more information on each option:

Candidate phone number Enable this setting to create an additional candidate_phone_numbers table in your ETL, where each row represents a single phone number and the associated candidate.
Candidate email address Enable this setting to create an additional candidate_email_addresses table in your ETL, where each row represents a single email address and the associated candidate.
Candidate mailing address Enable this setting to create an additional table candidate_mailing_addresses in your ETL, where each row represents a single mailing address and the associated candidate.
Data from Greenhouse Onboarding

Enable this setting to create additional Greenhouse Onboarding tables in your ETL. The following tables will be included if enabled:

  • gho_assigned_tasks

  • gho_custom_field_values

  • gho_custom_fields

  • gho_employee_roles

  • gho_employees

  • gho_roles

  • gho_user_activities

Check out this article for more information on what to expect in each Greenhouse Onboarding table.

Note: Only Greenhouse Onboarding customers will see an option to enable data from Greenhouse Onboarding.

When finished, click Save.

Additional resources