A quick tour of Data Assistant

The Data Assistant Add-In includes a set of focused tools that are organized on an Data Assistant toolbar. These tools enable you to create data mapping files and load or replace data in your target datasets.

Data Assistant toolbar

The Data Assistant toolbar includes a series of tools for creating mapping files and loading data.

Tool Tool Name Description
New File New File Creates a new source-target configuration file for the selected source and target datasets.
Data Mapper Data Mapper Enables users to define the field mapping and settings for the selected source-target configure file.
Preview Preview Creates a preview of the output from the source-target configuration file in a local database with a sub-set of records.
Stage Stage Stage Results in a local database using a subset of the records, skip final processing.
Append Data Append Data Appends data into the target dataset from the source dataset according to the settings in the source-target configuration file.
Replace Data Replace Data When the Replace By Field Value option has been enabled and configured, replaces data in the target dataset from the source dataset according to the settings in the source-target configuration file.
Settings Settings Optional settings for the data mapping tool.
Top