| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Loading Rows to Oracle Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| andrewl68 |
 Posted: Tue Sep 23, 2003 7:24 am Post subject: Loading Rows to Oracle Database |
 |
|
Novice
Joined: 23 Sep 2003
Posts: 14
|
Can someone please explain how to connect and load rows to an oracle database. The broker resides on AIX 5.0 and the database resides on a different server with the same operating system.
Thanks |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Sep 23, 2003 8:48 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
First you need to have oracle client on the box where Broker is running. After that, configure your odbc connection by adding an entry into .odbc.ini file. You can use this newly created DSN within your Database/Compute node to insert data into oracle database using some ESQL statements.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| andrewl68 |
| Posted: Tue Sep 23, 2003 9:18 am Post subject: |
|
|
Novice
Joined: 23 Sep 2003
Posts: 14
|
| I set up the odbc entry, I cannot get the syntax correct to pass the userid and password. Can anyone help?? |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Sep 23, 2003 9:25 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
When creating Broker did you specify a different user-id to connect to external databases? IF so, you need to have this user-id/pwd created into remote Oracle DB also. If you did not specify this parameter then the broker will use Service user-id to connect to external databases.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
