Column Mapping

External Data Connector allows you to map metadata properties between data source and a SharePoint list

1. Column Mapping step will appear as shown below:
2. External Data Connector can automatically map columns for you if needed. Select Map columns automatically as in source to automate mapping. Column mapping will be done based on the column name.
3. Specify atleast one reference column, to proceed the operation. External Data Connector will use this column value to find the records to be added or deleted from data source.
4. On clicking the Preview button, External Data Connector shows the list of records to be added, deleted and modified in the data source.