A Call DB Procedure sounds promising, but as it turns out, you can't use it to retrieve any result sets. Rather, this type of step is meant have an input stream from another source:
- drive stored procedure execution presumably for some useful side-effect
- invoke a database stored function and obtain the scalar result
So, what can we do? The answer is simpler than might be expected.
Just use an ordinary Table input step. Everybody that has used PDI before knows that the Table input step retrieves data based on an SQL statement. However, the SQL statement is not required to be a
SELECTstatement. Any statement that returns a result set will do, including
Stay tuned for more tips like these - more will come as Jos and I are completing our "Building Pentaho Solutions" Book.