Hi all,
Today, I want to share an interesting trick to run a DB procedure in PDI/Kettle.
But anyway, where's the trick, since there is a dedicated transformation to run such procedure ?
I discovered the following : when trying to run a DB procedure with PDI/Kettle using this dedicated job, nothing happens, the procedure does not run and no error is logged.
The answer is : first, you need to call a "Row generation" transformation and link it to your "Call DB Procedure" transformation.
But hey, don't forget to write "1" in the Limit field for the "Call DB Procedure", otherwise the procedure will run more than once !!!
I don't know if this is a real issue, but anyway who cares ? The job is finally done !!
Here is the snapshot.
Vincent,
ReplyDeleteI am trying to run a stored procedure that has 2 arguments/parameters. Do you know where/how to specify the args in the DB Procedure step? BTW thanks for sharing the trick!
Hi Aseno,
ReplyDeleteYou can add parameters when editing the DB procedure step.
Look on bottom of the edit window, you will see a parameter list with name, direction and type.
Hope this is clear for you, otherwise drop me an email : vteyssier at decisionsystems-studio dot fr
It works a lot to me. Thanks
ReplyDeletehai , can u please send some sample transformation to my mail. please,
ReplyDeletemail id-praveenkumar.slm@gmail.com