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® App Connect Enterprise Toolkit. IBM App Connect Enterprise supports the databases that are listed in IBM App Connect Enterprise 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 App Connect Enterprise runtime component connects to the database that is used by transforms in a map, by using a JDBC Providers Policy. The name of the JDBC Providers Policy must match the data source that was used in the Toolkit when the map was created (the discovered database name). You must also ensure that the JDBC Providers Policy is placed in the configured default policy project.

IBM App Connect Enterprise can access databases that are set up on the local computer or on a remote server, subject to restrictions. For more information, see IBM App Connect Enterprise 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 JDBC Providers policy to manage your database resources. For more information, see JDBC Providers policy.