| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Connecting to Oracle database |
« View previous topic :: View next topic » |
| Author |
Message
|
| ajomillar |
 Posted: Thu Dec 18, 2003 1:57 pm Post subject: Connecting to Oracle database |
 |
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| I created a Compute node that needs to update an Oracle table. I have created the ODBC DSN on Win2000, but I don't know how to configure Integrator to access the Oracle database. Is there a property setting in the message flow? I've tried reading the manuals but can't find exact steps required for making this work. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Dec 18, 2003 2:35 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version are you using?
In 2.1, you add the datasource to the Input section on the Advanced tab of a Compute Node, or you set the datasource on the properties of one of the database nodes.
Open up the Help for WMQI to find out about how to use each node.
See the ESQL Reference manual for how to access databases using SELECT, INSERT, UPDATE, and etc.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ajomillar |
| Posted: Thu Dec 18, 2003 2:53 pm Post subject: |
|
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| I'm using Integrator Broker v2.1. I read the help. In the "Compute1" tabe, there is an "Add..." button. I typed in the Datasource and table name. Now, under Inputs, there is a tab by that table name with a tree structure showing the datasource at the root and table as a child. Is that it? thx |
|
| Back to top |
|
|
| ajomillar |
| Posted: Thu Dec 18, 2003 2:56 pm Post subject: |
|
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
| ...I just tested the msg flow. It updated the table. Thanks again for the tips! |
|
| 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
|
|
|
|
