Real Time Replication Message Queuing (MSMQ) Design
571832Apr 11 2007 — edited Apr 18 2007All,
I currently looking at solutions to replicate data from an Oracle database. One solution seems to be Oracle Streams. I would ideally like the changing data to be pushed into something like a message queue or a web service for the target system to import. The reason I'm considering this approach is that I want to de-couple the systems as much as possible. But the data transfer must be reliable.
My questions are:
Can Oracle Streams post data to something like a Web Service or Message Queue. (Preferably MSMQ)
If so are there any examples of this being done?
Many thanks,