How To Write To a JMS XML Queue From Relational Tables Using Oracle Data Integrator 11g (Doc ID 1311394.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Goal

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 (11.1.1.7.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.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms