Daily Lead data from Marketo to a SQL Server table | Community
Skip to main content
A
Anonymous
September 24, 2015
Solved

Daily Lead data from Marketo to a SQL Server table

  • September 24, 2015
  • 3 replies
  • 3699 views

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?

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

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.

3 replies

A
Anonymous
October 7, 2016

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:  dlm.trend.org

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

Sincerely,

Vivian

Kenny_Elkington
Kenny_Elkington
New Participant
September 24, 2015

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.

A
Anonymous
September 24, 2015

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?

A
Anonymous
September 24, 2015

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.

A
Anonymous
September 24, 2015

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.

A
Anonymous
Accepted solution
September 24, 2015

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.

Terms & ConditionsAccessibility statement

Loading footer...