Creating Business Data Connectivity Service using SharePoint Designer 2013 in SharePoint 2013

business data connectivity service sharepoint 2016
InfoPath alternatives for form designing SharePoint

In this post we will discuss how we can create business data connectivity service using SharePoint designer 2013 in SharePoint 2013. Business Connectivity Services (BCS) provides the infrastructure that enables SharePoint to bring data from those external systems into a central system.

Read some SharePoint online tutorials:
– Download FREE PDF on HUB site in SharePoint online

– SharePoint Online modern experience

– SharePoint Online branding Creating Tabbed Menu using Bootstrap and HTML in SharePoint 2016/2013

1. Open SQL server 2012 and create a database name BCSDB and Table and add some item. See in fig

business data connectivity service sharepoint 2013
business data connectivity service sharepoint 2013
business data connectivity service sharepoint 2010
business data connectivity service sharepoint 2010

2. Now Open SharePoint Designer and Open your site in SharePoint designer 2013.

3. Now in Left Navigation Menu, under Site Object you select External Content Types. See in fig

business data connectivity service sharepoint 2016
business data connectivity service sharepoint 2016

4. External Content Types you create by selecting the Icon External Content Types from ribbon. See in fig and form is appear See in second fig

business data connectivity service sharepoint online
business data connectivity service sharepoint online

business data connectivity service sharepoint 2013 configuration

business data connectivity service sharepoint 2013 configuration5. Now you click on the link below to define datasource. See in fig and fill the details

business connectivity services sharepoint 2016
business connectivity services sharepoint 2016

6. Now choose Add connection. See in fig

create external content type in sharepoint online
create external content type in sharepoint online

7. Dialog box appears and select SQL server. See in fig

create external content type sharepoint 2013
create external content type sharepoint 2013

8. In the SQL Server Connection add the following details –
– Database server : the name of your server
– Database Name : the name of your database
– All to the following default. See in fig

create external content type sharepoint 2010
create external content type sharepoint 2010

9. While you wait a moment for a connection. See in fig

create external content type sharepoint 2016
create external content type sharepoint 2016

10. After successful connection, see in fig.

create external content types using sharepoint designer 2013
create external content types using sharepoint designer 2013

11. Now you right click on the Table, which is the action you choose to Create All Operations. See in fig

create external content types using designer
create external content types using designer

12. Click on Next

external content type sharepoint 2010 step by step
external content type sharepoint 2010 step by step

13. The selected columns appear to show up SharePoint List :
– ID : Map to Identifier check the Properties window and check Show In Picker Identifier. See in fig
– ColumnName : In the properties window check Show Picker. See in fig
– The Other columns you also check Show In Picker

external content type sharepoint 2013 step by step
external content type sharepoint 2013 step by step
connect sql server to sharepoint 2013
connect sql server to sharepoint 2013
connect sql server to sharepoint 2016
connect sql server to sharepoint 2016

14. Click on finish. See in fig

connect sql server to sharepoint online
connect sql server to sharepoint online

15. After the task to display the column you select Icon Creates List & Form. See in fig

Create external content types for SQL Server in SharePoint
Create external content types for SQL Server in SharePoint

16. Dialog box appears: Select yes

Create external content types for SQL Server in SharePoint 2013
Create external content types for SQL Server in SharePoint 2013

17. Wait to save the configuration program.

18. A dialog box appears: Click ok. See in fig

Create external content types for SQL Server in SharePoint 2016
Create external content types for SQL Server in SharePoint 2016

19. Back to your site and Select the list. See in fig

Create external content types for SQL Server in SharePoint online
Create external content types for SQL Server in SharePoint online

20. You will see the error occurs because users cannot be added to services. See in fig

create external list sharepoint 2013
create external list sharepoint 2013

21. For adding User in BCS services, go to central administration and Select Manage service application under Application Management. See in fig

sharepoint 2013 connect to external data source
sharepoint 2013 connect to external data source

22. Now you choose Business Data Connectivity service

sharepoint 2013 connect to sql server
sharepoint 2013 connect to sql server

23. External content type you choose and select Set Object Permission from ribbon. See in fig

sharepoint to sql server
sharepoint to sql server

24. Here add user and you choose the permissions for that user. See in fig

sharepoint connect to sql server
sharepoint connect to sql server

25. Back to your site and Press F5 to refresh page error, then see the following results. See in fig

connect sharepoint list to external data source
connect sharepoint list to external data source

26. You can edit Item and save it. See in fig

sharepoint online external data
sharepoint online external data

27. Now back to the SQL server and Execute query for showing the result in Table. See the changes. See in fig

Creating Business Data Connectivity Service using SharePoint Designer 2013
Creating Business Data Connectivity Service using SharePoint Designer 2013

Hope this article will be helpful.

Similar SharePoint 2013 Tutorials


About Navneet Singh

I am Navneet Singh, Working at C3it software solutions pvt. ltd. in Pune. My core skills are SharePoint 2013, Office 365, SharePoint 2010, SharePoint Designer, SharePoint Designer Workflow, Nintex Workflow, Infopath, Webpart, CSOM/SSOM, Power-shell, C#, ASP.NET and SQL Server.

View all posts by Navneet Singh →

Leave a Reply