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 fetch the corresponding document from SharePoint library.. External Data Connector will read the reference column value, query them against the list and if the item exists in the list, the metadata of that document will be modified.