Marketo DataBase Architecture | Community
Skip to main content
A
abhishek_c
Level 2
June 1, 2021
Question

Marketo DataBase Architecture

  • June 1, 2021
  • 1 reply
  • 8370 views

Hi All,
I want to get 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 as we need to perform some operation after extracting the data from Marketo.

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
SanfordWhiteman
Level 10
June 1, 2021

The best database to use — to reuse the saying about programming languages— is the database you know.

 

Well... at least that's mostly true in this case.

 

If you have mastery of MySQL/MariaDB, or Postgres, or SQL Server, those will be OK. But you will have to tune queries for your workload (and we have no idea what that is).

 

I prefer to store Activity Logs in a timeseries database like InfluxDB, not in a standard RDBMS. Recently, for one project that concentrates on Custom Objects, I chose CouchDB, since JSON objects/documents fit the CO model. A wide and deep Marketing Activities tree structure should be stored in a hierarchical database for best performance, or use the MSSQL HIERARCHY type.

 

There isn't a single correct answer here.

    A
    abhishek_cAuthor
    Level 2
    June 1, 2021

    I want to understand how we are storing Data in Marketo Database is it in Table column like MySql or other?

    Jo_Pitts1
    Community Advisor
    Jo_Pitts1Community Advisor
    Community Advisor
    June 2, 2021

    @abhishek_c , to a large extent, how data is stored in Marketo is immaterial.  It is what it is what it is.

     

    I think you need to define your requirements a lot more clearly. 

     

    Is it to get all new/changed leads out on a regular basis, along with their activities, and all ancillary campaign details, and store these in a DB for reporting purposes? 

     

    If so, pick a DB you know well, and use it.

     

    If the question is 'How do I get this data out of Marketo' then it is a longer question.  Many of us have built code to do this already in a variety of languages.

     

    Cheers

    Jo

     

      Terms & ConditionsAccessibility statement

      Loading footer...