Oracle/NT/MQ?

[Guest_imported]

I am trying to take a message from an Oracle DB, generated from a trigger, and send it using either MQ Client/ MQ Server / MS MQ on a Windows NT box. Do I need to have a gateway for any of these options? What are some pro's and con's to each of these methods? My main concern is the Oracle database trigger communicating on with a Windows NT environment. Any comments/help would be great! Thanks.

 

[smeridew]

MQClient; Advantage is cost (free). Disadvantage is connection dependence - i.e. MQ Server must be available.

MQServer; advantage is connection independance (messages remain in xmit queue until connection is up). Disadvantage: cost (5K -10K per server roughly).


MSMQ; advantage is win32 integration. disadvantage is lack of heterogenous interconnection (must use Host Integration Server to go to non-win32 system and convert from MSMQ to MQSeries - bad design choice)

Cheers,

Scott Meridew
TxMQ Inc.

http://www.txmq.com

scott@txmq.com
Scott Meridew
Certified MQSeries Specialist,MCSE
MQ Squared Inc.

http://www.mqsquared.com