Creating Business Data Connectivity Service and External Content Type using SharePoint Designer 2010


Mohamed Sithik
SharePoint Consultant
Published On :   19 Feb 2013
Visit Count
Today :  11    Total :   31347



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

clip_image001

Step 2:

Go to Central Administration and click Manage Service application

clip_image003

Step 3:

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

clip_image005

Step 4:

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

clip_image007

Step 5:

Click the External Content Types from the left menu

clip_image009

Step 6:

Click New External Content Types from the file menu

clip_image011

Step 7:

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

clip_image013

Step 8:

Add Connection button to connect the SQL Server

clip_image015

Step 9:

Choose the Data Source Type as SQL Server

clip_image017

Step 10:

Configure SQL Server as below and click ok

clip_image019

Step 11:

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

clip_image021

Step 12:

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

clip_image023

Step 13:

Then All operation will popped up. Click Next button

clip_image025

Step 14:

Parameter Configuration popped up and click Finish Button

clip_image027

Step 15:

Click Create Lists & Form Icon from Ribbon

clip_image029

Step 16:

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

clip_image031

Step 17:

Enter List Name as Employee information and click ok button

clip_image033

Step 18:

Go to Central Administration

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

clip_image035

Step 19:

Click the New button from the menu

clip_image037

Step 20:

Add New item and Save it

clip_image039

 

clip_image041

Step 21:

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

clip_image043

Categories