MQSeries.net :: View topic - right way to access external database from Message Broker6.1

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 » right way to access external database from Message Broker6.1

right way to access external database from Message Broker6.1

« View previous topic :: View next topic »

Author

Message

mvarghese

Posted: Sat Sep 18, 2010 6:59 am Post subject: right way to access external database from Message Broker6.1

Centurion

Joined: 27 Sep 2006
Posts: 141

In my project existing way,developers are connecting external db eg:SQL Server Db from broker for application purpose.
By 1.>Giving broker id to give r/w access to SQL Server db ,and also update odbc.ini with SQL server driver/server details.This way connection working fine.
But here Not using any mqsisetdbparams to set userid for SQLdb in broker server.

2nd:I seen on another project which access external app db from broker, with setting of mqsidbaparms +odbc.ini with DSN details..

So which is the right/efficient method to connect external db..IBm docs all seen abt second manner..
_________________
Jain Varghese

fjb_saper

Posted: Sat Sep 18, 2010 9:24 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

If you look at it, the second way (using mqsisetdbparms) is more flexible because it allows you access to DB's where the user name to be used is not the broker's service user.

Also whenever possible you should make use of the broker's supplied odbc drivers as they have been optimized for usage with the broker...

Have fun

_________________
MQ & Broker admin

mvarghese

Posted: Sun Sep 19, 2010 10:01 am Post subject:

Centurion

Joined: 27 Sep 2006
Posts: 141

Thanks .I also thought same.Tough to change existing manner what dev is doing..
becos second method we have specific user id ..it accessing external db..so database level they can trace easily from which flow its coming and can set specific connection pool for each user id connection....instead of giving just broker id to give access to db.
_________________
Jain Varghese

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » right way to access external database from Message Broker6.1

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