Mapping database content

Use a message map to map or modify database content.

About this task

In the Graphical Data Mapping editor, you can access a database and manipulate your business data.
  • You can use database content as input data for a graphical data map transform.
  • You can use database transforms to modify database content.
  • You can use a database transform to invoke a database stored procedure.

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

For each database transform in your message map, the Graphical Data Mapping editor uses a database definition file (.dbm file) to determine the name and structure of the database that you want to access.

When your message map has been deployed, the IBM Integration Bus run time component connects to the database that is used by transforms in a map by using a JDBCProvider service. The name of the JDBCProvider services must be identical to the name of the database.

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.

The following topics guide you through the steps that are involved in mapping database content:

Optionally, you can use JDBC connection pooling with your JDBCProvider service to manage your database resources. For more information about JDBC connection pooling, see Using a JDBC connection pool to manage database resources used by an integration server.