How can we extract entire Marketo Database? | Community
Skip to main content
Level 2
June 1, 2021
Question

How can we extract entire Marketo Database?

  • June 1, 2021
  • 1 reply
  • 3293 views

Hi All,

I want to extract complete Database of Marketo to store that data in our MySql Database for some processing. Is there any way we can extract complete Marketo Database?

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

1 reply

SanfordWhiteman
Level 10
June 1, 2021

Entire? No. The API docs show you what's accessible (of course not in native binary database form but in serialized CSV and/or JSON).

 

There are numerous data sources used by the platform that can't be extracted — this is the case, of course, with all proprietary SaaS platforms, and nearly all hosted platforms in general! An API, by definition, abstracts some of the internal workings of a platform using a standardized set of contracts. But you're not accessing the databases themselves.*

 

As the docs describe, you can bulk download activity logs using the Bulk Activity Log API, people using the Bulk Lead Extract API, and custom objects using the Bulk CO Extract API.

 

Several other structural components, like Programs and Tags, can also be extracted using the REST API, although those use paginated JSON endpoints (rather than all-at-once file downloads). And of course all the Asset types listed in the docs can be crawled as well. Yet you mustn't mistake all of this for "extracting the complete Marketo database(s)."

 

 

* the exception would be the database backup API itself, I suppose,

though even a database wire protocol like TDS is consuming an API

Level 2
June 1, 2021

Hi @sanfordwhiteman , 
Thanks for your response okay I got it. Can you give me more details about Marketo Database Architecture as it would be more helpful for me to understand and which is the best Database to store for Marketo Data after extracting from API's.

SanfordWhiteman
Level 10
June 1, 2021

Responding in your new thread.

 

Please take care to not ask the same question in multiple places, thanks.