Abstract
In this project, I will be propagating the messages between Oracle Server and WebSphere MQ through a Messaging Gateway. When web based business applications communicate, the producer application enqueue messages and the consumer applications dequeue the messages. The enqueued messages are said to be propagated when they are reproduced in another queue in same database or in a remote database. Oracle Streams AQ provides database-integrated message queuing functionality which is built on top of Oracle Streams and leverages the functions of Oracle Database so that messages can be stored persistently, propagated between queues on different computers and databases, and transmitted using Oracle Net Services and HTTP(S). Oracle Streams AQ 11g Release 1 supports queue-to-queue propagation. Messages are propagated from one queue to another queue; the destination may be same or remote database. Propagation enables you to fan out messages to a large number of recipients. Also, through propagation we can combine messages from different queues into a single queue known as compositing or funneling messages. Oracle Stream AQ has propagation between two Oracle Streams AQ queues to enable e-business. Messaging Gateway extends this functionality to applications based on non-Oracle messaging systems such as applications based on Web Sphere MQ. Conversely, messages published by non-Oracle messaging system applications can be consumed by Oracle Streams AQ applications. Message gateway also supports message conversion between Oracle Streams AQ messages and non- Oracle messaging system messages using built in routines or customized message transformation. In general, integrated applications involve the integration of various messaging systems. Oracle Streams AQ seamlessly integrates with existing non-Oracle Database messaging systems like IBM Web Sphere MQ through Messaging Gateway, thus allowing existing Web Sphere MQ-based applications to be integrated into an Oracle Streams AQ environment. Most of the facts discussed in the Abstract are referenced from [1].