How to read input parameters and then run a stored procedure using those parameters in DQC

(Nacer Menad) #1

I want to create a components that can read some parameters and then feed them as input to a SQL stored procedure and then execute the procedure. Is it possible to do that in DQC? and how?


Nick Menad

(Petya Minovska) #2

Hi Nick,

We would advise you to use SQL Select step to parameterize a SQL stored procedure using the data columns from the flow of data. Тhe data columns should be defined in the Columns tab in the SQL Select step. Please, refer to the following article.
For detailed description of SQL Select step, please, navigate to Help -> Help Contents -> Ataccama Data Quality Center (version x.x.x) -> Steps -> SQL Select.