How to extract Marketo Leads into my SQL Server using SSIS?

Forum|Forum|8 years ago
August 16, 2017
3 replies
5408 views

Hi,

Please help me how can I extract my marketo leads data into sql server?

I am trying to extract the Leads data from Marketo using SSIS connector into my MS-SQL Database, We have 1.49 million records in Marketo database after 1.05 Million records the job was cancelling and I am getting error. so anybody can help me on this why I am unable to get the remaining data, and also let me know is there any restrictions.

I am getting the below error please take a look into that.

[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: -1. Marketo Request Failed - 601: Access token invalid

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

Message was edited by: Prashant Raparla

Marketo

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

SanfordWhiteman

Level 10

You can look at the Bulk Extract API endpoint (http://developers.marketo.com/rest-api/bulk-extract/). For periodic bulk retrieval of the entire lead database this'll do fine (followed by a SQL Bulk Insert of course!).

SanfordWhiteman

Level 10

Why did you mark your question as the Correct answer?

Luis_Paez3

Level 2

You could also try to break apart your database into smaller chunks if it's taking a long time to grab all the leads. Best way is to create static lists in Marketo with smaller segments of the larger dataset. Then have your code download each "list". Also, check out CDATA's marketo sql driver - I've never used them but it'd be one thing I'd look at if you're using all Microsoft products.

A

Anonymous

Hi Luis,

Thanks for responding. Also can you share some documentation about how can I automate my marketo data to sql server using SSIS.

SanfordWhiteman

Level 10

What SSIS connector? CData's connector?

SanfordWhiteman

Level 10

[ODBC Source [2]] Error: Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: -1. Marketo Request Failed - 601: Access token invalid

This error partway through a job means the access token (which has a 1 hour TTL) expired. My experience w/CData products is that they have a token retry/renew process, at least for their OData Server.. You should open a support case with them to find out why that isn't working here.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded