Follow our setup guide to connect Salesforce Marketing Cloud to Fivetran.
Prerequisiteslink
To connect Salesforce Marketing Cloud to Fivetran, you need a Salesforce Marketing Cloud account.
IMPORTANT: The Salesforce API cannot return data for business unit accounts. When you create and configure the installed package, you must log in to the parent account you want to use for your connector. We are only able to sync data for the parent account and not its business units. You can check whether your current user is assigned a business unit by following the instructions in Salesforce’s Manage Business Units documentation.
Setup instructionslink
Obtain Client ID and Client Secret link
-
Log in to your Salesforce Marketing Cloud account.
-
In the upper right corner, select your user name to open the drop-down menu, and select Setup.
-
On the left navigation pane, go to Platform Tools > Apps > Installed Packages.
-
Click New to create a new package. Enter a name and click Save.
-
Select your new package from the list of packages to go to its detail page.
-
In the Components section, select Add Component.
-
Select API Integration as your component type and click Next.
-
Select Server-to-Server as your integration type.
-
Give Read permissions to Email, OTT, Push, SMS, Social, Web, Documents and Images, Saved Content, Journeys, and List and Subscribers.
-
Click Save.
-
Find your Client ID, Client Secret, and subdomain in the Components section of your package details page. (After you create a new component, you will be taken to that page automatically.)
NOTE: Your subdomain is part of the base URIs. The URIs have the same subdomain. For example, the Authentication Base URI is in the format
https://YOUR_SUBDOMAIN.auth.marketingcloudapis.com/
. -
Make a note of your Client ID, Client Secret, and subdomain. You will need them to configure Fivetran.
Find Marketing Cloud Instancelink
-
In your Salesforce Marketing Cloud account, find your Marketing Cloud ID (MID).
-
Open the Salesforce Status page.
-
In the search box, enter your MID and perform a search. Click on the search results. Find your Marketing Cloud (Stack) instance. Make a note of it. You will need it to configure Fivetran.
Finish Fivetran Configurationlink
- In the connector setup form, enter your chosen Destination schema name.
- Enter your Salesforce Marketing Cloud Client ID and Client Secret that you found in Step 1.
- Select the Marketing Cloud Instance you found in Step 2.
- Enter your Sub-Domain that you found in Step 1.
- Set the Is Enhanced Installed Package toggle to ENABLED to indicate that your package uses OAuth 2.0.
- Click Save & Test. Fivetran will take it from here and sync your data from your Salesforce Marketing Cloud account.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration