FlowHeater Logo

FlowHeater Support Forum

simply more productive

Download the freeware version (10 Mb)

Up to 100,000 records can be processed with the freeware version!

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Multiple Read and Write Adaptor

Multiple Read and Write Adaptor 2 months 3 weeks ago #3421

  • rajat kumar barik
  • rajat kumar barik's Avatar Topic Author
  • Offline
  • Posts: 4


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... ??
Attachments:

Please Log in or Create an account to join the conversation.

Multiple Read and Write Adaptor 2 months 3 weeks ago #3422

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.

select CODE from USERDATA where ID = $ID$

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


File Attachment:

File Name: oracle-dat...okup.zip
File Size:2 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Multiple Read and Write Adaptor 2 months 3 weeks ago #3423

  • rajat kumar barik
  • rajat kumar barik's Avatar Topic Author
  • Offline
  • Posts: 4


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
Attachments:

Please Log in or Create an account to join the conversation.

Multiple Read and Write Adaptor 2 months 3 weeks ago #3424

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.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1
Time to create page: 0.262 seconds