SharePoint Pals
 | Sign In
Creating Business Data Connectivity Service and External Content Type using SharePoint Designer 2010
by Mohamed Sithik 19 Feb 2013
SharePoint Developer, SharePoint Frontier
Today  :   5     Total  :    29196

This article shows how to create a Business Data Connectivity using external Content type through SharePoint Designer. Business Data Connectivity can be used to integrate with SQL database and SharePoint in your working scenario to manage data’s using SQL Server.

Step 1:

Open SQL Server and create a database named “Employee”. Then create a table named “EmpInfo” and create a column as show in a figure below


Step 2:

Go to Central Administration and click Manage Service application


Step 3:

Click the New button from menu, list of services will be listed. Then click the Business Data Connectivity services and configure them.


Step 4:

After connecting the Business Data Connectivity services. Open SharePoint Designer and click Central Administration


Step 5:

Click the External Content Types from the left menu


Step 6:

Click New External Content Types from the file menu


Step 7:

Click here to discover external data sources and define operations for connecting the external data source shown below


Step 8:

Add Connection button to connect the SQL Server


Step 9:

Choose the Data Source Type as SQL Server


Step 10:

Configure SQL Server as below and click ok


Step 11:

Now the SQL Server is connected and you will get the Employee Database connection Source


Step 12:

Click Table name Emp -> Tables ->EmpInfo then right click the EmpInfo and click the Create All operations


Step 13:

Then All operation will popped up. Click Next button


Step 14:

Parameter Configuration popped up and click Finish Button


Step 15:

Click Create Lists & Form Icon from Ribbon


Step 16:

Then Conformation Will be popped up and give “Yes” to save the changes


Step 17:

Enter List Name as Employee information and click ok button


Step 18:

Go to Central Administration

Click Site Actions->View All Site Content and EmployeeInformation will be listed there.


Step 19:

Click the New button from the menu


Step 20:

Add New item and Save it




Step 21:

Open SQL Server ->Choose the Database “Employee” and Check the “Emplnfo” table using Query analyser. Your data will be saved.


blog comments powered by Disqus

SharePoint Pals

SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile


Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community

SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to in a word document.

Related Resources

Recent Tweets

Twitter October 21, 21:34
How to Add a JS Link Reference to the Display Form or Any other ASPX Programmatically using CSOM PNP in SharePoint -

Twitter October 20, 13:01
How to Add a JS Link Reference to the NewForm and EditForm Programmatically using CSOM PNP in SharePoint Office 365-

Twitter October 12, 12:15
How to Deploy Provider Hosted Apps (Add-Ins) by App Stapling in SharePoint Office 365 -

Twitter October 11, 13:39
How to Deploy Provider HostedApp programmatically using CSOM in SharePoint Office 365 Activating Developer Feature -

Twitter October 10, 09:26
How to Use Angular HTTP Services in SharePoint List -

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation