Integration of IBM MQSeries with SAP BW

[Former Member]

Hello all,

I have to load data from MQ Series to SAP BW in real time. After some study,the possible options before me are

1. To get the data from MQ Series to some database, then populate BW from there.

2. Use data stage to integrate BW with MQ Series.

3. Use Java connect.

4. Use SAP XI broker and IBM WBI broker for integrating IBM MQ Series with SAP BW.

5. Use some third party integration tool eg:hummingbird genio

Can some one advice me on which will be the best option and why?

Is there any other better option?

Is there any option in BW process chain where by we can load data from MQ Series just like we can load data from flat file.

Any help in this regard will be appreciated.

Regards and thanks

Amrutharaj

[Former Member]

There are two options with less effort.

1.) Create a flat file from the Queue content and load it into BW.

2.) Write a Java Program which reads the data using JMS and loads them into BW. You can use the stating BABI's for the loading.