Connecting WMB to database

Question

I am new to WMB and I want to connect WMB to database. Please letme know which database will be good and please let me know the initial steps for connecting WMB to DB.

Thanks Amit Khandelwal

Answer 1

WMB connects to a database via DSN. So, first thing you have to do is, creating a DSN.

Steps to create DSN will vary from OS to OS. For windows follow these steps in this link.

After creating DSN you have to attach it to your broker. Use mqsisetdbparms for this purpose.

After giving mqsisetdbparms, you need to restart your broker.

In your message flow you have to give the same DSN name in the "Database Source name property.

You can check if the broker is able to connect to the database using mqsicvp command.

Regarding, "which database will be good". WMB works fine with all well known DB providers, like oracle, DB2 etc(As it uses DSN).

But since both WMB and DB2 are IBM products, I would guess they will mingle better with each other. We are using both Oracle and DB2 and we have got no complains for any of them.

Complete video Tutorial on connecting WMB to Database

All these documentation from IBM is very confusing and it takes lots of efforts in make all these things together. I found this video tutorial on youtube which explains connecting wmb to database step by step.

Configure Database on WebSphere Message Broker or Integration Bus

Connecting WMB to Database