how to access Data extension of salesforce marketing cloud from Azure Data factory

Pramod Waghole 46 Reputation points
2022-01-07T10:42:14.11+00:00

Hellow,

I am able to connect from Azure data factory to Salesforce marketing cloud using out of the box connector (enhanced Auth option)

I could see the standard SFMC tables to read in ADF data source .

I like to read the data extension of SFMC but their are not available in the list.

Has anyone came across this ?
Is their a way to read data extensions (which is essentially a views within SFMC) to be accessible from ADF as if normal tables ?
is their additional permission needed to open from SFMC side (installed package) to have more of these data extension accessible to api call from Azure ?

Pleas help

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,546 questions
0 comments
Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2022-01-10T19:46:56.88+00:00

    Hello @Pramod Waghole ,

    Thanks for the question and using MS Q&A platform.

    Unfortunately it is not possible to read the data extension of SFMC using Out of box SFMC connector in ADF. This has been called out in public documentation here : ADF Salesforce Marketing Cloud connector - Supported capabilities

    163716-image.png

    I would recommend you to log your feedback in IDEAS forum and do share the link once it once it is posted so that we can take it forward to relevant product owners : https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

    I'm not familiar with SFMC but if there are any REST API's that would be helpful to retrieve/access data extensions from SFMC then you may utilize those REST API's and use them in ADF REST connector or you may explore Custom activity or Azure function activity in ADF to move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest