AnsweredAssumed Answered

Execute an Update SQL Query on a Kettle Transformation

Question asked by Kenince Mbithi on Jan 2, 2018
Latest reply on Jan 2, 2018 by Gotn O'Guts

Hi good people,

I'm new to spoon and I've been using Holowczack's tutorials to get a feel of how PDI works. I have a scenario where I would like to run an update script after a table input and table output job, can anyone assist? I have tried these four but I can't seem to figure out how to make them work.

 

Scripting.PNG

Here's the scenario...

Table Input: MySQL Database Table1 (Select * from Table1)

Table Output: Oracle Database (Create Table 1)

(this runs well to completion but then I have to execute the update script manually. I am looking for a way to automate this)

Intended Update Script:

 

update ods.table1 set colum1='New Value1' where column1='Old Value1'

update ods.table1 set colum1='New Value2' where column1='Old Value2'

 

Thank you in advance.

Outcomes