Forum Post: Marketo / Progress Ddc - The "where" Clause And The Soap Api

  • Thread starter Thread starter Matt Roberts
  • Start date Start date
Status
Not open for further replies.
M

Matt Roberts

Guest
We've recently been trying to modify some of our SSIS packages that pull activities from Marketo. I am curious whether or not putting a restriction in the WHERE clause on Activity Type in the activity log causes the Progress connector to invoke the activityFilter->excludeAttributes->activityType (or includeAttributes) options in the SOAP API. Putting something in the WHERE clause seems to make an SSIS package to go much slower than usual (and sometimes to time out, despite putting the timeout value to 0 in the Progress database connection), hence the question - wondering whether or not the Progress connector pulls everything and then filters, or filters using the API call. We're trying to design a process that gets us what we need without timing out / taking a long time, but right now it almost seems better just to pull every activity and then do any filtering in the database on the back end, as using the WHERE statement in the package doesn't seem to work terribly well.

Continue reading...
 
Status
Not open for further replies.
Back
Top