Business Connectivity Services and Creation in SharePoint

03 October, 2020


Related Blogs


Business Connectivity Services

What is "Business Connectivity Services" A Beginner View 

In this article, we will learn what is Business Connectivity Services, take a look at its key features, and some of the common usage scenarios.

What is "Business Connectivity Services" - Provides read/write access to external data within Microsoft SharePoint 2010 - Replaces BDC in the previous version.

Here is a short description of some of the new features - Provides read/write access to external data within Microsoft SharePoint 2010 - Write-back to external systems - In addition to view access to data, BCS allows write-back to external systems, thus providing true external system integration. To enable write-back or data updates, the external system must support the operations and must be modeled appropriately. - Online as well as Offline data access - End-user Ease-of-use and training curve - The end users can access features and data from multiple systems thus limiting the number of systems that need to be learned. Users can focus on a single point of access using familiar UI. - Extensible Provider Model: Provides an extensible model allowing developers to plug-in connectors for a new external system type - Batch and Bulk operation Support - Reads multiple items in a single call, thus reducing roundtrips to the backend and improving performance. - Blobs, Complex types - Blob data support added. Complex types supported using the dot notation. - Abstraction - allows developers to use an abstract entity model - the same application can be used to target different external systems that use the same entity model

Usage Scenarios

Here are some scenarios describing where BCS can be used: The obvious applications of BCS are in the integration with external systems into SharePoint applications. Examples include integration with databases, web/WCF Services, .Net Connection assemblies, Custom data sources - any external LOB system, in general. Another interesting scenario is the use of BCS in providing a common integration portal among different entry points. Eg. Using common standards, multiple vendor systems can be set up to feed into the Vendor Management System application for order status and invoices. Upgrade systems - SharePoint applications can be set up as the common face of an application that is expected to be upgraded/stabilized/replaced in the future. The common UI can be maintained and the backend LOB system can be replaced. Offline Data Access - A Sales LOB System can be exposed to a SharePoint application via BCS. Users can make use of the Offline Data Access feature to enter data offline and synchronize the data back when they are online.

External Content Types 

Represent definitions of external entities and can be re-used. Includes connectivity information, data definition, and behaviors for the entity. - Can be used in External Lists, External Data Columns, External Data Web Parts, External Content Type Picker, External Item Picker, and Profile Pages Business Connectivity Services (BCS) Services.   63  

Learn SharePoint by Tekslate - Fastest growing sector in the industry. Explore Online "SharePoint Training" and course is aligned with industry needs & developed by industry veterans. Tekslate will turn you into a SharePoint Expert.


Creating Business Data Connectivity Service using SharePoint Designer 2010 Open SQL Server 2008 and create a database named BCSForSharePoint2010. Create a new table named Trips as follows and Data entry:


Open SharePoint Designer 2010 and then open to port your site:

  • Sign in SPD
  • You wait a moment:
  • Navigation Menu | Site Objects you select External Content Types and interface as follows

External Content Types you create by selecting the Icon External Content Types


the initial interface is as follows:


Do you click on the link below to define data source 


then-new interface Connection | choose to Add Connection


a dialog box appears | select SQL Server


In the SQL Server Connection: -Database Server: the name of your server -Database Name: the name of your database -All to the following default


While you wait a moment for a connection  


After a successful connection, the interface is as follows: 


You must click on the table Trips, which is the action you choose to Create All Operations


Click on Next  


The selected columns appear to show up SharePoint List:

-TripID: Mapt to check the Properties window and check Show Print Picker Identifier


-Destination: In the Properties window check Show Picker


  • -The other columns you also check Show Print Picker you do, you click Finish


After the task to display the column you select Icon Creates List & Form as follows:


a dialog box appears; select Yes


  • Do you wait to save the configuration program A dialog box appears; click OK


Back to the list site you choose:


  • Select List Trips You will see the error occurs because users can not be added to services


  • Open Central Administration and select Manage service applications under the Applications Management section.
  • Then You choose Data Connectivity Business Service External content type you choose and select Icon Set Object Permissions as shown in below.


Add user and you choose the permissions for that user


Back to Site | Press F5 to refresh page error following results:


You can Edit Item


  • Edit and Save the Item
  • Edit Item was
  • SQL Server Back to the original value has not changed, click Execute SQL Icon

See the results in SQL Edit


  • So you've finished creating the Business Data Connectivity Service.

For an in-depth understanding of SharePoint click on


About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .