Use a message map to map or modify database content.
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.
Optionally, you can use JDBC connection pooling with your JDBC Providers policy to manage your database resources. For more information, see JDBC Providers policy.