Re: Integration with IBM Mqueue series

It's MQSeries =8-)

It's a form of MOM (Message Oriented Middleware). The thing that it most closely resembles in the Oracle world is Oracle Pipes...except that the a queue can be persistent...i.e. survive a reboot. I'm not familiar with Advanced Queue Option so maybe Oracle now has that feature too.

Anyway...it makes no sense to 'replicate' to MQ since your data would only be placed on a message queue from the Oracle end. What would be interesting is what is done with the data after it is put on the queue. =8-)

MQ ships with an API that allows you to programatically place messages and retrieve messages on to and from the queues. You would need to make these libraries known to the extproc interface to be able to do anything useful with them. More likely you would write some sort of interface (C,C++,VB,java) between inserted/updated data that could then reference these API's

Of course, what is written to the queue is highly dependant on what is reading it from the other (Big BLue!) end...so you could be writing data, XML or even SQL to be read and processed from the other end.

HTH Jeff Herrick

On Fri, 25 Jul 2003, Rakesh Gupta wrote:

> One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience.
>
> Can anyone please shed some light on how this can be done ?
>
> Thanks
> Rakesh
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rakesh Gupta
> INET: GuptaR_at_telecomsys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 25 2003 - 09:17:05 CDT