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 | Creates a new source-target configuration file for the selected source and target datasets. | |
Data Mapper | Enables users to define the field mapping and settings for the selected source-target configure file. | |
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 Results in a local database using a subset of the records, skip final processing. | |
Append Data | Appends data into the target dataset from the source dataset according to the settings in the source-target configuration file. | |
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 | Optional settings for the data mapping tool. |