Creating a mapping file

To create a new mapping file, use the following method from the Message Flow editor. The nodes that support mapping are the Mapping node, Compute node, Database node, DataDelete node, DataInsert node, DataUpdate node, Extract node and Warehouse node. In the description below, a DataInsert node is used as an example.

Note: You cannot use the following correlation names in the expression of any mapping for a Mapping, Extract, Warehouse, DataInsert, DataUpdate, or DataDelete node:
  • Environment
  • Root
  • Body
  • Properties
  • DestinationList
  • ExceptionList
  • LocalEnvironment
  • InputRoot
  • InputBody
  • InputProperties
  • InputDestinationList
  • InputExceptionList
  • InputLocalEnvironment
  • OutputRoot
  • OutputDestinationList
  • OutputExceptionList
  • OutputLocalEnvironment.
Right-click the DataInsert icon and select Open Mappings from the pop-up menu.

If this is the first time that you have worked with mappings on this node, a new mapping file is created within your project and appears in the Resource Navigator view. It is named flowname_DataInsert.mfmap initially but you can rename it.

When creating mapping files, the overall file path length must not exceed 256 characters, due to a Windows file system limitation. If you try to add a message flow to a broker archive file with mapping or ESQL files with a path length that exceeds 256 characters, the compiled message flow will not be generated and cannot be deployed. Therefore, make sure that the names of your mapping files, ESQL files, projects, and broker schema are as short as possible.

The Mapping editor opens, allowing you to define your mapping input and output requirements.

Validation is performed when you save the mapping file. You can choose the level of validation that is performed by clicking Window > Preferences > ESQL and Mapping > Validation. Select one of the validation settings:
Related concepts
Mappings
Mapping types
Message mapping
Correlation names
Related tasks
Developing mappings
Opening an existing mapping file
Copying an existing mapping file
Deleting a mapping file
Related reference
Mappings