Microsoft Excel Connector > Mappings and Mapping Tasks with Microsoft Excel
  

Mappings and Mapping Tasks with Microsoft Excel

Use the Data Integration Mapping Designer to create a mapping. When you create a mapping, you configure a source to represent a single Microsoft Excel object.
In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.
Describe the flow of data from source and target along with the required transformations before the Secure Agent writes data to the target. When you create a mapping task, select the mapping that you want to use. Use the mapping task wizard to create a mapping task. The mapping task processes data based on the data flow logic you define in the mapping.