This article explains step-by-step how to make an external content type using Microsoft Business Connectivity Services (BCS). BCSBCS, formerly named the Business Data Catalog, enables users to read and write data from external systems using web services, databases and Microsoft .NET Framework assemblies from within Microsoft SharePoint 2010 and Microsoft Office 2010 applications. Business Connectivity Services are a set of services and features that provide a way to connect SharePoint solutions to sources of external data and to define external content types based on that external data. This article contains a step-by-step guide to design an External Content Type from SQL Server.The following is my SQL database: Image 1My database table in Design mode: Image 2Now the next task is to create an external content type.Open SharePont Designer then open your site like the following: Image 3Click Open. Image 4Select External Content types then click on the External Content Type option. Image 5Now click here to discover an external data source and define the operation. Image 6Now click on Add Connection then select SQL Server -> OK. Image 7Enter your Database Server Name, Database name and Name (optional). Then click OK. Image 8Here expand your data table then right-click then select Create All Operations. Image 9Click Next. Image 10Set your table column as identifier then click Finish. Image 11Now save this using the top left Save button. Image 12Now open your site then select Site Actions -> More options. Image 13Select List -> External List then provide a name and click on Create. Image 14Now click on search and external content type then a pop-up window will open then search and select your External content type then click Ok. Image 15Now click Create. Image 16Your SQL Server Data.Now select an Item -> Add. Image 17Check your SQL Server Data Table also.If there is an error message while displaying data then go to Central Admin. Image 18Select Manage Service Applications. Image 19Select Business Data Connectivity Service. Image 20Be sure to set Object Permission and set Metadata Store Permission. They should be like the preceding.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: