Click here to Skip to main content
Click here to Skip to main content

Business Connectivity Services in SharePoint 2010

, 20 Feb 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
Business Connectivity Services in SharePoint 2010

Introduction

Business Connectivity Services (BCS) were formerly known as Business Data Catalog (BDC) in SharePoint 2007. BDC is a one of the most powerful features of MOSS 2007 to integrate various Line of business (LOB) systems like SAP, Siebel, SQL Server and web services. Now BCS is extended to support .NET assemblies and WCF services as data source(s). Apart from read, update, delete and search, BCS data could be available for offline access.

BCS and SharePoint Designer 2010

BCS is improved a lot in terms of creating, managing and consuming. Now creation of BCS application is few clicks away, without writing a complex XML file (earlier I have written one article) in Visual Studio or using third party tools. SharePoint Designer 2010 is equipped to create new BCS applications, operations and associations very easily.

To create a new BCS application, first create a new external type. Under this, add a new connection. To create a new connection, click on Add Connection button and select one of the available data sources from .NET Type, SQL Server, WCF service and Web Service and provide connection information. After providing connection information, SPD will create all entities based on selected connection. Operations like create read operation, delete operation, update operation, create all basic operations and create associations, one-to-one associations, etc., is just a right click away.

bcs1.JPG

bcs3.JPG

BCS Operations

External Content Type

External content type is the metadata and connectivity information about external systems. This is the core idea behind the BCS features like external list, external column and external data search and offline access. External content types are content types defined in the Business data model and available as content type in the SharePoint.

External content type is made easy to consume external system data in SharePoint without knowing their complexities. Other benefits are re-usability, maintainability, securable, searchable and offline accessible.

External List

External List is a new kind of list in SharePoint 2010, and used in context of BCS applications. External list data doesn't store in the content database but the external list is mapped to the external LOB system, and data is pulled on demand. External can be made available offline in Microsoft Outlook and SharePoint Workspace. Changes in offline external list is propagated to external LOB system through synchronization.

BCS Development in Visual Studio 2010

SharePoint Designer 2010 workflow can interact with external lists. The read and write workflow activities for regular SharePoint lists have been extended to read external lists. So authoring experience is as simple as regular lists.

In Visual Studio 2010, we can create Business connectivity services and external content types. Visual Studio 2010 Business connectivity services template is available which contains a set of visual designer tools. By using these, developers write custom connectivity services to connect virtually any data source.

History

  • 20th February, 2010: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Aneesur Rehman Khan
Team Leader
India India
Anees is working as Sr. Team Lead based in Delhi(India).He is Post graduated in Computer applications and science.
 
He is having around 11 years of design,analysis and coding experience in Sharepoint, ASP.NET, C#, VB.NET, SQL Server 2000/05, Reporting Services,Analysis Services,VB 6.0 and Crystal Reports.

Comments and Discussions

 
GeneralActive or add Web service Pinmemberkhamid22-Jun-10 23:34 
GeneralRe: Active or add Web service PinmemberMohd Al-Basri18-Jul-10 22:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1411023.1 | Last Updated 20 Feb 2010
Article Copyright 2010 by Aneesur Rehman Khan
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid