检索"DataExtension".使用Azure数据工厂从Salesforce Marketing Cloud获得数据 [英] Retrieve "DataExtension" data from Salesforce Marketing Cloud using Azure Data Factory

问题描述

你好

我想从与Azure数据工厂连接的"DataExtension"(存储在Salesforce Marketing Cloud中的用户表)中查询数据.
不过，当我看到Data Factory的现有表"菜单中，我只能看到系统表.

I'd like to query data from "DataExtension"(user tables stored in Salesforce Marketing Cloud) connecting with Azure Data Factory.
I've tried though, when I see Data Factory's "Existing Tables" menu, I can see only system tables.

您能告诉我我该怎么做吗?

我想我需要为数据扩展"指定架构名称.而不是"SFMC.dbo".但是我不知道它的名字.

I guess I need to specify schema name for "Data Extension" instead of "SFMC.dbo". But I don't know its name.

来源如下.

https://docs.microsoft.com/zh-CN/azure/data-factory/connector-salesforce-marketing-cloud

https://docs.microsoft.com/en-us/azure/data-factory/connector-salesforce-marketing-cloud

此致

推荐答案

您可能希望查看数据库架构，请阅读https://developer.salesforce.com/docs/atlas.en-us.eclipse.meta/eclipse/eclipse_schema_browser.htm

You might want to look at the database schema please read https://developer.salesforce.com/docs/atlas.en-us.eclipse.meta/eclipse/eclipse_schema_browser.htm

这篇关于检索"DataExtension".使用Azure数据工厂从Salesforce Marketing Cloud获得数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！