How To Write To a JMS XML Queue From Relational Tables Using Oracle Data Integrator 11g
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.99 [Release 11gR1]
Information in this document applies to any platform.
This document provides a detailed description of a step by step example in which we demonstrate the use of Oracle Data Integrator (ODI) 11g to write information stored as an XML structure to a JMS Queue.
The example shows how to set up ODI Integration Interfaces which read source data from relational tables and writes the data into an XML structure which is then transferred to a JMS message queue for distribution to targeted applications to read.
This example described here is created using the ODI demo XML files, which are found on the Oracle Data Integrator Companion 11gR1 (188.8.131.52.0) located from the Downloads page of Oracle Technology Network (OTN) - http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. This should allow you to reproduce the operation if necessary.
In the case given here, the JMS Queue is hosted on a Oracle WebLogic Server 10.3.6. However, this example can be implemented on any JMS-complaint server such as Tibco or IBM Websphere.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms