Salesforce

Data Mapper Configuration Details (Magic xpi 3.x)

Printable View
« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Data Mapper Configuration Details (Magic xpi 3.x)

Enter the following configuration details for the Data Mapper Service in the Data Mapper Configuration dialog box.

Parameter

Description

Name

A name that describes the Data Mapper service in the flow.

Description

A description of the service in your flow (optional).

Processing mode

Select whether the step should be executed linear, parallel or stand-alone. This is only available if the Data Mapper is not the first step in the flow.

Wait for completion

Select whether the step should be run in Wait for Completion mode. The options are Yes or No.

Note:

Wait for completion is only available when the Data Mapper service is a Linear step and if it is not the first step in the flow.

Save Point

Select Yes to indicate that the step is a Save Point in your flow. This is available only if the flow's Recovery Policy is set to Save Point.

Error behavior

The step behavior if an error occurs at this step in a flow. Select one of the following from the drop-down list:

  • Continue (default): All mappings defined in the step are executed and the error policy defined is carried out at the end of the step. When the transaction is in Record level, a rollback has to be issued on that record and the Data Mapper continues to the next record. When no other error handling is defined, all errors caused during database operation, and not just the last error found, are written to the Monitor by the Data Mapper.

  • Exit: the step execution ends immediately and the error policy defined for the flow is executed. Any mapping defined after the point where the error occurs is not executed.

For a list of Data Mapper errors, click here.

DB Transaction Level

Select one of the following from the drop-down list:

  • Mapper (default): This executes the database transaction for all Database-type Data Mapper Destinations. All Data Mapper database modifications are part of the same transaction. The rollback procedure rolls back all database modifications performed by the Data Mapper. All records that were added or updated are rolled back. If the error behavior defined above is Continue, the error will be handled according to the defined settings and the Data Mapper will continue its operation with no rollback. If the error behavior defined above is Exit, and the error was not handled, all updated step records in all Destination databases will be rolled back.

  • Record: This runs each record as a separate transaction for all Database-type Data Mapper Destinations. If a failure occurs in a specific record, the error behavior that you defined in the Error behavior field (above) is triggered for that record only. Only this record is rolled back in all its Destinations. If the error behavior defined above is Continue (default), the error will be handled according to the defined settings and the Data Mapper will continue its operation with the next record. If the error behavior defined above is Exit, the step execution will be terminated.

  • Auto Commit: This instructs the database to commit each SQL statement automatically, provided there are no prior open transactions on the same context (Magic xpi does not support nested transactions). In cases where a transaction is already open, the Data Mapper joins this transaction and ignores the DB Transaction Level value. If you want to connect to a remote database and perform a record level transaction, selecting Auto Commit will significantly enhance performance. This means that there will be a marked decrease in the time taken to complete the transaction. Since version: V3.2

You can define which databases this transaction is performed on. Any database resource that was not defined as part of the transaction will perform the auto commit procedure, regardless of the selected transaction level in the step.

To do this, click to open the Database Resources List. Select a database from the list, and then click OK.

Note:

  • A database transaction defined at the step level is ignored if there is a transaction defined at the flow level. However, in DB2/400 databases, if Auto Commit is selected in an Insert operation or the WITH NC keyword is added to the SQL statement in Delete and Update operations (regardless of transaction type), the step level is not ignored.

  • Call flows from the Data Mapper will be part of the same transaction. All databases that take part in the process including databases used only in the called flow, have to be defined in advance. For Rollback and Commit, you should expect unpredictable behavior if not all databases are defined.

  • If a transaction cannot be opened, an error message will be displayed.

  • The DB Transaction Level cannot be defined as Record when a DB/400 Source contains BLOB data type fields. You should use a Mapper level transaction instead.

Magic xpi Server

Select the Magic xpi Server where the Data Mapper service should be executed.

Click to open the Servers List. Select a server from the list and then click Select.

Call logic flow

You can use this option if you want to call generic logic after the execution of a specific step. Once this step has been executed, the flow logic that you defined in the flow properties is called before the Server continues to the following steps.

The options are Yes or No (default).

    Reference
    Attachment 
    Attachment