To create database mappings by using the Mapping node, you must have a database definition file (.dbm) that is contained in a data design project.
About this task
A database definition file contains information about
a connection to a database.
Note: Database definition files
in the WebSphere Message Broker Toolkit are not automatically updated.
If you modify your database, you must recreate the database definition
file describing the connection to the database.
Procedure
Complete the following steps to create the CLIENTS.dbm database definition file by using the New Database Definition File wizard:
- In the Application
Development view,
right-click and select .
The New Database Definition File wizard is displayed.
- From the Data design project drop-down
list, select AddressBook_DD. From the Database drop-down list, select DB2 for Linux,
Unix, and Windows. From the Version drop-down list, select V9.7. Then, click Next.
- Create a database connection. In the New Database
Definition File - Select connection, select New.
A New Connection window opens.
- In the New Connection - Connection Parameters, edit the following properties to configure the CLIENTS database connection:
- Enter CLIENTS as the Database value.
- Enter db2admin as the User name, and enter your database administrator password
in Password.
Note: You can use
a different user name to connect to the database. This user must have
database administration permissions.
- Click Test Connection to verify
the settings that you selected for your database.
If
the connection is successful, the following window opens:
- Select Save Password.
- In the New Connection - Connection Parameters, click Finish.
The CLIENTS1 connection is created.
- Select the CLIENTS1 connection,
and then select Next.
- Select the schema ADDRESSBOOK, and
then click Next.
- In the New Database Definition File - Database
Elements window, select Tables,
then click Finish.
Results
The CLIENTS.dbm database definition file is available in
the Application
Development view under Independent resources. The database
definition file is created inside the AddressBook_DD data project.
The following figure shows the CLIENTS database definition file opened in the Physical
Data Model Editor.
What to do next
After you create the database definition file CLIENTS.dbm, you must configure your integration solution
to access specific database resources. For more information, see Configuring an integration solution to access database resources.