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.
You
must have a database definition (.dbm file) contained
in a data design project before you can create database mappings.
You can also use database definitions in other nodes, such as the Compute node, to validate
references to database sources and tables. You must include a data
design project in an application, or reference it from an Integration
project, before you can use the
database definitions that your data design project contains.
Database
definition files in the IBM® Integration Toolkit are
not automatically updated. If you modify your database, you must re-create
the database definition files.
Complete the following steps
to create a database definition (.dbm file) from
scratch:
- Click .
A window
opens in which you can select a wizard.
- Expand Data, select Physical
Data Model, and click Next.
The New Physical Data Model wizard
opens.
- Next to the Destination folder field,
click Browse....
A window
opens in which you can select a parent folder for your database definition.
- Select a data design project from the list, and then click OK.
Important: Ensure that you select a data design
project as the parent folder for your database definition. Database
definitions must be contained in a data design project before you
can use them in your IBM Integration Bus messaging
solutions.
- In the File name field, enter a name
to represent the database that you want to model. You do not need
to select the Database or Version.
Important: Create a database definition only if
your database is supported by
IBM Integration Bus.
For
a list of databases supported by IBM Integration Bus,
see IBM Integration Bus requirements.
- Select Create from template, then
click Next.
- In the Templates pane, select Empty
Physical Data Model, then click Finish.
Your empty database definition is created, is displayed
in the Data Project Explorer view, and is opened in the Physical
Data Model editor.
- If the Data Project Explorer view is not open in your IBM Integration Toolkit, open it:
- Click .
A window opens in which you can select
a view.
- Expand Data Management, select Data
Project Explorer, and click OK.
The Data Project Explorer view opens.
- In the Data Project Explorer view, expand your database
definition and select Database.
The
database properties are displayed in the Properties view.
- In the Properties view, select the General tab.
In the Name field, enter the name of your database.
If you use this database definition with the Graphical
Data Mapping editor, the Name is
displayed as the name of the data source, and is used when creating
the JDBC configurable service for the IBM Integration Bus runtime connection.
- In the Data Project Explorer view, select Schema.
The database schema properties are displayed in the Properties
view.
- In the Properties view, select the General tab.
In the Name field, enter the name of your database
schema.
Database schemas are used only by the
Mapping node, and only
when calling a graphical data map that contains a database transform.
For more information about mapping database content, see
Mapping database content.
- In the Data Project Explorer view,
right-click Schema and select .
A Table is
created, and is displayed under your Schema in
the Data Project Explorer view.
- Define the columns in your Table:
- In the Data Project Explorer view, right-click your Table,
and select .
A Column is
created, and is displayed under your Table in
the Data Project Explorer view.
- Enter a name for your Column.
- In the Properties view, select the Type tab
to define the attributes of your column.
- Repeat steps 13 through 14 for each table in your database,
and then save your database definition.
- Save your database definition, and close the Physical
Data Model editor.