Integration Using Oracle Streams Advanced Queues

by Thomas Cong

Oracle Advanced Queues have been around for a while. It was part of Oracle DBMS since 8.1.5. Now as part of Oracle Streams, you have database-integrated message queuing functionality. You get a persistent or non-persistent queuing model, local or remote propagation and all the operational benefits of high availability, scalability, and reliability of the underlying database.

It has always been a challenge to integrate BRM with other enterprise applications. The inbound interface is available in C/C++/Java/Perl, but the learning curve to be familiar with data structure and programming concept is steep. On the outbound direction, the native Data Manager framework also requires intensive coding and detailed knowledge of BRM, data format and the interface API you want to talk to.

For a recent integration project, we’ve decided to employ Oracle AQ for both inbound/outbound real-time and batch transactions between BRM and EBS. Each application maintains the inbound and the outbound AQ in its local database. The outbound BRM AQ is linked to the inbound EBS AQ; similarly, the outbound EBS AQ is linked to the inbound BRM AQ using AQ propagation mechanism.

Each application is responsible for enqueuing and dequeuing operation of its own queues. The Oracle Streams AQ platform is responsible for message delivery, propagation, transactional integrity, persistence and high availability.

Since 7.3.1 BRM provides a DM_AQ component, which allows pushing business events with XML payload into an Oracle AQ, we leveraged this existing data manager to push payload for real-time transactions such as inventory item changes and orders from BRM to the external system.

On the inbound, we developed a new custom data manager, which uses OCI to dequeue messages from the inbound queue. Thus, BRM is able to pull payload for real-time transactions from the external system. The database-to-database AQ propagation is used to move messages between the queues. The propagation setup is the trickiest part, but in the end the whole scheme has been a success.

Transform Your Business Today

Please contact us today to learn how Congero Technology Group can help your business succeed.

Contact Us

Contact our experts today for a personalized consultation and discover how your company can benefit from these technological innovations. Do not wait to become a leader in your industry and ensure customer satisfaction while increasing your recurring revenues. The time for action is now!

Get in touch with us to initiate your business transformation!

You may also like…


know more

How can we help you?

We are here to help you elevate your business because it’s what we do best. Leave your name and business email, so we can connect and discuss how our experts can assist you.