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.

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

To configure the Greenhouse Recruiting / Fivetran integration, you'll need to create a Harvest API key.

Follow the steps in this article to create the key, and verify that the credentials and permissions below are selected when configuring the Fivetran integration.

Credentials

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

  • API type: Harvest
  • Partner: Fivetran
  • Description: Fivetran Harvest API Key

Permissions

Verify that the following permissions are selected for the Fivetran integration:

  • Candidates
  • Job stages
  • Job openings

Provide the Harvest API key to Fivetran

To enable the Greenhouse Recruiting / Fivetran integration, visit Fivetran's connector setup form and paste the Harvest API key.

Copy the endpoint URL and secret key provided on the connector setup form. You will use this information on the next step when creating your web hooks. 

Create web hooks for the Greenhouse Recruiting / Fivetran integration

To integrate Fivetran with Greenhouse Recruiting, you'll need to create a web hook. Follow the steps in this article to create your web hook. Use the values listed below to configure the web hook:

Use the values listed below to configure the web hook:

  • Name: Fivetran integration
  • When: The time that the event will be sent to Fivetran. Select the following options for this integration. A webhook needs to be created individually for each event. 
    • 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
  • Endpoint URL: Use Fivetran's connector setup form to enter the endpoint URL.
  • Secret Key: Use Fivetran's connector setup form to enter the secret key 

The Greenhouse Recruiting / Fivetran integration is now configured and set up.

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

Additional resources

For more information about the Greenhouse Recruiting / Fivetran integration, visit Fivetran's Greenhouse Recruiting <> Fivetran setup guide or review the Greenhouse Recruiting <> Fivetran schema.

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