WebSphere Message Brokers
File: ar37660_
Writer: Cerys Giddings

Task topic

This build: July 31, 2007 21:36:48

Adding database definitions to the Message Broker Toolkit

Use the New Database Definition Files wizard to add database definitions to the Message Broker Toolkit.

You must have database definition files in the Message Broker Toolkit to create database mappings. Database definition files are also used by other nodes such as the Compute node to validate references to database sources and tables. The following steps describe how to add database definition files to the Message Broker Toolkit:

  1. In the Broker Application Development perspective, select the message flow project that you want to store the database definition files in.
  2. Click File > New > Database Definition Files. The New Database Definition Files wizard displays.
  3. Enter a connection name. The connection name is included in the names of the database definition files that are created in your message flow project.
  4. Leave the Use default check box checked (it is checked when the wizard is opened) unless you want to place the database definition files in a different schema. Alternatively, clear the Use default check box and use the Browse button to find the schema that you want to use.
  5. Click Next.
  6. Select one of the following options depending on the type of connection you require:
    Option Description
    Choose a DB2 alias Select this option if you have a DB2 database that is catalogued on your local DB2 client
    Choose a database manager and JDBC driver Select this option if you know the database manager, platform and version of a local or remote database
  7. Click Next.
  8. Select the JDBC and connection settings for your database from the choices in the wizard. You can use the Test Connection button to verify the settings you have selected for your database.
  9. Click Next.
  10. You can restrict the information retrieved from your database by using a filter. You can use the Add Schema Filter dialog to include or exclude schemas from the database definitions (by default all schemas matching SYS% are excluded). You can use the Add Object Filter dialog to include or exclude tables, views and aliases from the database definitions.
  11. Click Next.
  12. You might need to set connection parameters depending on the database and platform that you are creating database definition files for. Use the information in the wizard to determine the settings that you must provide.
  13. Click Next to view a summary of the database connection settings that you have selected in the wizard.
  14. Click Finish to create the database definition files in your message flow project.
A number of files are created in your message flow project with the following formats:
Database definition files in the Message Broker Toolkit are not automatically updated. If a change is made to your database you must update the database definition files. To update your database definition files:
  1. Open the Data perspective.
  2. In the Database Explorer view, right-click on the database connection that you want to update and click Reconnect.
  3. To change the database connection settings right-click on the database connection and click Edit Connection and follow the instructions in the Edit Database Connection wizard.
  4. To update or add a new table or other database object, right-click on the object and click Copy to Project. Select the message flow project with the database definition files to update.
Related concepts
Message flows, ESQL, and mappings
Related tasks
Modifying databases using message mappings
Creating a message map file from a DataInsert node
Creating a message map file from a DataUpdate node
Creating a message map file from a DataDelete node
Adding a database as a source or target
Related reference
Message mappings
Broker Application Development perspective
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:36:48

ar37660_ This topic's URL is: