Iterable Setup Guide

Follow our setup guide to connect Iterable to Fivetran.

Prerequisites

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 your 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: We do not support the Read-only API key type in connectors created after August 10, 2023. Also, connectors created before August 10, 2023 cannot sync the following tables if you chose Read-only as the key type:
- 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.

Find your Iterable account's region in your Iterable account URL and make a note of it.

If your account URL begins with https://app.iterable.com/, then your region is US.
If your account URL begins with https://app.eu.iterable.com/, then your region is EU.

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.

In the connector setup form, enter your chosen Destination schema name.
Enter the API Key you generated in Step 2.
Select the Account Region you found in Step 3.
Choose your Sync Mode: Sync All Events or Sync Selected Events. If you choose Sync Selected Events, you can:
- select the Events you want to sync.
- select the Custom Event sync strategy:
  - Sync All Custom Events
  - Do not sync Custom Events
  - Sync Selected Custom Events. (Optional) In the Custom Event drop-down menu, select the custom events.
TIP: For information about syncing events and custom events, see our documentation.
(Optional) In the Historical Sync Time Frame drop-down menu, select the range of historical data you want to include in your initial sync.
Click Save & Test. Fivetran will take it from here and sync your Iterable data.