SOLVED

Re: Daily Lead data from Marketo to a SQL Server table

Go to solution
Anonymous
Not applicable

Daily Lead data from Marketo to a SQL Server table

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?

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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.

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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
Marketo Employee

Re: Daily Lead data from Marketo to a SQL Server table

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
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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
Marketo Employee

Re: Daily Lead data from Marketo to a SQL Server table

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

Anonymous
Not applicable

Re: Daily Lead data from Marketo to a SQL Server table

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