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

Antonache, Radu 96 Reputation points
2020-11-23T08:04:59.347+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,487 questions
0 comments No comments
{count} votes

Accepted answer
  1. Antonache, Radu 96 Reputation points
    2020-11-24T06:53:38.323+00:00

    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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,011 Reputation points
    2020-11-23T19:33:11.557+00:00

    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.
    0 comments No comments