My Oracle Support Banner

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

Last updated on DECEMBER 09, 2019

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 located from the downloads page of Oracle Technology Network (OTN):

     https://www.oracle.com/middleware/technologies/data-integrator-downloads.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-compliant server such as Tibco or IBM Websphere.

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 Prerequisites
 Implementation
     Data Server Creation
     Create Models
     Create Interfaces
     Create ODI Package
     Execution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.