Creating a SharePoint External Data (BCS) column is very similar to creating any other column in your Metabase project.
To create External Data (BCS) Columns:
1.Make sure you are connected to the target SharePoint server (currently only Local Object Model and Metalogix Extensions Web Service connections are supported).
2.In the Explorer View, select any directory in your file system connection that contains documents.
3.Switch to the Items View.
5.Select the drop down arrow next to the [Manage Column] button, and choose New Column to display the Add Column dialog
6.Click [Manage Columns] to display the Manage Columns dialog then click the Add icon.
5.Enter a Property Name for the BCS column.
6.For Type, select SharePoint External Data (BCS) from the drop-down to display the Select SP Server Connection dialog.
7.Specify the details of the SharePoint connection, and external content type the new column should be associated with. The details must be specified in the following order.
a)SharePoint Connection - The active SharePoint connection from which to load external content types.
b)External Content Type - The specific external content type to be associated with the column.
c)Display Property - The external content type column that will be displayed.
8.Click [OK] to accept the selected external content type information and return to the Add Column dialog.
9.Specify the Description, Category, and Display Name for this new external data column. Only the Category option is required from these three fields, and it will be set to Misc by default.
10.Click [OK] to close the dialog, and create the new column.
The new column is added to your Metabase connection.