Stripe Setup Guide
Follow our setup guide to connect Stripe to Fivetran.
Prerequisites
To connect Stripe to Fivetran, you need access to an active Stripe account with Administrator or Developer privileges.
Setup instructions
Create API key
Depending on the resources you want to sync, create one of the following API keys to authenticate your Stripe API requests:
Restricted API key - Restricted API keys allow you to limit the permissions for different resources. Create this key if you want to sync any resource except the one mentioned below.
Standard API key - Standard API keys provide both Read and Write permissions to all resources. Create this key only if you want to sync the following resource along with other resources:
Create restricted API key
Log in to your Stripe dashboard.
To ensure you are logged in to the correct account, verify the account name displayed in the top left corner of the dashboard.
Click the Settings icon and select Developers.
In the API keys section, click Manage API keys.
Go to the Restricted keys section and click + Create restricted key.
Select Providing this key to a third-party application and click Continue.
Enter a Name for your API key.
In the URL field, enter
https://fivetran.com.Select the Customise permissions for this key checkbox and click Continue.
Grant Read permission to the resources required for your API key.
Be sure to grant Read permission to all Connect-type resources to sync data from connected accounts.
Click Create key > Send verification.
Open your email and click Verify identity.
In Stripe, enter the verification code you received and click Continue.
Make a note of the restricted API key. You will need it to configure Fivetran.
Create standard API key
Log in to your Stripe dashboard.
To ensure you are logged in to the correct account, verify the account name displayed in the top left corner of the dashboard.
Click the Settings icon and select Developers.
In the API keys section, click Manage API keys.
Go to the Standard keys section and click + Create secret key.
Select Powering an integration you built and click Create secret key.
Click Send verification.
Open your email and click Verify identity.
In Stripe, enter the verification code you received and click Continue.
Enter a Key name for your API key.
Click Create.
Make a note of the standard API key. You will need it to configure Fivetran.
Finish Fivetran configuration
In the connection setup form, enter the Destination schema name of your choice.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.
Enter the API KEY you created.
(Optional) To sync Connected Accounts, set the Sync Connected Accounts toggle to ON.
In the Historical Sync Time Frame drop-down menu, select the amount of historical data you want to include in your initial sync:
- Select Sync all historical data to sync all available historical data from your source.
- Select Sync data from selected date and choose a date in the Historical Sync Start Date field to limit the historical data synced for certain tables. This approach speeds up the initial sync. For a list of eligible tables, see our Stripe connector historical sync time frame documentation.
Click Save & Test. Fivetran will take it from here and sync your data from your Stripe account.