| Author |
Message
|
| venkat_chekka |
 Posted: Tue Jul 29, 2008 1:04 pm Post subject: Send the data from Database to MQ Using PM4Data |
 |
|
Apprentice
Joined: 14 Apr 2006
Posts: 37
|
HI,
I am new to PM4data technology and doing a difficult POC in that.
POC Details:
PM4Data should poll the DB2 database for every n minute and pick the data whenever data available in the table field like “Ready”. PM4data has to send that data into WebSphere MQ in the workflow object format.
Could you please guide me anyone regarding this ASAP.
Thanks ,
Venkat |
|
| Back to top |
|
 |
| nagarjun_vv |
| Posted: Tue Jul 29, 2008 11:37 pm Post subject: |
|
|
Apprentice
Joined: 24 Jun 2008
Posts: 33
|
Hi
You should time out node for querying the DB for every minute after getting the records you can frame the object and you can send to your end system.
Regards,
Nagarjun. |
|
| Back to top |
|
|
| broker_new |
| Posted: Wed Jul 30, 2008 4:19 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Venkat,
Previoulsly, I had the same requirement too.
We asked the Database guys to write a trigger on the table(Trigger monitors for the changes in the table) and dumps the records on the queue.
I worked with Oracle DB, we just installed a support pac on oracle DB which allows us to configure it for MQ.probably DB2 might have one like Oracle |
|
| Back to top |
|
|
| nsomniak |
| Posted: Wed Aug 27, 2008 6:22 pm Post subject: |
|
|
Newbie
Joined: 27 Aug 2008
Posts: 1
|
broker_new:
i think i may be having the same requirements. What version of Oracle and Websphere do you use? Do you know what support pack was installed?
i need to retrieve data writtien to an oracle view and send it back to my websphere message flow via a jdbc adapter, timer nodes or windows batch scheduled job |
|
| Back to top |
|
|
| broker_new |
| Posted: Wed Aug 27, 2008 6:29 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
| We have installed the ma0i support pac to configure oracle 9i and oracle 10G express to connect to MQ .....to continue installing it we have to download the support pac ...install c/c++ compiler on the database operating system.....execute the 9iinstall.sh script on the database instance which is in ma0i support pac and update the listener.ora file...........before that we need to move the AMQCLCHL.TAB file into the database server.. |
|
| Back to top |
|
|
|
|
