CODEWITHSUNDEEP
azurestored-proceduresazure-pipelinesazure-data-factoryazure-synapse
MADFROST
MADFROST

Reputation: 1723

How to sequence stored procedure process on Azure Data Factory?

I have a stored procedure that has a DateTime parameter, and I want to execute the pipeline sequence, so it will start first on 'JAN-FEB' and then 'MAR-APR' then 'MEI-JUN'

How can I do that ? without using hard pipeline from the stored procedure?

So for the example like this:

enter image description here

I have 3 stored procedures with different DateTime. And I don't want it run like this.

enter image description here

What can I do to solve my problem ? What function from Azure Data Factory can I use for this case?

Note:

Upvotes: 1

Views: 1172

Answers (1)

Joseph Xu
Joseph Xu

Reputation: 6043

  1. First you can define an array type variable in ADF. Eg. ['JAN-FEB','MAR-APR','MEI-JUN']
    enter image description here

  2. Traverse this array via Foreach activity. Select Sequential, this will sequentially cycle the internal activities. Add dynamic content, select your declared variable name.
    enter image description here

  3. Inside Foreach activity, we can use a stored procedure, click Import will import params in your stored procedure. Then add dynamic content @item(). enter image description here

ADF will execute the stored procedure sequentially.

Upvotes: 1

Related Questions