0
Passing Parameters to Stored Procedures
If we have a Stored Procedure in the database server to which I need to pass a decryption key (string/text) in order to decrypt the numeric sensitive data, is it possible to do so using parameters at either the model or global level?
1 reply
-
You can do it in a Model using a hard-coded value or using a variable. In order to call the stored procedure, you need to use a SQL Query node. You can put the decryption key in the call to the stored procedure.
If you don't want to hard-code it, you can create a variable and pass the variable to the SQL Query node.
Variables can be populated via a literal, a query from another source (including a Pyramid In-Memory database) or as output from another process in the Master Flow.