Configuring a database in the IBM Integration Toolkit

To make database information accessible from a Mapping node during the development phase, you must define a database definition file with extension .dbm. This file is contained in a data design project. You must define one database definition file per database.

Before you begin

To start the scenario, create the initial configuration. For more information, see Creating the scenario graphical data map configuration.

About this task

You can use IBM® Integration Bus to access a database and manipulate your business data.

During the development phase, you must configure the database before you can access the data from your a message flow in the IBM Integration Toolkit. IBM Integration Bus supports the databases that are listed in IBM Integration Bus Requirements.

IBM Integration Bus can access databases that are set up on the local computer or on a remote server, subject to restrictions. For more information, see IBM Integration Bus Requirements.

This scenario demonstrates how to configure a local database in the IBM Integration Toolkit.

Procedure

To configure the CLIENTS database, complete the following steps:

  1. Create a data design project as a container for a database definition file. See Creating a data design project.
  2. Define your database and how it interacts with your integration node. See Creating the database definition file.