SSIS and IBM MQ Series Integration

I am studying the integration between SSIS and the IBM MQ Series. Can someone point me to some kind of art for integration.

+4
source share
1 answer

You may be able to use the Message Queuing Task along with some other host bridge. Here is what I found when trolling on the Internet:

SSIS does not support downloading to / from the IBM MQ series directly from the box. ETI is the only known Microsoft partner or other third party that can read and write to the IBM MQ Series. This is handled through MQSeries own serial (Message Queue Message) through their process of connecting to each order. SSIS clients also have the following ways to integrate their solutions with the IBM MQ Series:

1.Microsoft MSMQ-MQ Series Bridge, which comes with a host integration server. The MSMQ task in the control flow in SSIS can be used in conjunction with a bridge that provides connectionless communication, storage and messaging through messaging systems and computing platforms throughout the network.

2. Using the BizTalks MQ Series adapter to enter / extract messages to / from the SSIS data stream using various exchange mechanisms: in memory: script component or setting: exchange messages through the file system or direct it to SQL Server tables and use the data source component for reading them.

3.Using Extensibility History in SSIS: Build the MQ component for the source / target user / script directly linked to the native libraries of the MQ series.

You can find the original website here .

This describes the "Message Queuing Task" that I came across in PDF, comparing how SSIS and Informatica handle messaging.

SSIS includes the Microsoft Message Queue Connection Manager (MSMQ), which enables connection to MSMQ message queues. Combined with this, there is a bi-directional message queue task that allows the SSIS package to insert messages and display messages from the message queue. Messages can be in the form of text, files, or the contents of SSIS variables. SQL Server Service Broker, which is included with SQL Server 2005 (and therefore with SSIS), adds asynchronous messaging features to database applications. Service Broker queues are available from any application capable of issuing T-SQL code that includes SSIS.

+2
source

Source: https://habr.com/ru/post/1304904/


All Articles