Follow our setup guide to connect Iterable to Fivetran.
Prerequisiteslink
To connect Iterable to Fivetran, you need an Iterable account.
IMPORTANT: Only use an HTTPS URL with TLS version 1.2 or above.
Setup instructionslink
Find webhook URLlink
Make a note of the automatically-generated URL at the bottom of your connector setup form. You will need to register this webhook URL in Iterable.
Generate an API Keylink
-
Log in to the Iterable Dashboard.
-
In the top menu bar, select Integrations -> API keys. This will open the API keys dashboard.
-
Click + CREATE NEW API KEY.
-
Enter the API key name.
-
Choose Server-side as the API key type to sync all the tables.
NOTE: If you choose Read-only as the API key type, Fivetran can’t sync the following tables:
EVENT
EVENT_EXTENSION
USER_HISTORY
USER_UNSUBSCRIBED_CHANNEL_HISTORY
LIST_USER_HISTORY
USER_DEVICE_HISTORY
USER_UNSUBSCRIBED_MESSAGE_TYPE_HISTORY
-
Click Create.
-
Make a note of the API key. You will need it to configure Fivetran.
Register Webhook URLlink
-
Return to the main Iterable Dashboard.
-
In the top menu bar, select Integrations -> System webhooks. This will open the System Webhooks Dashboard.
-
Click + CREATE WEBHOOK. This opens a pop-up window.
-
Enter the webhook URL you found in Step 1 in the Endpoint URL field.
-
Select No Auth as the Auth Type.
-
Click Create Webhook.
-
Once the webhook is created, scroll to the right and click Edit.
-
Select Enabled, then select all the events that you want to sync.
NOTE: If you do not register the webhook URL, Fivetran can’t sync the
EVENT
andEVENT_EXTENSION
tables.
Finish Fivetran Configurationlink
-
Enter your chosen destination schema name in the connector setup form.
-
Enter the API key that you generated in Step 2.
-
Click Save & Test. Fivetran will take it from here and sync your Iterable data.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration