Pardot Setup Guide

Follow our setup guide to connect Pardot to Fivetran.

Prerequisites

To connect Pardot to Fivetran, you need:

See Pardot's documentation for more information on Pardot Business Unit ID and Salesforce access token.

Log in to your Pardot account.
Navigate to the drop-down menu featuring your email. In the drop-down menu, click Settings.
Navigate to Home > Administration > Account, then click My Profile.
Find the Time Zone and make a note of it. You will need it to configure Fivetran.
Find your API Version and make a note of it. If your account has the Allow Multiple Prospects with the Same Email Address (AMPSEA) feature enabled, your API version is V4. Otherwise, your API version is V3.
If you're not sure which version your account uses, see Pardot's API documentation.

Log in to your Salesforce account.
Click Settings.
On the navigation menu, click My Personal Information and select Reset My Security Token.
Click Reset Security Token. Salesforce will send you an email containing your new security token.
Check your email and make a note of the security token. You will need it to configure Fivetran.

In the connector setup form, enter your chosen Destination schema name.
Select your authentication method: OAuth or HTTP Basic.
- If you selected OAuth, click Authorize.
- If you selected HTTP Basic, enter your SSO account username, SSO account password, and Salesforce SSO Account Security Token you found in Step 2.
Enter your Pardot Business Unit ID.
(Optional) In the API Version drop-down menu, select your Pardot API version. We use this API version only to retrieve your data from the Opportunities, Prospects, TagObject, and Tags endpoints of Pardot's API.
(Optional) In the Historical Sync Limit drop-down menu, select the time range for which historical data should be synced.
(Optional) Enter your Daily API Call Limit. By default, the REST API call limit is 150,000 per day.
(Optional) Select the Time Zone you found in Step 1.
(Optional) Select the Sync External Activities if you want to sync the EXTERNAL_ACTIVITY table.
(Optional) Enter the Set up API rate limit for External Activities. By default, the API limit for the external activities endpoint is 150,000 per day. Refer to Pardot's documentation for more information on the API limits for the /external-activities endpoint.
Click Save & Test. Fivetran will take it from here and sync your Pardot data.