Fivetran is a technology company that develops a SaaS data integration service for companies to extract, transform and load data from different sources into data warehouses.

Greenhouse Recruiting's integration with Fivetran allows you to sync your Greenhouse Recruiting data to Fivetran.

In this article:

Configure setup permissions in Greenhouse Recruiting

To configure the Greenhouse Recruiting / Fivetran integration, you’ll need the developer permission Can manage ALL organization’s API Credentials. To assign this permission, find a Greenhouse user in your organization with Site Admin level permissions and the specific Can edit another user's advanced permissions to update your account. This permission can be updated by navigating to the user page on Configure Icon_-_Configure.png icon > Users > Your Name.

Configure_-_Users_Master.png

Have the Site Admin scroll to the User-Specific Permissions panel on your user page and expand the Developer Permissions dropdown menu. Select Can manage ALL organization’s API credentials in the Developer Permissions section and click Save.

Repeat as necessary for any other user that needs to set up the integration.

Create a Harvest API key for the Greenhouse Recruiting / Fivetran integration

Note: To generate an API key, you must have the developer permission Manage ALL organization's API Credentials. 

Click on the Configure Icon_-_Configure.png icon and select the Dev Center on the left panel.

Configure_-_Dev_Center.png

Select API Credential Management.

API_Credential_Manager_Annotated.png

From the API Credential Management page, click Create New API Key to generate the API key for Fivetran.

Create_new_API_key.png

In the Create New Credential dialog box, make the following selections:

  • API Type: Harvest
  • Partner: N/A
  • Description: Fivetran Harvest API Key

Click Manage Permissions.

Click Copy to save your API key to your clipboard. Store the API key in a secure location to provide to Fivetran in a later step.

Copy_API_key.png

Click I have stored the API Key once you have copied and saved the key.

I_have_stored_the_API_key.png

Note: You won’t be able to view the API key after clicking I have stored the API Key. If you lose your API key or need to access it later, you’ll need to generate a new key and provide it to Fivetran.

The following permissions are needed for the Greenhouse Recruiting / Fivetran integration:

  • Candidates
  • Job Stages
  • Job Openings

When you’re finished, click Save. Your Harvest API key for the Greenhouse / Fivetran integration is created and configured to enable in a later step.

Enable the Greenhouse Recruiting / Fivetran integration

To enable the Greenhouse Recruiting / Fivetran integration, visit Fivetran's connector setup form and copy / paste the API Key from the previous step.

Note the endpoint URL and secret key provided on the connector setup form for the next setup step.

Create web hooks for the Greenhouse Recruiting / Fivetran integration

To configure the Greenhouse Recruiting / Fivetran integration, you'll need to generate web hooks in Greenhouse Recruiting.

Select Configure Icon_-_Configure.png icon from any Greenhouse Recruiting page, then select Dev Center on the left.

Configure_-_Dev_Center.png

Select Web Hooks, then click Web Hooks again.

Dev_Center_-_Web_Hooks_-_Web_Hooks-Annotated.png

On the Create a new Web hook page, enter a name for your webhook.

In the When drop-down menu, select the event type you want to capture.

Use Fivetran's connector setup form to enter a secret key and endpoint URL.

Click Create web hook.

Use the above steps to create the following event web hooks (with the same endpoint URL and secret key):

  • APPLICATION CREATED
  • APPLICATION DELETED
  • CANDIDATE HIRED
  • CANDIDATE MERGED
  • CANDIDATE STAGE CHANGED
  • CANDIDATE UNHIRED
  • CANDIDATE REJECTED
  • CANDIDATE UNREJECTED
  • CANDIDATE DELETED
  • DEPARTMENT DELETED
  • INTERVIEW DELETED
  • JOB CREATED
  • JOB UPDATED
  • JOB DELETED
  • JOB POST DELETED
  • JOB STAGE DELETED
  • OFFER CREATED
  • OFFER UPDATED
  • OFFER DELETED
  • OFFICE DELETED
  • SCORECARD DELETED

The Greenhouse Recruiting / Fivetran integration is now configured and setup.

Additional resources

Find more information about the Greenhouse Recruiting / Fivetran integration on Fivetran's site: Greenhouse Recruiting <> Fivetran setup guide.

Fivetran syncs Greenhouse Recruiting data created on January 1, 2012 and later.

Reference the following schema from Fivetran for more information on the integration: Greenhouse Recruiting <> Fivetran schema information.

For additional information not covered here, reach out to Fivetran sales.