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.
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:
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?
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?
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.