Iterable Setup Guide

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.

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.

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.

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 and EVENT_EXTENSION tables.

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.