X hits on this document

342 views

0 shares

1 downloads

0 comments

32 / 131

JMS

Knowledge Modules

Knowledge Modules in this section apply to most popular JMS compliant middleware, including Oracle JMS, Sonic MQ, IBM Websphere MQ and others. Most of these Knowledge Modules include transaction handling to ensure message delivery. All of them use the Oracle Data Integrator JDBC Driver for JMS. This JDBC driver includes a simplified SQL syntax to query message queues and topics. Therefore, a SQL select statement is translated by the driver into getting a set of JMS messages, and a SQL insert statement is translated into putting a set of JMS messages.

Type

Knowledge Module

Integrate

IKM SQL to JMS Append

Description

Integrates data into a JMS compliant message queue or topic in text or binary format from any SQL compliant staging area.

Consider using this IKM if you plan to transform and export data to a target JMS queue or topic. If most of your source datastores are located on the same data server, we recommend using this data server as staging area to avoid extra loading phases (LKMs)

To use this IKM, the staging area must be different from the target.

Integrate

IKM SQL to JMS XML Append

Integrated data into a JMS compliant message queue or topic in XML format from any SQL compliant staging area.

Consider using this IKM if you plan to transform and export data to a target JMS queue or topic in XML format. If most of your source datastores are located on the same data server, we recommend using this data server as staging area to avoid extra loading phases (LKMs)

To use this IKM, the staging area must be different from the target.

Load

LKM JMS to SQL

Loads data from a text or binary JMS compliant message queue or topic to any SQL compliant database used as a staging area. This LKM uses the Agent to read selected messages from the source queue/topic and write the result in the staging temporary table created dynamically.

To ensure message delivery, the message consumer (or subscriber) does not commit the read until the data is actually integrated in the target by the IKM.

Consider using this LKM if one of your source datastores is a text or binary JMS message.

Load

LKM JMS XML to SQL

Loads data from a JMS compliant message queue or topic in XML to any SQL compliant database used as a staging area. This LKM uses the Agent to read selected messages

Knowledge Modules Reference Guide

32/131

Document info
Document views342
Page views345
Page last viewedSun Dec 04 19:40:09 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments