Daily Lead data from Marketo to a SQL Server table

[Anonymous]

Ive been able to get data to move from Marketo via SOAP in Informatica to a flat file and to SQL Server..

What i need to do is grab daily  ( or all? ) leads from Marketo to sql server table.

Where can i get a copy of the Schema of the Lead Table so i can create a matching structure in SQL?

do i want to update the Leads daily, or get the full download nightly?

[Anonymous]

Hello Alex,

I would recommend reaching out to your CAM or Services to see if they can provide you the Schema.  There is not a tool in your instance currently to pull your DB table schema.  They should have a way to pull the query and port that Schema into a file that you could then run on your CREATE TABLE command.  Not sure who that request would go to in the end, but I assume this would be possible.

Hope that helps.

[Anonymous]

Hi,

I have no idea what “your CAM or Services” means. lol

I was tossed this project, and wading through some new concepts and terminology.

[Anonymous · Accepted solution]

Sorry about that, CAM = Customer Account Manager (the person who helps out when you need to renew, etc).  Services is our professional services team who reside at the alias services@marketo.com.  They can usually provide information on custom requests or developer support.

[Kenny_Elkington]

If you're only pulling lead data, then you won't really need a schema, you can just use the Describe Lead call to get the full list of fields for the Lead object.  As far as daily or nightly updates, I can't really answer that for you.

[Anonymous]

Hi,

I'm only going through Informatica cloud:    i am not a programmer, so PERL, C++ or JAVA isn't going to work.

any thoughts?

[Anonymous]

After playing with this even more, i can download leads to my server, but not consistently.    Its as if marketo is tracking the last lead downloaded and then the next run is even less.

i never got a complete set, so how do i reset it?

[Kenny_Elkington]

I'm not sure what behavior you're describing, Alex.  I would probably try reaching out to Informatica regarding this issue.

[Anonymous]

Hi Alex,

We have bumped into the same issue as you had before while we are trying to retrieve data to SQL server database to build some analytic reports, but it turned out to be hard to achieve without a good tool.

Therefore, we have developed our own data retrieving tool called Data Loader for Marketo(DLM) which allows you to sync Marketo data to the database without any coding. Besides, DLM can build Marketo schema in your database automatically. We invite you to visit our website to have a free trial of DLM and see if this could solve your problem.

Data Loader for Marketo:  https://dlm.trend.org

Feel free to contact us for further information or any feedback are very welcome!

Sincerely,

Vivian