You must convert manually a transformation that includes relational database operations.
A legacy Mapping node connects to a database via ODBC. A database configuration file describes the ODBC configuration to your database. You configure the database information in your legacy message map by setting the Data Source property in the map.
From WebSphere® Message Broker Version 8 onwards, the Mapping node connects to databases via JDBC type 4 connections. You configure the database connection details in a JDBCProvider configurable service.
Database transforms in a message map use support for JDBC connections that are built into IBM® Integration Bus run time.
For information on constructing database transforms and configuring your JDBC database connection, see Mapping database content.
To re-create the transformation logic of a transformation that includes a relational database operation, you can use any of the following transforms when replacing the Task transform in the new message map:
Continue converting your legacy message map. For more information, see Converting a message map from a .msgmap file to a .map file.