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 3.2.03.01 to 10.1.3.9.99
Information in this document applies to any platform.

Purpose

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.

Scope

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:

Copy the IBM MQ Java libraries into the ODI <drivers> directory.
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.
Set up JMS Queue connection in ODI Topology.
Set up the JMS Model in ODI Designer.
Create ODI Mappings / Integration Interfaces to read from and send to IBM MQ.
Important JMS specifc KM Options