Hi @vikranth-0706
Thanks for the question and using MS Q&A platform.
To achieve that integration between Azure Synapse Analytics and your Salesforce Marketing Platform, let's walk through the steps involved:
- Create a Linked Service: This acts as a bridge between Synapse and Salesforce. To identify the server name for Salesforce, navigate to the Synapse overview section.
- Connect to Salesforce:
- Search for the "Salesforce" connector in the list of available options.
- Once selected, you'll be prompted to configure details like credentials and authentication.
- Test the connection to ensure proper setup.
For more information, please refer: Copy data from and to Salesforce using Azure Data Factory or Azure Synapse Analytics
Also, you mentioned that you want to send emails after the purchaser list is transferred to your marketing automation platform. However, the provided reference (Azure Data Factory sending emails on pipeline failure with Batch Service) addresses a different scenario (handling pipeline failures).
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.