MQSeries.net :: View topic - database to database mapping using nodes

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » database to database mapping using nodes

database to database mapping using nodes

« View previous topic :: View next topic »

Author

Message

srinivas Raju

Posted: Tue Mar 20, 2007 10:00 pm Post subject: database to database mapping using nodes

Novice

Joined: 20 Feb 2007
Posts: 22
Location: India

Dear Member

first i would like to thank all of you, for giving good solutions.

here i have issue, that i wants to update fields from one database to another database at runtime. our technical specifications are MQ and MB.

so i wants to build message flow which can perform above action.

here i am planning to use: Mapping, DataInsert, DataUpdate nodes.

what combination of nodes can perform above action. please suggets me in detail. if u could give me small explanation about above nodes, that would be helpfull.

thanks
sreenu

Balaji_P

Posted: Thu Mar 22, 2007 2:24 am Post subject:

Apprentice

Joined: 05 Sep 2006
Posts: 36
Location: Chennai

I think it can be done in a single compute node.
If u want more clarity u can segregate in two or nodes.

Retreive the fields from Database1 and set it to environment and acess the field value in environment and update the database 2.

Hope this is the one which you are asking for....

Posted: Thu Mar 22, 2007 3:45 am Post subject:

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

The flow cannot dynamically pick up records. It needs a trigger to know when to pick up records from the first table and insert into the second table.

You would either have to write separate code to write the trigger or you can use JDBC adapter. The adapter will keep polling application tables and notify the broker whenever some operation happens on the table. The adapter will deliver the inserted records as an XML message to the broker. The message flow can process this data and insert into the second table. You can use either compute node or database nodes for this.

Regards,
VK.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » database to database mapping using nodes

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP