Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Multiple Read and Write Adaptor

  • rajat kumar barik
  • Topic Author
  • Offline
  • User
  • User
More
5 years 11 months ago #3421 by rajat kumar barik
Multiple Read and Write Adaptor was created by rajat kumar barik


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 to join the conversation.

More
5 years 11 months ago #3422 by FlowHeater-Team
Replied by FlowHeater-Team on topic Multiple Read and Write Adaptor
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 to join the conversation.

  • rajat kumar barik
  • Topic Author
  • Offline
  • User
  • User
More
5 years 11 months ago #3423 by rajat kumar barik
Replied by rajat kumar barik on topic Multiple Read and Write Adaptor


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 to join the conversation.

More
5 years 11 months ago #3424 by FlowHeater-Team
Replied by FlowHeater-Team on topic Multiple Read and Write Adaptor
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 to join the conversation.

Time to create page: 0.424 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.