How to call stored procedure/kettle files in Pentaho designer?
There are two ways of running the stored procedures
If the procedure returns a resultset, then you can use the result like any other query in the report-designer by calling it via
"CALL procedure(${parameter1},${parameter2})"
However, if your procedure just returns a single value and you want to combine that value with results from other procedures or queries, then you have to use Pentaho Data Integration.
