- Source
- Marketing Analytics
- Alpha
Move Pardot data anywhere it matters.
Send Pardot account (metadata), campaigns and custom fields to any warehouse, lake or AI app.
Source
Pardot
Snowflake
BigQuery
Postgres
Databricks
Claude
- Streams
- 33
- Destinations
- 50+
- Standard support
- 1.0.60
Overview
What is the Airbyte Pardot connector?
The Airbyte Pardot connector extracts data from Pardot and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 33 streams you can select per connection.
- 01
Sync to your warehouse
Land 33 Pardot tables in 50+ destinations on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
One authorization
Authenticate Pardot once and Airbyte keeps every scheduled sync running on it.
- 04
Cloud or self-hosted
Run the Pardot connector on Cloud, OSS, Hybrid.
33 streams
Every table you can sync from Pardot
Account (Metadata) Sync modes FullIncr. Campaigns Sync modes FullIncr. Custom Fields Sync modes FullIncr. Custom Redirects Sync modes FullIncr. Dynamic Content Sync modes FullIncr. Dynamic Content Variations (incremental parent) Sync modes FullIncr.
Setup
Live in eleven steps
First, log in to your Pardot account and navigate to the ""Settings"" tab.
Click on ""Connectors"" and then select ""Add Connector.""
Choose ""API User Key"" as the connector type and give it a name.
Generate an API user key by clicking on ""Generate User Key"" and copy it.
In Airbyte, navigate to the ""Sources"" tab and click on ""New Source.""
Select ""Pardot"" as the source type and give it a name.
Paste the API user key into the ""API User Key"" field.
Enter your Pardot username and password in the appropriate fields.
Click on ""Test Connection"" to ensure that the connection is successful.
If the test is successful, click on ""Create Source"" to save the configuration.
You can now use the Pardot source connector in Airbyte to extract data from your Pardot account.
Configuration fields
| Field | Type | Description |
|---|---|---|
| client_id* | string | The Consumer Key that can be found when viewing your app in Salesforce |
| client_secret* | string | The Consumer Secret that can be found when viewing your app in Salesforce |
| pardot_business_unit_id* | string | Pardot Business ID, can be found at Setup > Pardot > Pardot Account Setup |
| refresh_token* | string | Salesforce Refresh Token used for Airbyte to access your Salesforce account. If you don't know what this is, follow this guide to retrieve it. |
| is_sandbox | boolean | Whether or not the the app is in a Salesforce sandbox. If you do not know what this, assume it is false. |
| start_date | string | UTC date and time in the format 2000-01-01T00:00:00Z. Any data before this date will not be replicated. Defaults to the year Pardot was released. |
| v5_page_size | integer | The maximum number of records to return per request |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- Cloud
- OSS
- Hybrid
Your environment
Airbyte control plane
Related connectors
FAQ
Pardot connector questions
What data can I sync from Pardot with Airbyte?
33 streams, including Account (Metadata), Campaigns, Custom Fields, Custom Redirects, Dynamic Content, Dynamic Content Variations (incremental parent), Emails, Email Clicks (v4 API) and more.
Does the Pardot connector support incremental sync?
Yes. The Pardot connector supports incremental sync on selected streams, and full refresh on every stream.
Where can I run the Pardot connector?
Run the Pardot connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.
Didn't find your answer? Talk to sales
Start syncing Pardot in minutes.
Free 14-day trial. No credit card needed.