Creating the database definition file

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.

Before you begin

Create the AddressBook_DD data design project. For more information, see Creating a data design project.

About this task

A database definition file holds the physical data model that details all the database resources, such as the schema, the tables, and other resources, that you need access to.

Note: Database definition files in the IBM® App Connect Enterprise Toolkit are not automatically updated. If you modify your database, you must re-create the database definition file that describes 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:

  1. In the Application Development view, right-click and select New > Database Definition.

    The New Database Definition File wizard is displayed.

  2. 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 the appropriate version for your DB2 installation. Then, click Next.

    For more information about the databases that IBM App Connect Enterprise 12.0 supports, see Databases overview.

  3. Create a database connection. In the New Database Definition File - Select connection, select New.

    The following figure shows the Select connection panel, where you select New.

    A New Connection window opens.

  4. In the New Connection - Connection Parameters, edit the following properties to configure the CLIENTS database connection:
    1. Enter CLIENTS as the Database value.
    2. Enter db2admin as the User name, and enter your database administrator password in Password.
      Note: You can use a different username to connect to the database. This user must have database administration permissions.
    3. Click Test Connection to verify the settings that you selected for your database.

      If the connection is successful, the following window opens:

      This figure shows the window that you receive when you test a connection and it is successful. The message is Connection succeeded.

    4. Select Save Password.

    This figure shows the New Connection - connection parameters window completed with the values used in the scenario.

  5. In the New Connection - Connection Parameters, click Finish.

    The CLIENTS1 connection is created.

    This figure shows the CLIENTS1 connection created and displayed under connections.

  6. Select the CLIENTS1 connection, and then select Next.

    The following figure shows the New database Definition File wizard with the CLIENTS1 connection selected.

  7. Select the schema ADDRESSBOOK, and then click Next.

    The following figure shows the ADDRESSBOOK schema selected only.

  8. 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.

This figure shows the in the Application Development viewwhere under Independent resources it is located the database definition file.

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.