I need to build an analytics application in top of the data available in Marketo.
For that I want to replicate the Marketo data into a local database (Sql Server/Oracle, etc.) so I can use that info in a simpler way.
Any suggestions on how to accomplish this.
I was planning in using the REST API for getting all the new activities and activity attributes and I can't foreseen an issue there, however when getting the lead data, getting the updated leads will not do the job I think because I'll still keep delete/merged leads.
Any suggestion on how to overcome this or on how to implement a different replication mechanism.