Marketo¶
Marketo is SaaS based marketing automation software built to help organizations automate and measure marketing engagement, tasks and workflows.
It is possible to configure Denodo to retrieve data from Marketo by creating JSON data sources and base views using the Marketo REST API.
As Marketo manages a very large amount of data and views, it may be hard work to add all the required data sources and base views in Denodo. To make this process easier and faster, you have available a Marketo wizard. You just have to configure a few parameters and click on Import to create into your Denodo server the needed data sources and views to get access to the following functionalities of Marketo:
Leads
Activities
campaigns
Custom objects
Named Accounts
Lists
Static Lists
Smart Lists
Programs
Tag Type
Channel
Segments
Importing Artifacts¶
To create the Marketo views, click the menu File > New > Data source and select Marketo.
Marketo wizard¶
Enter the following parameters:
Database. Name of the database in which the Marketo views will be created.
Client ID. The client id provided by your Marketo instance.
Client Secret. The client secret provided by your Marketo instance.
Scope . The Marketo user with API access permissions.
Marketo instance. Your Marketo instance.
Now, click Execute import to create the data sources and the views to query Marketo.
Important
The set of Stored Procedures included are used by final views and are in charge of the task of asking for new access tokens when the older ones expire. So, ONLY the FINAL VIEWS are meant to be directly used.
Marketo views¶
activity. Returns a list of activities of type given by the
activity_type_idparameter from after a date time given by thesince_date_timeparameter.campaign. Returns a list of smart campaign records.
custom_object. Returns a list of custom objects records based on filter and set of values.
named_account. Retrieves named account records from your Marketo instance based on the submitted filter.
named_account_list. Retrieves a list of named account list records based on the filter type and values given.
lead Returns a list of up to 300 leads based on a list of values in a particular field.
list Returns a set of static list records.
smartlists. Retrieves a list of user created Smart List records.
staticlist. Retrieves a list of Static List records.
program Retrieves the list of accessible programs from your Marketo instance.
tag_type. Retrieves a list of available tag types.
channel Retrieves all channels.
segment. Retrieves a list of accessible segmentation for your Marketo instance.
