ADF Salesforce Marketing Cloud connector - cannot access Data Views

Question

Hello,

I am connecting to SalesForce Marketing Cloud via the standard Azure Data Factory connector. When I define a dataset, I can access the data from the standard tables, either by selecting the Table name in the drop-down list:

Or by switching to query mode and writing a select statement:

But I cannot access any of the Marketing Cloud data views (described here: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_views.htm&type=5):

• The drop-down list does not contain any of the Data Views
• In query mode I get an error that the table or view does not exist:

Does the Salesforce Marketing Cloud connector have support for the Data Views ? If so, is there any particular configuration required in the ADF Linked service or in the security on the Salesforce side ?

Thank you in advance for your assistance

Answer 1

Hi @Rares Carasan ,

Thank you for posting query in Microsoft Q&A Platform.

> Salesforce marketing cloud connector does not support retrieving views, custom objects or custom data extensions. Click here to know more about this connector.

I would encourage you to submit feedback for enabling this using below link. Product team closely monitor feedbacks and consider for future implementations. https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

Between, I forwarded this feedback to internal team from my end too.

Hope this helps.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.