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 > Users > Your Name.
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 and select the Dev Center on the left panel.
Select API Credential Management.
From the API Credential Management page, click Create New API Key to generate the API key for Fivetran.
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.
Click I have stored the API Key once you have copied and saved the key.
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 from any Greenhouse Recruiting page, then select Dev Center on the left.
Select Web Hooks, then click Web Hooks again.
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.