Connect to the database and obtain the definition files

Demonstrate how to define a database connection to enable a message flow to access a database table. The database must be defined to the workbench.

Before you start:

Create a message flow project.

Start of changeThe Database Definition Wizard uses the JDBC interface to communicate with the database server; therefore you need to ensure that the database client jar file on your local or workbench host is at a compatible level to allow communication with the database server. If necessary, consult your database vendor for further advice.End of change

  1. Switch to the Broker Application Development perspective.
  2. Select the message flow project that you want to create the database definition files in and click File > New > Database Definitions Files. The New Database Definition Files wizard opens.
  3. Enter a connection name (for example AIRLINEDBALIAS) and click Next.
  4. Ensure Choose a DB2 alias is selected and click Next.
  5. From the Alias drop-down menu, select the database alias name (for example AIRLINEDB) and enter the appropriate User ID and Password in the Specify user information section.
  6. Click Test Connection. The default Port number for a DB2 database is 50000. If the connection fails, you can try to enter other values such as 50001, 50002 and so on, for the Port number, and then test the connection again.
  7. Click Finish. The database definition files are added to the message flow project.
  8. From the Broker Development view, expand the Database Connections folder in the message flow project (for example AIRLINE_MFP) to reveal the files that have been created. Database tables are stored in .tblxmi files.

The database definition is added to a new Data design project. You have now defined the database to the mapping tools.

Now go to Create the message flow.
Related reference
Message mappings
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:23:00

ar25153_