Marketo Integration Database Management Flow | Community
Skip to main content
New Participant
May 28, 2021
Question

Marketo Integration Database Management Flow

  • May 28, 2021
  • 1 reply
  • 2821 views

Hi All,

I have just gone through the API's and completely new to this Product and I want to understand the complete Database Architecture of Marketo Application as we want to integrate this Product in our application through REST API. So, need depth knowledge on the flow of Data (How Primary or Foreign Key can be referred). How the data flows and what's the best way of understanding Marketo Application. 

 

We also need to know which API is been mapped to which Flow and how we can know the dependencies and Lineage of it. What's the best Practice to integrate Marketo through REST API. I already did basic steps like adding users generating Token and accessing data through API and sending Scheduled email through Engagement Program.  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Katja_Keesom
Community Manager
May 28, 2021

Wow, Abhishek,

That is a big question you ask there. It sounds like you know your way around APIs and integrations in general. Did you already check out de developer pages of Marketo? These can be found here: https://developers.marketo.com/

As for the database architecture, there's really a few core components:

  • The Person object (still called Leads in the API) is pretty much at the heart of the UI. This table generally associates with both Leads and Contacts in your CRM. The unique key is the Lead Id.
  • The person is linked to the Company object with the External Company Id as a unique key.
  • A link with the Opportunity object is made from the Person via a background object called Opportunity Role. It has a unique key called External Opportunity Id and can also be directly associated with the Company.
  • The fourth main element in Marketo is the Activities table, logically associated with the Person.
  • Via the API you can also access individual Programs and Assets.

You can add multiple Custom Objects and Custom Activities to accomodate other data sets like transactional data.

I hope this gives you a good start.

 

Kind regards,

Katja

New Participant
May 28, 2021

Hi @katja_keesom

Thanks for your response and you have cleared my most of the doubts but still more details I wanted to get started with Marketo.
Yes, I have tried the link which you have send and wanted to know more about the Architecture. 

Katja_Keesom
Community Manager
May 31, 2021

Hi Abhishek,

When setting up your integration I would suggest to enlist the support of an expert so you can be sure it is set up in the best way possible for your use case. That is a bit more than you can do with a simple conversation on the community.

Kind regards,

Katja