My Oracle Support Banner

How To Connect to, Read from and Send JMS (XML) Messages to OC4J with ODI (Doc ID 739691.1)

Last updated on DECEMBER 31, 2019

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.



Goal

This document shows the steps needed to connect to, read From and send JMS (XML) messages to OC4J with ODI.

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
 1. Stop all jobs and exit out of ODI.
 2. Copy the JMS driver files.
 ODI 10g
 ODI 11g and 12c
 3. Restart ODI and log into ODI Topology.
 4. Create the JMS Data Server (Physical connection).
 5. Fill out the Definition and JNDI tabs as shown below:
 6. Edit the default Physical Schema created.
 7. Create a Model in ODI Designer / ODI Studio > Designer navigator.
 8. Define the JMS Datastores
 9. The Mappings / Integration Interfaces.
 II. Using XML Structures for JMS Messages
 1. In Topology right click JMS XML and insert a Data Server.
 2. Set up the JMS XML Data Server exactly same way as the above JMS Data Server.
 3. Then just add the following to the end of the URL.
 4. Insert a Physical Schema and Logical Schema.
 5. Create a JMS XML Model. Reverse engineer.
 6. Set up multiple Mappings / Integration Interfaces.
 Read from JMS XML
 Write to JMS XML
References

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