A Data Transfer task moves data from a staging table to a data model. Mapping can be defined in a Data Import Definition. This task typically follows an automated data import.

For more information on data transfer, see the section Configure Automated Data Imports.

You can also use this task after loading data to a staging table using REST APIs. For more information, see Integration Toolkit.

The key parameters include:

ParameterDescription
NameEnter the name that appears on the task.
Import Definition

Select the Data Import Definition from the list. The Data Import Definition selected specifies:

  • The staging table to transfer from.
  • The data model to transfer to.
  • Any mappings that should be applied before the transfer.
Skip Data ValidationSelect the checkbox to ignore any errors and import valid records from the staging table to the data model. 
Track Data Import

Select the checkbox to enable tracking. The mapping details applied to the staging table source data as it is imported to the model are tracked.

For example, if during the import, source accounts 4010 and 4010-1 are mapped to target accounts 4010, this detail will be tracked and can later be viewed in the Data Imports Logs. For more information, see Data Import Logs.

Advance RuleSpecify how to advance to the task. The default is All predecessors have completed. 

To configure the Data Transfer task:

  1. Drag the Data Transfer task onto the Workflow Editor canvas to add it.
    Find the Data Transfer task in the Application section of the Workflow toolbox.
  2. Select the Data Transfer task and select the Edit icon to edit the parameters in the Task Configuration pane. 
  3. Fill in the required parameters. 
  4. Select OK to apply changes in the Task Configuration pane. 
  5. Select Save to save the workflow.
  6. Select Play in the Workflow Editor toolbar to start the workflow.