How to copy from Azure Data Factory to Salesforce Marketing Cloud

Question

How to copy from Azure Data Factory to Salesforce Marketing Cloud

Kazuki Shinada 1

This is Shinada, who is working as a technical sale in Salesforce Japan. I received a question from our client about how to copy from Azure Data Factory to Salesforce Marketing Cloud.
The client would like to use the data in Azure SQL Database in Salesforce Marketing Cloud and we wonder if that is possible or not. If possible, we would like to know how to make it.

Peter Groft 106 Reputation points

2022-12-20T06:50:52.513+00:00

Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then click New
Search for Salesforce and select the Salesforce Marketing Cloud connector.
Configure the service details, test the connection, and create the new linked service.

Greetings,
Peter

3 answers

Your answer

Peter Groft 106 Reputation points

2022-12-20T06:50:52.513+00:00

Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then click New
Search for Salesforce and select the Salesforce Marketing Cloud connector.
Configure the service details, test the connection, and create the new linked service.

Greetings,
Peter

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Azure Data Factory (ADF) has a connector for Salesforce Marketing Cloud as documented here. The connector in ADF needs two things: client ID and client secret which is obtained from Marketing Cloud | Installed Packages. You need a Marketing Cloud user when creating an API integration in Installed Packages. The Marketing Cloud user must have the Installed Package | Administer permission.

The Salesforce Marketing Cloud connector supports OAuth 2 authentication, and it supports both legacy and enhanced package types. The connector is built on top of the Salesforce Marketing Cloud REST API. You can use REST API to write data into Salesforce as explained here.

Kazuki Shinada 1 Reputation point

2022-12-20T04:38:34.05+00:00

Thank you for your guidance.

Regarding the content of your comment, it seems that you are copying from Salesforce to ADF, not from ADF to Salesforce MarketingCloud.

What I want to check is to use ADF to copy the performance data in the core system to Salesforce Marketing Cloude and implement marketing measures.

Looking at the FAQ, it seems that this direction of integration is not possible with the connector.

Also, looking at external blogs, it seems that SFTP and API can be used to link ADF to SalesforceMarketingCloud, but is it realistic?
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-12-20T04:43:44.15+00:00

The connector is used when the source in ADF will be Salesforce MarketingCloud. However, when the destination (sink on ADF) is Salesforce MarketingCloud you need to use REST API. REST API is the only way I know to write data from any source to Salesforce MarketingCloud from ADF.

Answer 2

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @Kazuki Shinada ,

Thank you for posting query in Microsoft Q&A Platform. Adding more to above details.

Salesforce Making cloud connector supports as source to fetch data but not supports as Sink to load data. Click here to know more about.

Since, connector does not support as sink, you need consider writing your own code and running it using custom activity or Azure function activity.

As mentioned by @Alberto Morillo , You can consider making API calls too if that works in your case.

Please consider check below link to understand more about custom activity and Azure Functions activity.
Use custom activities in an Azure Data Factory or Azure Synapse Analytics pipeline
Azure Function activity

Hope this helps. Please let me know if any further queries.

-----------

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

Kazuki Shinada 1 Reputation point

2022-12-20T06:41:06.96+00:00

Thank you for your guidance.
Since ADF cannot execute load processing to an external system with only a connector, I understood that original code and customization are necessary for implementation.

Please let me know one more point.

In this FAQ, it is possible to link from ADF to an external system using SFTP. In that case, is it possible to link to an external system using the PUT command?
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-12-20T06:48:43.243+00:00

Some connectors in ADF supports as both and sink. In such cases we no need to write our own code as connector itself supports. When connector does not support as source or sink in such cases only, we need to consider writing our implementation. Regarding SFTP connectivity, there is a connector for SFTP, you can use that.

Check below link for connectors in ADF and details of supporting capabilities.
https://learn.microsoft.com/en-us/azure/data-factory/connector-overview

Check below link for SFTP connector.
https://learn.microsoft.com/en-us/azure/data-factory/connector-sftp?tabs=data-factory

Hope this helps.

-------
Please consider hitting Accept Answer button. Accepted answers help community as well.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2022-12-22T09:34:42.093+00:00

Hi @Kazuki Shinada ,

Just checking in to see if the above answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

How to copy from Azure Data Factory to Salesforce Marketing Cloud

3 answers

Your answer