You will learn in this article how to create a Business Data Connectivity Service using SharePoint Designer 2010.
Open SQL Server 2008 and create a database named BCSForSharePoint2010. Create a new table named Trips as follows: Data entry: Open SharePoint Designer 2010 Open to port your site: Sign in SPD You wait a moment: Navigation Menu | Site Objects you select External Content Types interface as follows External Content Types you create by selecting the Icon External Content Types initial interface is as follows: Do you click on the link below to define datasource then new interface Connection | choose Add Connection dialog box appears | select SQL Server In the SQL Server Connection: -Database Server: the name of your server -Database Name: the name of your database -All to the following default While you wait a moment for a connection After successful connection, the interface is as follows: You must click on the table Trips, which is the action you choose to Create All Operations Click on Next The selected columns appear to show up SharePoint List: -TripID: Mapt to check the Properties window and check Show Print Picker Identifier -Destination: In the Properties window check Show Picker -The other columns you also check Show Print Picker you do, you click Finish After the task to display the column you select Icon Creates List & Form as follows: dialog box appears; select Yes Do you wait to save the configuration program A dialog box appears; click OK Back to the list site you choose: Select List Trips You will see the error occurs because users can not be added to services Fix: reference link ( http://blogs.msdn.com/b/ericwhite/archive/2010/ 06/11/access-denied-by-business-data-connectivity.aspx ) Open Central Administration and select Manage service applications You choose Data Connectivity Business Service external content type you choose and select Icon Set Object Permissions Add user and you choose the permissions for that user Back to Site | Press F5 to refresh page error following results: You can Edit Item Edit and Save Edit Item was SQL Server Back to the original value has not changed, click Execute SQL Icon See the results in SQL Edit So you've finished creating the Business Data Connectivity Service.
SharePoint Framework (SPFx) A Developers Guide