TOPIC: Multiple Read and Write Adaptor

Attached in the example I want to achieve through flowheater.
I have one source adapter left hand side.
I have to tranasctiondata adapter at right hand side(RHS) where data need to be transferred from left hand side(LHS)
I have to read the createdby user which is an ID from LHS and need to map it with the UserData ID and then get the CODE and set it to Created_by_code in the RHS

How to do it... ??

Hi Rajat,

In case I understood your request right you don´t need a second Adapter at the WRITE side.

I suppose you want just perform a simple database lookup on a second table? For this you can use the Lookup Heater or the SQL Heater . I recommend the SQL Heater because this one is more flexibel.

To use the SQL Heater you must first set the needed arguments for the SQL statement with the Parameter Heater as an FlowHeater Parameter . In your case just move one Set Parameter Heater into the Designer and connect the Oracle Adapter Field “CREATED_BY” from the READ side. At least you have to define a name for this parameter. e.g. “ID”.

In the SQL Heater you can now use this parameter as placeholder in the database lookup SQL statement, for example.


Note: In the statement you have to surround the parameter name with the dollar sign!

This SQL statement will be executed for each row. The values are dynamically replaced with the value of the given parameter.
The output of the SQL Heater will be the result of this SQL statement and should connected with your “CREATED_BY_CODE” field on the WRITE side, that´s all.

Important: In case the field “CODE” is a nummeric value you have to apply a format setting to the parameter without group sepeaator! (Menu->Edit->Parameter).

I´ve made a brief example, please have look to the attachment.

Menu->Edit->Parameter

1.I am trying to migrate the data from read side table to write side transactiondata table.
2.read side table having created_by id field, which need to maped with write saide user data table id, and based on that id the code need to select and write it back to transactiondata table to complete the table data migration

this scenario I am looking for to achieve from above. please let me know. thanks

Hi Rajat,

Sorry, I don´t understand your purpose. I guess you wont insert or update anything in the second adapter on WRITE side?

I suppose you just want to retrive the content of the CODE field with the given ID from the Oracle Adapter (READ side) and store it in the “CREATED_BY_CODE” field from the first WRITE adapter, is this right?

If yes, the example above should work for you, please try it.

If this assumption wrong please descripe a bit more in detail wich data you want to insert/update in the first and second adapter on WRITE side, Thanks.