The Data Reference workbook defines the data paths to your source dataset, target dataset, and data mapping workbooks. In addition to defining the data paths, the Data Reference workbook allows you to selectively query your source and target datasets.
-
Click the DataReference.xlsx
file to open the workbook.
The workbook opens, and the SourceTargetMapping sheet is active. This sheet defines the source, target, and mapping workbook paths, and other configuration settings.
- Configure the SourceTargetMapping sheet.
- Source—The source dataset location.
- SourceDefinitionQuery—Write an SQL query to select a subset of a source dataset to be mapped over to the target dataset.
- Target—The target dataset location.
- TargetDeleteQuery—Write an SQL query to selectively delete data from the target dataset before loading.
- MappingWorkbook—The link to the location of the Data Mapping workbooks in the Data Loading Workspace.
- Enabled—The default is true, meaning the mapping workbook will be included during data loading.
- MaintainAttachments—The default is true; attachments will be copied from the source features to the target features.
- PreserveGlobalIds—The default is false. Set this option to true to reuse the Global ID values of the existing source dataset when appending rows to a target dataset.
- Select the DataPath sheet to activate it, and update it if necessary.
This sheet defines the source and target workspace paths. By default, these paths are set based on your source and target datasets and only need to be modified if the location of either has changed.
- Workspaces—To redefine the locations of your source and target data, update the Workspaces column. This also updates the data paths on your SourceTargetMapping sheet.
- Click Save.
Learn more about the data reference options.