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?
Run Stored Procedure
+2
+2Thanks for the quick response . I am having problems with my connection test, getting a login failed. I also an unsure where to reference the stored procedure.
Translate
+15- Nintex Partner
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.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.