Pardot OP DEZE PAGINA
Pardot is a marketing automation solution that enables marketers to identify prospective customers that are most likely to convert.
Pardot integration replicates data using the Pardot API .
See the
Schema section for a list of objects available for replication.
Momentopname functie Een beknopt overzicht van deze connector, inclusief nuttige koppelingen en ondersteunde functies.
Functie/mogelijkheden Ondersteuningsdetails Ondersteunde Qlik Talend Data Integration -projecten Alleen replicatieprojecten . Gegevenspijplijnprojecten worden niet ondersteund. Bijwerkmethoden doel
Replicatietaken:
Wijzigingen toepassen
Wijzigingen opslaan
Gegevens tijdelijk opslaan in een datalaketaak:
Metagegevens beheren
Handmatig metagegevens genereren is niet nodig. Schema-evolutie
Alleen de bewerking Type kolomgegevens wijzigen wordt ondersteund. Replicatie van LOB-kolommen (NCLOB, CLOB en BLOB) Niet ondersteund. Gepland CDC Vereist. Zo wordt het doel up-to-date gehouden met wijzigingen in de bron.
Voor replicatietaken raadpleegt u Taken plannen
Voor tussenopslagtaken voor lake, raadpleegt u CDC plannen voor tussenopslagtaken in lake
Meldingen Gedeeltelijk ondersteund
Meldingen instellen voor wijzigingen van de bewerking
Bewaking Alleen CDC, omdat volledige lading niet relevant is voor deze connector.
Een afzonderlijke gegevenstaak bewaken
Automatisch denesten van nettoladingen van JSON-kolommen Niet ondersteund. Nettoladingen van JSON-kolommen in brongegevensverzamelingen worden niet automatisch gedenest op het doel.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informatie Zorg dat het account dat u gebruikt leestoegang heeft voor de tabellen die u wilt ophalen.
To retrieve your business unit ID:
Log into your Salesforce account. Navigate to Setup . Search for Pardot in the Quick Find box. Copy and paste your business unit ID into a secured file. To retrieve your consumer key and secret:
Log into your Salesforce account. Navigate to Setup . Search for App Manager in the Quick Find box. Go to your connected app and select View . Copy and paste your consumer key into a secured file. Click Click to reveal to show your consumer secret and copy it. Creating the connection For more information, see Verbinding maken met SaaS-applicaties
Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify .
Tip You may need to scroll down to see this field.
When status is Verified , the authentication is verified.
Provide a name for the connection in Connection name .
Select Open connection metadata to define metadata for the connection when it has been created.
Connection settings Setting Description Data gateway
Selecteer een Data Movement gateway als dit is vereist voor uw usecase.
Informatie Dit veld is niet beschikbaar met het Qlik Talend Cloud Starter -abonnement, omdat het geen ondersteuning biedt voor Data Movement gateway . Als u een ander abonnementsniveau hebt en Data Movement gateway niet wilt gebruiken, selecteer dan Geen .
Raadpleeg Qlik Gegevensgateway - Gegevensverplaatsing Data Movement gateway en usecases waarvoor deze is vereist.
Start Date Voer de datum in, in het formaat MM/DD/YYYY, vanaf wanneer de gegevens van uw gegevensbron naar uw doel moeten worden gerepliceerd.
Pardot Business Unit ID Business unit ID.
Consumer Key A unique identifier for the connected app.
Consumer Secret A password for the connected app.
Informatie Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
campaigns
The campaigns table contains info about the campaigns in your Pardot account.
campaigns table foreign keys Join campaigns with on opportunities campaigns.id = opportunities.campaign_id prospects campaigns.id = prospects.campaign_id
campaigns table schema
cost
INTEGER
id
INTEGER
name
STRING
email_clicks
The email_clicks table contains info about email click events.
email_clicks table foreign keys Join email_clicks with on visitor_activities email_clicks.email_template_id = visitor_activities.email_template_id email_clicks.list_email_id = visitor_activities.list_email_id email_clicks.prospect_id = visitor_activities.prospect_id list_memberships email_clicks.prospect_id = list_memberships.prospect_id prospects email_clicks.prospect_id = prospects.id visits email_clicks.prospect_id = visits.prospect_id
email_clicks table schema
created_at
DATE-TIME
drip_program_action_id
INTEGER
email_template_id
INTEGER
id
INTEGER
list_email_id
INTEGER
prospect_id
INTEGER
tracker_redirect_id
INTEGER
url
STRING
list_memberships
The list_memberships table contains info about list memberships.
Note : To replicate this table, the lists
list_memberships table foreign keys Join list_memberships with on lists list_memberships.list_id = lists.id email_clicks list_memberships.prospect_id = email_clicks.prospect_id prospects list_memberships.prospect_id = prospects.id visitor_activities list_memberships.prospect_id = visitor_activities.prospect_id visits list_memberships.prospect_id = visits.prospect_id
list_memberships table schema
created_at
DATE-TIME
id
INTEGER
list_id
INTEGER
opted_out
INTEGER
prospect_id
INTEGER
updated_at
DATE-TIME
lists
The lists table contains info about the lists in your Pardot account.
lists table schema
created_at
DATE-TIME
description
STRING
id
INTEGER
is_crm_visible
BOOLEAN
is_dynamic
BOOLEAN
is_public
BOOLEAN
name
STRING
title
STRING
updated_at
DATE-TIME
opportunities
The opportunities table contains info about the opportunities in your Pardot account.
opportunities table foreign keys Join opportunities with on campaigns opportunities.campaign_id = campaigns.id prospects opportunities.campaign_id = prospects.campaign_id
opportunities table schema
campaign_id
INTEGER
closed_at
DATE-TIME
created_at
DATE-TIME
id
INTEGER
name
STRING
probability
INTEGER
stage
STRING
status
STRING
type
STRING
updated_at
DATE-TIME
value
NUMBER
prospect_accounts
The prospect_accounts table contains info about prospect accounts.
prospect_accounts table foreign keys Join prospect_accounts with on users prospect_accounts.assigned_to.user.id = users.id
prospect_accounts table schema
assigned_to
OBJECT
This is a nested data structure:
user: OBJECT, which is also a nested data structure.
account: INTEGER created_at: DATE-TIME email: STRING first_name: STRING id: INTEGER job_tile: STRING last_name: STRING role: STRING updated_at: DATE-TIME
created_at
DATE-TIME
id
INTEGER
name
STRING
updated_at
DATE-TIME
prospects
The prospects table contains info about the prospects in your Pardot account.
prospects table foreign keys prospects table schema
address_one
STRING
address_two
STRING
annual_revenue
STRING
campaign_id
INTEGER
city
STRING
comments
STRING
company
STRING
country
STRING
created_at
DATE-TIME
crm_account_fid
STRING
crm_contact_fid
STRING
crm_last_sync
DATE-TIME
crm_lead_fid
STRING
crm_owner_fid
STRING
crm_url
STRING
department
STRING
email
STRING
employees
STRING
fax
STRING
first_name
STRING
grade
STRING
id
INTEGER
industry
STRING
is_do_not_call
BOOLEAN
is_do_not_email
BOOLEAN
is_reviewed
BOOLEAN
is_starred
BOOLEAN
job_title
STRING
last_activity_at
DATE-TIME
last_name
STRING
notes
STRING
opted_out
BOOLEAN
password
STRING
phone
STRING
prospect_account_id
INTEGER
recent_interaction
STRING
salutation
STRING
score
INTEGER
source
STRING
state
STRING
territory
STRING
updated_at
DATE-TIME
website
STRING
years_in_business
STRING
zip
STRING
users
The users table contains info about the users in your Pardot account.
users table schema
created_at
DATE-TIME
email
STRING
first_name
STRING
id
INTEGER
job_title
STRING
last_name
STRING
role
STRING
updated_at
DATE-TIME
visitor_activities
The visitor_activities table contains info about visitor activities.
visitor_activities table foreign keys Join visitor_activities with on email_clicks visitor_activities.email_template_id = email_clicks.email_template_id visitor_activities.list_email_id = email_clicks.list_email_id visitor_activities.prospect_id = email_clicks.prospect_id list_memberships visitor_activities.prospect_id = list_memberships.prospect_id prospects visitor_activities.prospect_id = prospects.id visits visitor_activities.prospect_id = visits.prospect_id visitor_activities.visitor_id = visits.visitor_id visitors visitor_activities.visitor_id = visitors.id
visitor_activities table schema
campaign
OBJECT
This is a nested data structure.
campaign_id
INTEGER
created_at
DATE-TIME
details
STRING
email_id
INTEGER
email_template_id
INTEGER
file_id
INTEGER
form_handler_id
INTEGER
form_id
INTEGER
id
INTEGER
landing_page_id
INTEGER
list_email_id
INTEGER
multivariate_test_variation_id
INTEGER
paid_search_id_id
INTEGER
prospect_id
INTEGER
site_search_query_id
INTEGER
type
INTEGER
type_name
STRING
updated_at
DATE-TIME
visitor_id
INTEGER
visitor_page_view_id
INTEGER
visitors
The visitors table contains info about visitors.
visitors table foreign keys visitors table schema
campaign_parameter
STRING
content_parameter
STRING
created_at
DATE-TIME
hostname
STRING
id
INTEGER
ip_address
STRING
medium_parameter
STRING
page_view_count
INTEGER
source_parameter
STRING
term_parameter
STRING
updated_at
DATE-TIME
visits
The visits table contains info about visits.
Note : To replicate this table, you must also set the visitors
visits table foreign keys Join visits with on email_clicks visits.prospect_id = email_clicks.prospect_id list_memberships visits.prospect_id = list_memberships.prospect_id prospects visits.prospect_id = prospects.id visitor_activities visits.prospect_id = visitor_activities.prospect_id visits.visitor_id = visitor_activities.visitor_id visitors visits.visitor_id = visitors.id
visits table schema
campaign_parameter
STRING
content_parameter
STRING
created_at
DATE-TIME
duration_in_seconds
INTEGER
first_visitor_page_view_at
DATE-TIME
id
INTEGER
last_visitor_page_view_at
DATE-TIME
medium_parameter
STRING
prospect_id
INTEGER
source_parameter
STRING
term_parameter
STRING
updated_at
DATE-TIME
visitor_id
INTEGER
visitor_page_view_count
INTEGER
visitor_page_views
OBJECT
This is a nested data structure:
visitor_page_view: ARRAY, which is also a nested data structure.
created_at: DATE-TIME id: INTEGER title: STRING url: STRING
