My Oracle Support Banner

How To Connect To, Read From And Send JMS (XML) Messages To IBM MQ Series With ODI (Doc ID 552671.1)

Last updated on DECEMBER 20, 2019

Applies to:

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


Oracle Data Integrator (ODI) can be used to both, read from and send to, IBM MQ Series JMS Queues and Topics.

This document describes the required steps to connect to MQ Series from ODI using Sun Microsystem's File based FSContext and how to read from and send to IBM MQ Series and hightlights the usage of some of the key JMS specific ODI KM options.


A T T E N T I O N !

This note was written using legacy Sunopsis and ODI 10.3.X versions. It still applies to ODI 11g and 12c as well as there is no change in MQ and ODI in regarding to the core of such connection.

If you run into any errors, follow, Note 1300798.1 'invalid username or password' Or 'Cannot find the Connection Factory' When Connecting To JMS Queue In ODI.
(this Note is an update as the issues were detected while using ODI 11g and should apply to ODI 12c).

 The steps required to achieve the above goals are:

  1. Copy the IBM MQ Java libraries into the ODI <drivers> directory.
  2. Set up JNDI environment.

    ODI requires to setup a JNDI context factory through which to look up a reference to a QueueConnectionFactory object. All the JMS operations will be done through the
    QueueConnection referenced from the looked up factory.

    We will use SUN’s "com.sun.jndi.fscontext.RefFSContextFactory" to create a file based JNDI namespace which is populated after we define the Connection Factory using  IBM JMSAdmin tool. The name of the Queue/Topic Connection Factory is then used in ODI Topology as JNDI Resource.
  3. Set up JMS Queue connection in ODI Topology.
  4. Set up the JMS Model in ODI Designer.
  5. Create ODI Mappings / Integration Interfaces to read from and send to  IBM MQ.
  6. Important JMS specifc KM Options


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
 How To Connect to MQ Series from ODI using Sun Microsystem's File based FSContext and the Websphere MQ JMS Administration tool
 1. Copy the IBM MQ Java libraries into the ODI <drivers> directory.
 2. Set up JNDI environment.
 3. Sett up JMS Queue connection in ODI Topology Manager.
 Note for connecting to IBM MQ Series version 7
 How to Read From And Send To IBM MQ Series
 4. Set up the JMS Model in ODI Designer.
 5. Create ODI Mappings / Integration Interfaces to read from and send to IBM MQ.
 JMS Specific KM Options
 6. When developing Mappings / Integration Interfaces, it is important that you click on each option of the JMS KM and understand their usage and warning.
 6.1 CLIENTID - Read Subscriber identification string.
 6.3 How to do continuous and automatic read of your XML messages from your Queue
 6.4. No messages or only part of the messages are consumed from the Queue.

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