1 person found this helpful
I had implemented such a setup few months back and it works fine except for some performance issues.
you'll need to implement oracle streams and oracle messaging gateway for this propagation.
below mentioned are the generalized steps:
>>capture changes from redo log for the table by creating a capture process.
>>store these messages in the staging area of advanced queues, which in turn are queues themselves.
>>use apply process to enqueue these messages onto messaging gateway queue.
>>the messages can be transported to Websphere MQ by creating propagation jobs, foreign queue links, messaging gateway agents etc.
you can figure out the basic details using the link mentioned below.