Tags not populated in programs table

[Anonymous]

Hi,

I am new to Marketo and trying to extract Marketo data using the CDATA Marketo ODBC Driver. I am facing 2 issue with the tables.

1) when I extract Leads table the Columns ProgramId and ListId have Null value. The Column description says "This is a filter column that does not contain data". I need this column to join Leads with Programs and List table.

2) For Programs table TagType and TagValue columns are Null. If I see in actual Program Screen in Marketo I see Tags added for programs.

Can someone help me how can I get values for these Columns?

Regards,

Sampada

[Grégoire_Miche2]

The link between programs and leads can either be seenin the acquisition program field or in the Program member table that links leads and programs.

With regards to the program tags, I am afraid you will have to see to it with the support of the driver vendor.

-Greg

[Anonymous]

Thanks for the response.

I got in touch with the Driver Vendor and they said both of these restrictions are due to the limitations of Marketo API and there is nothing they can do. Here is the link provided from them for reference:

developers.marketo.com/rest-api/assets/programs/

Notice for the "by id" selection method you can get Tag and Cost data, whereas for the "browse" type of selection you will not receive any Tag or Cost data, which means for a bulk extract of Programs these will not be available.

Is there any method to get the Tags Columns in a bulk extract?

[Anonymous]

To add to the above another issue I have is the time taken to extract Marketo tables using ODBC Connection.

I put the filter of UpdatedAt for a month Dec 2017 and the extract job pulled 51K records in 6hrs 50 mins. And that's too much. The activity tables take even more time (9hrs).

Do I need to make any changes to the filters? How can I reduce the Job runtime?

[Grégoire_Miche2 · Accepted solution]

You will need a solution that can leverage the bulk API, which is probably not the case of an ODBC driver... An anyway, program membership is not covered by the bulk API (yet) Or use a solution that can do incremental export towards a third party database, rather than re-extracting everything every time.

Greg

[Anonymous]

The data extract via a DSN/ODBC connection takes hours to complete. For example if I have to extract data for a list of Lead IDs ( 100 Lead IDs one at a time) it takes around 25 minutes. So if I choose 10k Leads to extract using BODS tool the job runs for a long time. Is this an expected behavior or there is a way we can reduce the run time?