I have an Azure SQL database and an on-premise nintex workflow environment. I would like to use an Execute SQL action to run a stored procedure (this stored procedure updates the SQL database with parameters from the list item).
Is this possible?
+7
Hi,
Do u mean u tried it but no success?
+2
Userlevel 6
+15
Should be possible.
Running an SQL procedure (via the "Execute SQL" action) can look like this:
Connection:
Data Source=(whateveritis);Initial Catalog=(catalog);User ID=un;Password=pw;
Procedure:
exec ProcedureNameHere
@Item1={WorkflowVariable:textHazardID},
@Item2 ={WorkflowVariable:whatever},
@Item3= {ItemProperty:whatever},
You can then store the output (if any) in a collection or single item, depending on what its returning.
+2
Excellent, this is exactly what I needed to get this working. THANK YOU!
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.