• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Business Connectivity Services and Creation in SharePoint

What is “Business Connectivity Services” A Beginner View 

In this article we will learn what is Business Connectivity Services, take a look at it’s 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 which 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 into 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

 

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:

64

 

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

 

65

initial interface is as follows:

66

Do you click on the link below to define data source

 

67

then new interface Connection | choose Add Connection

68

 

dialog box appears | select SQL Server

69

 

In the SQL Server Connection:

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

70

 

While you wait a moment for a connection

 

71

 

After successful connection, the interface is as follows:

 

72

 

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

73

 

Click on Next

 

74

The selected columns appear to show up SharePoint List:

Interested in mastering SharePoint Training? Enroll now for FREE demo on SharePoint Training.

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

75

-Destination: In the Properties window check Show Picker

76

 

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

 

77

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

78

 

dialog box appears; select Yes

79

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

80

 

Back to the list site you choose:

81

 

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

 

80

 

  • 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.

81

 

Add user and you choose the permissions for that user

82

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

83

You can Edit Item

84

 

  • 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

85

 

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

For Indepth understanding of SharePoint click on

 

Summary
Review Date
Reviewed Item
Business Connectivity Services and Creation in SharePoint
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Business Connectivity Services and Creation in SharePoint"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.