Data Mapper Database Destinations (Magic xpi 3.x)

When working with a Data Mapper step that includes a database Destination, the behavior is a bit different. Magic xpi will first search for a an error handling flow defined at the step level (in the Exception Handling Flow property in the Database Schema Properties dialog box). From this field, you can select a flow that you have set up to handle errors at the Destination level. (Each database Destination can have a different Exception Handling flow.)

When the error handling flow is called from this property, the error handling flow can also map specific values from the failed statement to the flow variables of the error handling flow.

In the Node Properties dialog box, when working with databases, you can use the Log Error property. You can select the flow variables that will accept the input data in the Exception Handling Flow.