Pardot Extract Authentication Guide

Pardot Extract Authentication Guide


Overview

This is a step-by-step guide to acquiring credentials and authorising the Pardot Extract connector for use in Matillion ETL.

Important Information

  • The Pardot Extract connector uses an API token for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

Acquiring Third-Party Credentials

  1. Navigate to the Salesforce Pardot website. The Salesforce Pardot login screen will appear immediately. Enter valid login credentials to continue. The browser will then redirect to the Salesforce Pardot dashboard. Then, in the top right of the screen, click Settings.

    Salesforce Pardot dashboard

    Salesforce Pardot dashboard

  2. On the ADMINISTRATION page, click the My Profile tab.

  3. Find the API User Key and copy the code to the right as it will be required in Authorising for Use in Matillion ETL.

    My User Information

    My User Information


Authorising for Use in Matillion ETL

  1. If a Pardot Extract connector has not already been dragged onto the job canvas, search "Pardot" using the Components panel search field, or find the Pardot Extract connector under OrchestrationLoad/UnloadCRM & Marketing Automation.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Pardot Extract connector is searchable within the Components panel.

  2. Then, click and drag the Pardot Extract connector onto the job canvas.

    Search for Pardot Extract connector

    Search for Pardot Extract connector

  3. Click the connector icon on the job canvas to open the Properties panel at the bottom of the screen.

  4. Then, click ... next to the User Key input.

    Open Pardot Extract connector properties

    Open Pardot Extract connector properties

  5. In the User Key pop-up window, paste the API User key (copied from the Salesforce Pardot website earlier) into the field provided and click OK.

    Paste the API User key

    Paste the API User key

  6. If the User Key is entered correctly, the connector should be authenticated and the status of the input will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated