How To Connect to, Read from and Send JMS (XML) Messages to OC4J with ODI
(Doc ID 739691.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.3.0 and laterInformation 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 |