Data Mapping Debugger

MapForce data mapping debug overview

Interactive Debugging

  • Set breakpoints on any input or output node
  • Conditional breakpoints based on built-in MapForce functions
  • All intermediate values displayed on the mapping pane
  • History available for all data mapping nodes
  • Debugging session includes user functions
  • Manual stepping options
  • View partial output during debug session

Download Trial

Debug Data Mapping Designs

MapForce includes a revolutionary interactive debugger to assist with data mapping design. The debugger allows users to single step through a mapping and see the data actually flow from the sources to the target nodes step by step along the way. The MapForce debugger is supported with menu commands, a special toolbar, and helper windows that are opened automatically while the debugger is running, so users can trace the intermediate processing operations and examine data values during mapping execution. The MapForce data mapping debugger gives users deep insight into the exact inner workings of your data integration and ETL projects in a way that was never possible before, not even in much higher-cost mapping products.

As a data mapping project executes, the debugger will pause at static or conditional breakpoints that have been defined, so you can trace the intermediate processing operations and examine data values. In the image above, the highlighted word “true” indicates the last generated value before execution paused at a breakpoint. Other intermediate data values are also displayed directly on the data mapping window.

Setting Debug Breakpoints

The MapForce debugger supports breakpoint functionality that will be familiar to developers experienced at debugging source code. Breakpoints can be placed on any input or output node, to pause mapping execution at that point, and conditional breakpoints are supported.

MapForce debug breakpoint dialog

Debug by Steps

MapForce supports several commands for stepping with various levels of granularity to manually debug a data mapping or continue execution after a breakpoint is reached, allowing users to view as much detail as they need.

MapForce debug history window

Dig into Debugging History

Debug helper windows open automatically and provide more information about everything that occurs during execution.

The user can select any node in the mapping and the History window will display a list of every value that passed through that node during execution.

View Partial Output

During a debugging session users can switch back and forth between the Mapping window and Output window to examine partial output generated so far, as seen at right.

If debugging reveals errors or flaws in the mapping design, the user can stop immediately, modify the mapping as necessary, then debug again to view the new output.

MapForce debug partial output window

64-bit

MapForce is available in 32-bit and 64-bit versions. Learn about the advantages of choosing the 64-bit data mapping tool when you have a 64-bit operating system.

Next Steps