I have one request for DB to DB dump.but its not batch it should be real-time
scenario is like below:
(JMS puts the data in input channel) from input channel I will receive a input message , input message contains orderNumber, batchNo ,etc by taking order_number,batch_number from message I have to get the HeaderDetails from source HEADER table,once we get the header details, in the next step I have to get LinesDetails from source DB based on header_Id. and then i have to store these header/ lines data in target header/lines tables.
Next I have to update success/failure message to output channel.
could you please get me some suggestions on this.
Thanks In Advance