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.
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
Go to Central Administration and click Manage Service application
Click the New button from menu, list of services will be listed. Then click the Business Data Connectivity services and configure them.
After connecting the Business Data Connectivity services. Open SharePoint Designer and click Central Administration
Click the External Content Types from the left menu
Click New External Content Types from the file menu
Click here to discover external data sources and define operations for connecting the external data source shown below
Add Connection button to connect the SQL Server
Choose the Data Source Type as SQL Server
Configure SQL Server as below and click ok
Now the SQL Server is connected and you will get the Employee Database connection Source
Click Table name Emp -> Tables ->EmpInfo then right click the EmpInfo and click the Create All operations
Then All operation will popped up. Click Next button
Parameter Configuration popped up and click Finish Button
Click Create Lists & Form Icon from Ribbon
Then Conformation Will be popped up and give “Yes” to save the changes
Enter List Name as Employee information and click ok button
Go to Central Administration
Click Site Actions->View All Site Content and EmployeeInformation will be listed there.
Click the New button from the menu
Add New item and Save it
Open SQL Server ->Choose the Database “Employee” and Check the “Emplnfo” table using Query analyser. Your data will be saved.