To setup ODBC bridge from IBM Integration Bus to Db2, download and install the ODBC bridge from the IBM Data Server Runtime Clients. It’s a 1.3 GB download, and you only need about a 40 MB file for your system.
The installation is straight forward – Click Next, and Finish.
The complexity and detailed steps are in the configuration of the ODBC Bridge and IIB.
To setup the ODBC bridge and IIB, follow these directions:
-
Start > Run
-
Type ODBC
-
Click on Data Sources
-
Click on `Configure ODBC
-
Enter the Connection Details
Name | Value |
---|---|
Username | db2admin |
Password | fakepass! |
IP | 9.32.18.166 |
Port | 50000 |
Database name | SAMPLE |
-
Name the alias as
SAMPLE
-
Launch a Command prompt
-
Start > Run
-
Enter
cmd
-
Change directory to server\bin
-
Launch iib
C:\Program Files\IBM\IIB\10.0.0.4\server\
bin>mqsisetdbparms.exe TESTNODE_cheetah -n SAMPLE -u db2admin -p fakepass!
BIP8071I: Successful command completion.
TESTNODE_cheetah should be your local node in Eclipse.
You want to restart the Node (you can look in the lower right of your toolkit)
-
Right Click the Node
-
Select Stop, Then Start
Now, that it is setup, the steps to read the data, the ESQL is easy:
You can then send a message using the IIB tests , and confirm using your database Db2 select * from DB2ADMIN.EMPLOYEE
.
To Write Data, create a New Input Message
with
{
"EMPNO" : "2229",
"FIRSTNME" : "Paul",
"LASTNAME" : "B",
"JOB" : "PRES",
"EDLEVEL" : 18
}