Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>WMB connects to a database via <strong>DSN</strong>. So, first thing you have to do is, creating a DSN.</p> <p>Steps to create DSN will vary from OS to OS. For windows follow these steps in this <a href="http://support.microsoft.com/kb/305599" rel="nofollow noreferrer"><strong>link</strong></a>.</p> <blockquote> <p>After creating DSN you have to attach it to your broker. Use <a href="http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/an09155_.htm" rel="nofollow noreferrer"><strong>mqsisetdbparms</strong></a> for this purpose.</p> </blockquote> <p>After giving mqsisetdbparms, you need to restart your broker.</p> <blockquote> <p>In your message flow you have to give the same DSN name in the "Database Source name property.</p> </blockquote> <p>You can check if the broker is able to connect to the database using <a href="http://pic.dhe.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/an07235_.htm" rel="nofollow noreferrer"><strong>mqsicvp</strong></a> command.</p> <p>Regarding, <strong>"which database will be good</strong>". WMB works fine with all well known DB providers, like oracle, DB2 etc(As it uses DSN).</p> <p>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.</p> <p><strong>Complete video Tutorial on connecting WMB to Database</strong></p> <p>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.</p> <p><a href="https://youtu.be/OXW9EDwEq6k" rel="nofollow noreferrer">Configure Database on WebSphere Message Broker or Integration Bus</a></p> <p><a href="https://youtu.be/qsEWCwQYxAo" rel="nofollow noreferrer">Connecting WMB to Database</a></p>
    singulars
    1. This table or related slice is empty.
    1. POConnecting WMB to database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAnil Kumar
    1. USnitgeek
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COGreat answer from nitgeek, duly upvoted, I'd only add a few things. First of all look here to see what dbs are supported: http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27038798 Secondly on unix systems use these instructions: http://pic.dhe.ibm.com/infocenter/wmbhelp/v8r0m0/topic/com.ibm.etools.mft.doc/bk58060_.htm Finally this ODBC connectivity, you can also setup for JDBC connectivity which is useful if you're writing your transformation logic in Java. See ehre for JDBC setup: http://pic.dhe.ibm.com/infocenter/wmbhelp/v8r0m0/topic/com.ibm.etools.mft.doc/ah61300_.htm
      singulars
      1. PO
      1. USDave
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload