| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to Access Remote Databases from Message Broker Flow |
« View previous topic :: View next topic » |
| Author |
Message
|
| essive |
 Posted: Mon Nov 15, 2004 9:52 am Post subject: How to Access Remote Databases from Message Broker Flow |
 |
|
Novice
Joined: 15 Nov 2004
Posts: 24
|
We are evaluating WBIMB for our organization. We've noticed that in a message broker flow that if you wish to query, update, insert, etc. data from a remote DBMS using a database node or a compute node the UserID and PW passed to the remote DB is the same as what the broker is currently running under.
Is this true? Can you not have a broker running under it's own UNIX id, for example, and then setup an ODBC connection in the ODBC.INI file with a different UID and PW?
I'm new to this so forgive me if this is a 'newbee' question. |
|
| Back to top |
|
 |
| JT |
| Posted: Mon Nov 15, 2004 9:58 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
No.
| Quote: |
| Can you not have a broker running under it's own UNIX id, for example, and then setup an ODBC connection in the ODBC.INI file with a different UID and PW? |
Yes, you set the distinct database id(s) & password(s) by means of the mqsisetdbparms command
| Quote: |
| We've noticed that in a message broker flow that if you wish to query, update, insert, etc. data from a remote DBMS using a database node or a compute node the UserID and PW passed to the remote DB is the same as what the broker is currently running under. |
This scenario was true under WMQI v2.x. |
|
| Back to top |
|
|
| Heinz57 |
| Posted: Mon Nov 15, 2004 10:09 am Post subject: |
|
|
Apprentice
Joined: 21 Jan 2004
Posts: 26
Location: Syracuse, NY
|
The scenario is the same for V5. We have run mqsisetdbparms for a number of external databases connections that need different ID/pw combinations.
Last edited by Heinz57 on Mon Nov 15, 2004 10:10 am; edited 1 time in total |
|
| Back to top |
|
|
| essive |
| Posted: Mon Nov 15, 2004 10:09 am Post subject: |
|
|
Novice
Joined: 15 Nov 2004
Posts: 24
|
| So, just to validate my thoughts, I could have 2 or more remote DB connections setup under a single broker using the mqsisetdbparms command, correct? |
|
| Back to top |
|
|
| Heinz57 |
| Posted: Mon Nov 15, 2004 10:13 am Post subject: |
|
|
Apprentice
Joined: 21 Jan 2004
Posts: 26
Location: Syracuse, NY
|
| yes, you set up ODBC connections then run mqsisetdbparms with the id/pw for the DSN you wish to modify. Your msg flow must connect to the unique DSN that you have set the ID/pw for. |
|
| Back to top |
|
|
| JT |
| Posted: Mon Nov 15, 2004 10:16 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| I could have 2 or more remote DB connections setup under a single broker using the mqsisetdbparms command, correct? |
Yes, you will have two or more entries in your .odbc.ini file, which you will issue the mqsisetdbparms command for each entry, specifying the ODBC source, database id and password. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
