We would like to build an integration between Azure Synapse analytics and a marketing automation platform. The use case is basically to create a list of purchasers based on data already integrated in Azure Synapse and then send them an email using the marketing email platform.
I understand how to push the data to the marketing automation platform using the available APIs for that tool but not clear on how I would extract the data from Azure Synapse.
Any help would be appreciated.
Integrating data from Azure Synapse
As you mentioned that you want set up integration between Azure Synapse analytics and a salesforce marketing platform You can follow the below steps:
Step 1: Create a linked service and a source dataset for your Azure synapse(Source)
You can get the server name from synapse overview like below
Step 2: Search for Salesforce and select the Salesforce connector. and Configure the service details, test the connection, and create the new linked service.
Know more about Copy data from and to Salesforce using Azure Data Factory or Azure Synapse Analytics
Also as you mentioned that you want send an email using the Once data is moved from marketing cloud from synapse. You can refer the below similar Azure Data Factory send email on pipeline failure with Batch Service