How to enable and use the Fivetran integration

Fivetran connects with Front in minutes to enable you to build a fully managed and zero-maintenance data pipeline between Front and your cloud data warehouse, like Amazon Redshift. Sync your Front data to your data warehouse to gain deep insights into your business and customer experience by joining Front data with CRM, payment, and other customer data in your BI tool of choice.

Like other integrations, you need to be a Front admin to set up the Fivetran integration. Your Front plan must also include API access, like our current Premium and Enterprise plans. 

Step 1

Log into your Fivetran account. If you don't already have a Fivetran  account, you can sign up here.

Step 2

Choose the Front integration from the integrations list in Fivetran to start the setup wizard.

Step 3

In the setup wizard, fill in your desired schema name, like "front", and provide your API token (JSON Web Token).

You will need to generate an API Token from your Front settings here:
https://app.frontapp.com/settings/tools/api. Click "New Token", then create a token with the "Shared resources" scope.

Step 4

After pasting your API token in the Fivetran wizard, click Save & Test.  Fivetran will take it from here!

Now, you're ready to start leveraging your Front data in your cloud data warehouse. Here is the detailed schema chart to help you get started with queries:

If you have any questions or issues with the Fivetran integration and setup, please reach out to Fivetran's support team.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 1 mth agoLast active
  • 177Views
  • 1 Following

Welcome to the Front community!

The Front community is your place to come together and discuss the product, register for webinars, and get support from our help center.

Webinars

New to Front or need to refresh your skills? Join us for live training sessions every week! Check them all out here.

If at any point you need assistance, please don't hesitate to email us: team@frontapp.com.