Forum Stats

  • 3,839,355 Users
  • 2,262,485 Discussions
  • 7,900,946 Comments

Discussions

Can we replace IBM MQ with oracle AQ

3013446
3013446 Member Posts: 7
edited Mar 17, 2016 1:52AM in Advanced Queueing

Hi All,

Currently we are using IBM MQ can we replace it with Oracle AQ.

KayKStefan Abraham

Best Answer

  • Ajay Vijayan
    Ajay Vijayan Member Posts: 179 Red Ribbon
    edited Mar 17, 2016 1:52AM Answer ✓

    Hi,

    Yes you can replace IBM MQ with Oracle AQ

    Oracle AQ:

    ==========

    Oracle AQ is an intgrated freature of Oracle Database and it doesnt have extra license for its usage.Where as IBM MQ comes with extra licensing.So if possible we can same extra licensing cost by implementing Oracel AQ.

    Oracle AQ runs inside the Oracle database. It is available in Oracle XE (free), SE and EE versions as a default db option (no extra licensing needed).

    Thus you need to use something like an OCI or JDBC driver, and connect to the database, in order to use AQ. Typically PL/SQL interface layer into AQ will be created for the app to use.Have never used IBM's MQ. Oracle AQ is fairly robust and works pretty well though. We have Java worker apps distributed across a WAN, each with a local XE database as its "private" datastore. Communication from central command (Oracle RAC) to the Java worker apps are via database links and AQ.

    Of course, how well AQ will work depends on your requirements, and implementation of AQ.

    Both AQ and MQ are based on Asynchronous Messaging.All of them uses Queues and Topic to consume.But the datasource from which they consume or produce differs.

    MQ:

    ----

    1.MQ consumes the topic and queues frm the IBM MQ Server

    2.AQ uses an Oracle Database

    3.While a JMS Adapter uses File,Memoery and also the DB persistence as AQ.

    1) MQSeries is certified to run on some 13+ platforms and on different technologies and provides consistent API's in different languages. This makes it a attractive choice to use for legacy integration ( mainframes and so on), so instead of porting Java to these platforms and then using JMS , these apps can talk to the messaging provider in their native language.

    2) MQ has proven track record in guaranteed message delivery, a reason why it is used for high critical messaging especially in finance industry. In my opinion no other messaging provider to date have been able to attract the same level of confidence as MQSeries.

    You can ask the same question in www.mqseries.net where you get more solid reasons to go with MQ. (Since I don't have expertise )

    3013446

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,834 Red Diamond
    edited Mar 11, 2016 2:47AM

    Yes. Unless it is a motorcycle. A motorcycle does not have any doors.

    (answer is as good as any given the total lack of detail provided)

    KayKStefan Abraham
  • AndrewSayer
    AndrewSayer Member Posts: 13,007 Gold Crown
    edited Mar 11, 2016 2:54AM
    3013446 wrote:
    
    Hi All,
    
    Currently we are using IBM MQ can we replace it with Oracle AQ.
    

    What reasons do you have for replacing it with anything? What is the problem you are trying to solve with it currently ? How is it being implemented?

  • 3013446
    3013446 Member Posts: 7
    edited Mar 11, 2016 2:59AM

    Hi Billy,

    We have an application developed in VB and some in .net which uses IBM MQ 7.5 as a middle ware.

    Now I want to know is it possible to remove IBM MQ and use only Oracle AQ as a middleware.

    kindly let me know what all details can i provide for more clarification.

  • 3013446
    3013446 Member Posts: 7
    edited Mar 11, 2016 3:03AM

    Hi Andrew,

    AFAIK Oracle AQ is an intgrated freature of Oracle Database and it doesnt have extra license for its usage.Where as IBM MQ comes with extra licensing.So if possible we can same extra licensing cost by implementing Oracel AQ.

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,834 Red Diamond
    edited Mar 11, 2016 4:01AM

    Oracle AQ runs inside the Oracle database. It is available in Oracle XE (free), SE and EE versions as a default db option (no extra licensing needed).

    Thus your client needs to use something like an OCI or JDBC driver, and connect to the database, in order to use AQ. Typically PL/SQL interface layer into AQ will be created for the app to use.

    Have never used IBM's MQ. Oracle AQ is fairly robust and works pretty well though. We have Java worker apps distributed across a WAN, each with a local XE database as its "private" datastore. Communication from central command (Oracle RAC) to the Java worker apps are via database links and AQ.

    Of course, how well AQ will work depends on your requirements, and implementation of AQ.

    3013446
  • Ajay Vijayan
    Ajay Vijayan Member Posts: 179 Red Ribbon
    edited Mar 17, 2016 1:52AM Answer ✓

    Hi,

    Yes you can replace IBM MQ with Oracle AQ

    Oracle AQ:

    ==========

    Oracle AQ is an intgrated freature of Oracle Database and it doesnt have extra license for its usage.Where as IBM MQ comes with extra licensing.So if possible we can same extra licensing cost by implementing Oracel AQ.

    Oracle AQ runs inside the Oracle database. It is available in Oracle XE (free), SE and EE versions as a default db option (no extra licensing needed).

    Thus you need to use something like an OCI or JDBC driver, and connect to the database, in order to use AQ. Typically PL/SQL interface layer into AQ will be created for the app to use.Have never used IBM's MQ. Oracle AQ is fairly robust and works pretty well though. We have Java worker apps distributed across a WAN, each with a local XE database as its "private" datastore. Communication from central command (Oracle RAC) to the Java worker apps are via database links and AQ.

    Of course, how well AQ will work depends on your requirements, and implementation of AQ.

    Both AQ and MQ are based on Asynchronous Messaging.All of them uses Queues and Topic to consume.But the datasource from which they consume or produce differs.

    MQ:

    ----

    1.MQ consumes the topic and queues frm the IBM MQ Server

    2.AQ uses an Oracle Database

    3.While a JMS Adapter uses File,Memoery and also the DB persistence as AQ.

    1) MQSeries is certified to run on some 13+ platforms and on different technologies and provides consistent API's in different languages. This makes it a attractive choice to use for legacy integration ( mainframes and so on), so instead of porting Java to these platforms and then using JMS , these apps can talk to the messaging provider in their native language.

    2) MQ has proven track record in guaranteed message delivery, a reason why it is used for high critical messaging especially in finance industry. In my opinion no other messaging provider to date have been able to attract the same level of confidence as MQSeries.

    You can ask the same question in www.mqseries.net where you get more solid reasons to go with MQ. (Since I don't have expertise )

    3013446
This discussion has been closed.