Need Example, use result from SQL-Query as input into Second Database/Table

[Christian Stark]

Hello,

Assuming the following example: I'd like to know how to control/manipulate
the variables to insert the input from the first query from table/database1
into the second table/database2.
What is the best option to manipulate $input1,$input2,$input3

Do we need a transformer or a converter?


 <route id="demo_route">
            <from id="route-timer" uri="timer:foo?period=20000"/>
            <to id="_to1" uri="sql:SELECT column1,column2,column3 FROM
testtable where key = ':3685127';?dataSource=myDataSource"/>

            <to id="_to2" uri="sql:INSERT INTO USERS
(column1,column2,column3) values
('$input1,$input2,$input3)?dataSource=myDataSource2"/>
 </route>



Any input is appreciated


Thanks
Christian