| Author |
Message
|
| ARAMARK |
 Posted: Fri Sep 21, 2007 2:01 am Post subject: WBIMB |
 |
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
My doubt is do we need a MQ or MessageBroker Adapter to retrieve data from oracle database through WBIMB?
If I am not wrong,when WBIMB interacts with external database it needs a MQ or MessageBroker adapter to retrieve the data from the database.
Please suggest whether WBIMB can directly retrieve data from external database through ESQL in Compute Node or it needs an MQ/MessageBroker adapter for this.
If it needs a MQ adapter to be installed on oracle server,then does MQ needs to be installed on the oracle server?
Please advice.... |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Fri Sep 21, 2007 3:36 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
WBIMB can directly retrieve data from external database through ESQL in Compute Node
_________________
Cheers |
|
| Back to top |
|
|
| asudhakar |
| Posted: Fri Sep 21, 2007 3:58 am Post subject: |
|
|
Centurion
Joined: 12 May 2007
Posts: 116
Location: Bangalore
|
| AkankshA wrote: |
| WBIMB can directly retrieve data from external database through ESQL in Compute Node |
Hi
i worked with MB5.0.5 + DB2
I think we cant directly access tables in esql.
we should specify data source name for compute, database or mapping nodes.
i done by the above way.
If there is any way to interact with db - table through esql pls tell me.
ex : in java by jdbc classes we can interact with db-tables.
is there any way directly interact with db-table via esql.
_________________
WebSphere MQ, MB Support and Admin |
|
| Back to top |
|
|
| ARAMARK |
| Posted: Fri Sep 21, 2007 4:00 am Post subject: WBIMB |
|
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
I need the message flow to be triggered within a particular time interval.Can I do it with the help of TimeoutControl or TimeOutNotification Node?
or I need to follow some other mechanism? |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Sep 21, 2007 4:01 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
you can achieve it using timeout nodes.
_________________
Cheers |
|
| Back to top |
|
|
| ARAMARK |
| Posted: Fri Sep 21, 2007 4:50 am Post subject: WBIMB |
|
|
Novice
Joined: 07 Sep 2007
Posts: 14
|
Hi Asudhakar,
Yes we need to specify data source name for compute, database or mapping nodes,then only we can retrieve data from database.
But in your case since the database was db2,an adapter may not be required.
My question is if the database is other than db2 then can we use WBIMB to retrieve or update data in oracle database through ESQL. |
|
| Back to top |
|
|
| fschofer |
| Posted: Fri Sep 21, 2007 6:10 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
|
|
