How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory

[jlakshminaraya]

How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory

[Anonymous · Accepted solution]

Hi @jlakshminaraya 
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:

Hope this helps. Please let me know if you have any further queries.

[jlakshminaraya]

Thanks @NandanHegde  and @Anonymous.

[jlakshminaraya]

Thanks @NandanHegde for your time and detail explanation. 

In step 3, do i need to import all 5 stored procedures inside of "for each" and edit the settings of each procedure? 

if yes, stored procedure name on each is SP setting is @item() is final , or something to be enterd?

If No, what is the body  of stored procedure you have imported in step?

Thanks,

Lakshmi Narayana

[NandanHegde · Accepted solution]

Hey,

The variable has the SP names :

dbo.sp1;dbo,sp2


the split function splist this variable into an array which is iterated over the for each.

And the item() is basically the iteration value so it would be dbo.sp1 or dbo.sp2 which is passed over within the sp activity.

So the SP activity to execute those SPs.

[NandanHegde]

Hey @jlakshminaraya 

The details provided by @Anonymous  is correct but it is too manual and in case of new additions, you would have to manually add in new activities.

The below design is a meta data driven flow :

1) Create 2 variable like ParallelExecution and Sequentailexecution with semicolon seperated values

wherein values would your SPname1;spname2 etc

2) use 2 foreach activities one for parallel execution and another one for sequential execution with values for thier settings :

value : 

@split(variables('ParallelExecutionSPs'),';')

Similarly for sequentail :

@split(variables('SequentailExecutionSPs'),';')

3) within for each , use stored procedure activity

similar would be for sequentail foreach as well

hope this helps.

You can even have the variable as type array and directly use in foreach as is if need be

[Anonymous]

Hi @jlakshminaraya 
Thanks for using Fabric Community.
Can you please explain your ask a little bit more? So that I can help you better.
Thanks.

[Anonymous]

Hi @jlakshminaraya 
Are you asking the same here : How to call stored procedures Concurrently and seq... - Microsoft Fabric Community?

[Anonymous · Accepted solution]

Hi @jlakshminaraya 
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:

Hope this helps. Please let me know if you have any further queries.