Mappings

Mappings allow you to define the mapping of structures or fields containing data from an input source onto output structures or fields in a target.

A mapping represents transformation information that includes the statement and the assignment that goes with the mapping. The assignment contains the value that the output is assigned when the transformation occurs.

By default, this assignment is trivial but useful, and takes on the exact value of the corresponding input or inputs. In many cases, this is what is needed because the transformation is between disparate structures that contain equivalent information. However, you might find that a direct assignment is not sufficient and you need to define computations that closely define how and when mappings should, or should not, take place. You can create these computations with the help of Mapping editors, called Compose Expression editors.

The inputs and outputs to be mapped can be either messages or database tables or, in the case of the Mapping node, both messages and database fields. Mapping is accessed and maintained through various different nodes:

Mappings between sources and targets are defined through the workbench, which includes the Compose Expression editors.

Mapping and ESQL can reuse user-defined ESQL functions. Reusable functions are globally defined in the ESQL editor.

Related concepts
Message flows
Message modeling
ESQL
Related tasks
Developing mappings
Developing ESQL
Related reference
Built-in nodes
Mappings