Introduction to the "Using a message map to enrich a message with data from a database" scenario

This scenario shows how you can enhance a message in IBM® App Connect Enterprise by using a message map. The data is available in a database system. The data is stored across multiple database tables. All the tables are located within the same database schema.

About this task

In IBM App Connect Enterprise, you can use graphical data maps to transform messages. Message maps offer the ability to transform a message without the need to write code, providing a visual image of the transformation and simplifying its implementation and ongoing maintenance.

If you want to deploy legacy message maps (.msgmap format) in IBM App Connect Enterprise, you must first convert them into message maps in .map format, which the Mapping node can consume. For more information, see Using or converting legacy resources into message maps.

The Select transform that allows you to enrich a message by accessing data located in an external database system. This feature eliminates the requirement to use a Database node, a JavaCompute node, a .NETCompute node, or a Compute node to access data located in a database. You can design simpler message flows by using a single Mapping node to complete a message transformation that requires data from an external database system.

Read the following topics to understand the scenario and the concepts the scenario is intended to demonstrate:

What to do next

Implement the solution. For more information, see Implementing the solution for the scenario to enrich a message with data from a database.