Export (0) Print
Expand All

Create an external list for a Business Connectivity Services on-premises solution in SharePoint 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013, SharePoint Foundation 2013

Topic Last Modified: 2013-12-18

Summary: Create an external list, set its permissions and configure a view for a Business Connectivity Services (BCS) on-premises scenario deployment in SharePoint 2013.

An external list is a key building block for SharePoint solutions based on external data. You can read and write external data with the familiar experience of using a SharePoint list. An external list looks and behaves a lot like a native list, but there are some differences in behavior. For example, you can create views and use calculated values with formulas, but not attach files or track versions. For this exercise, you create the external list in the browser because that is a common approach. This article uses the procedures in Create an external list on Office.com. You must open that article and perform the steps there using the parameters given in the matching sections of this article.


ImportantImportant:
This is Step 9 in the Business Connectivity Services On-Premises scenario deployment procedures.


Create an external list
  1. Open Create an external list

  2. Create an external list named AdventureWorksCustomers using the AWCustomers external content type.

Create a view of an external list
  1. Create a view for the external list AdventureWorksCustomers. For this example use ByRegion Data Source Filter.

  2. Make it the default view, and select your own Sort, Filter, and Limit values.


ImportantImportant:
Link to Step 10 Manage user permissions on an external list for a Business Connectivity Services on-premises solution in SharePoint 2013 of the Business Connectivity Services On-Premises scenario deployment procedures.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft