Trigger ADF pipeline execution based on a Status change in Dynamics online

Question

Hi,

Please, can you give me some guidance regarding the best approach for "Trigger ADF pipeline execution based on a Status change in Dynamics online"

Best regards,
Radu

Answer 1

Hi Martin,

Thank you very much for your quick and informative reply.
I think that best approach for me will be : "Use another service such as Logic Apps or Function App to either subscribe to any notifications Dynamics may offer"

Best regards,
Radu

Answer 2

Hello @Antonache, Radu and welcome to Microsoft Q&A.

Azure Data Factory does not have an out-of-the-box feature for your ask, but there are several potential solutions.

• On the Dynamics side, use something to listen for the Status change, and then make a call to the Data Factory REST API to trigger the start of a pipeline run.
• Use another service such as Logic Apps or Function App to either subscribe to any notifications Dynamics may offer, or to poll (check the status every X minutes) Dynamics, and tell Data Factory to start a pipeline run.
• In ADF create a scheduled trigger to start a pipeline every X minutes. This pipeline will use a Lookup Activity or a Web activity to get the Status from Dynamics, and then use Execute Pipeline activity accordingly to start your intended pipeline.