Message Image  

App Connect

Converting a legacy message map that includes relational database operations 

Tue July 14, 2020 05:25 AM

When you convert a legacy message map, from WebSphere Message Broker v7 to WebSphere Message Broker v8 or IBM Integration Bus, that includes database operations, the conversion process creates a Task transform for each database operation in the legacy message map. You have to manually replace that Task transform.

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.

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:


#IntegrationBus(IIB)
#JDBC
#mapping