MQSeries.net :: View topic - Question on database node

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 » Question on database node

Question on database node

« View previous topic :: View next topic »

Author

Message

jeeth_m

Posted: Tue Apr 22, 2008 8:21 am Post subject: Question on database node

Voyager

Joined: 21 Jan 2002
Posts: 93

Hi,
In our project we have a requirement of querying multiple tables and form a a response xml message. number of tables to be queried will be around 4-7 depending on the request recived.

Question is :
1 Can message broker query multiple tables in a database? Any document on it will be appreciated.
2. I have never worked on database node in message broker. based on experience how is the performance?
3. Is it an efficient way to let message broker do it or rather get it done by ETL tool?

Thanks,
Jeeth

madi

Posted: Tue Apr 22, 2008 11:20 am Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

Quote:

Can message broker query multiple tables in a database? Any document on it will be appreciated.

Yes, it most definitely can. Just go to the Message broker information center!!

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp

Quote:

I have never worked on database node in message broker. based on experience how is the performance?

For your requirement (getting data from DB) you should just be using Compute node as DBNode is for inserting and updating data.

Quote:

Is it an efficient way to let message broker do it or rather get it done by ETL tool?

Yes, a lot of people use Message Broker to access DBs, it is as efficient as any other tool(most of them but may be not all of them) out there.

--madi

jeeth_m

Posted: Tue Apr 22, 2008 12:06 pm Post subject:

Voyager

Joined: 21 Jan 2002
Posts: 93

thanks much!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Question on database node

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