Forum Discussion

jlakshminaraya's avatar
jlakshminaraya
Frequent Visitor
2 years ago
Solved

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

How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

  • NandanHegde's avatar
    NandanHegde
    2 years ago

    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's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago

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