SSIS Connectors with IBM MQ Series (WebSphere MQ)

  • Article

IBM WebSphere MQ is a network communication technology launched by IBM in March 1992. It was previously known as MQSeries, which is a trademark that was rebranded by IBM in 2002 to join the suite of WebSphere products. WebSphere MQ is IBM's Message Oriented Middleware offering. It allows independent and potentially non-concurrent applications on a distributed system to communicate with each other. MQ is available on a large number of platforms (both IBM and non-IBM), including z/OS (mainframe), UNIX (AIX, HP OpenVMS, HP-UX, Solaris), HP NonStop, Linux, and Microsoft Windows.

SSIS does not support loading into/from IBM MQ Series directly out of the box. ETI is the only known Microsoft partner or other 3rd party that can handle reading and writing to IBM MQ Series.  This is handled via native sequential (MQSeries Queue Message) through their Built-to-Order connectivity process. 

SSIS customers also have the below ways of integrating their solutions with IBM MQ Series:

  1. Microsoft’s MSMQ-MQ Series Bridge that comes with Host Integration Server. MSMQ Task in Control Flow in SSIS can be used along with the bridge, which provides connectionless, store-and-forward messaging across messaging systems and computing platforms throughout the network.
  2. Using BizTalk’s MQ Series Adapter to push/pull messages into/out of SSIS Data Flow Engine via various exchange mechanisms: in-memory: Script component or staging: exchanging messages via the file system or directly writing it into SQL Server tables and use a data source component to read them.
  3. Using the extensibility story in SSIS: build an MQ Series source/destination custom/script component directly interfacing with MQ Series native libraries. 

**Note: **This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.