Question

1
Replies
456
Views
Close popover
Tyler Head (Thead)
Allied Solutions
Sr BPM Developer
Allied Solutions
US
Thead Member since 2016 10 posts
Allied Solutions
Posted: June 8, 2018
Last activity: June 27, 2018
Closed

Calling Multiple SQL Stored Procedures at once

Currently working with a requirement that needs to execute 18 stored procedures at once. I am calling these in two sets (5 first/13 second) using parallel processes for each set.

At the moment I have 18 SQL connectors each with identical connection strings and the only differences are about 4 sets of unique input parameters across the 18 procedures.

Each SQL execute is followed by a GetTable() call to the corresponding lookup table.

Any recommendations?

***Edited by Moderator Marissa to update platform capability tags***

Data Integration System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.