Connecting Marketo from Azure Data Factory

Mustafa Altuntaslar 21 Reputation points
2021-07-06T09:43:23.327+00:00

Hi All,

I'm using Azure Data Factory (ADF) to copy some Marketo data to our Azure Data Lake. I do not have any issue with accessing Marketo from the ADF, I mean my connection is working, the connection test is successful.
But at the "Source data store" step, when the ADF tries to load Marketo tables/entities I get the following error.

ERROR [HY000] [Microsoft][Marketo] (20) Error while attempting to use REST API: Opportunity API disabled Unknown Error Code . Activity ID: d0aa76cb-2a60-400f-816c-4ff0b29e2797

We use MS Dynamics 365 and our Marketo instance is linked to our CRM and I know that "The Company and Opportunity APIs are only available on instances that are not currently synced with a CRM."

But I don't try to update Company and Opportunity information here, I just want to select some entities/tables to copy Marketo data, but it is failing. These entities could be Campaigns, Lead Activities, etc. I mean I'm not interested in Company and opportunities.

I would be grateful if you could help us with this.
Thank you in advance.
Regards,
Mustafa

112157-screen-shot-2021-07-06-at-123548.png112158-screen-shot-2021-07-06-at-123646.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,464 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-07-06T18:27:06.857+00:00

    Hi @Mustafa Altuntaslar ,

    Welcome to Microsoft Q&A forum and thanks for reaching out. By reading this statement - "We use MS Dynamics 365 and our Marketo instance is linked to our CRM" - my understanding is that your Marketo instance is integrated with CRM.

    Unfortunately Marketo instances that are integrated with external CRM are unsupported. The product team is considering it to be the feature request to support external CRM in Marketo connector.

    This is the reason unable to load the tables/entities even though you are able to establish the connection.

    Ref: Here is a MSDN thread with similar discussion: https://social.msdn.microsoft.com/Forums/en-US/48375c22-d6a6-4c54-b05d-0f6667566db1/marketo-connector-throws-error-opportunity-api-disabled-unknown-error-code?forum=AzureDataFactory

    Hence, I would recommend you to please log a feature request in ADF user voice forum - https://feedback.azure.com/forums/270578-data-factory
    All the feedback shared in this forum are actively monitored and reviewed by ADF product team. Also please do share the feedback link here once it is posted so that other users with similar idea can upvote and comment on your suggestion which would help to increase the priority of feature request.

    Hope this info helps.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


0 additional answers

Sort by: Most helpful