Techbubbles

Business Data Connectivity Service Example

This post explains surfacing the Adventure Works table data in SharePoint. You can read my previous post on Business Data Connectivity Service terms here. Business Connectivity Services is the set of services and components that enables the connectivity between heterogeneous business systems. SharePoint 2010 Business Connectivity Services can be used to connect any data source to present the business data as SharePoint content.

   Before you start creating a BDC model, check BDC service is running by going to your SharePoint Central admin.

image

You may receive the below error message if your service is not being associated with your web application.

image

To correct the above error, start the Managed Metadata Web Service

image

Make sure you have associated the service with your Web Application. Go to Central Admin > Manage Web Applications > Select the Web Application > Click Service Connections in the Ribbon. In the dialog make sure that the BDC Service is checked.

image

1. To create an external content type using SharePoint Designer, Open the site and choose external content type from site objects menu.

image

2. From the Ribbon, in the new section select External Content Type then double  click the new external content type and type the name as shown below

image

3. Select the Operations Design View and click Add Connection button , In the dialogue box select the data source type to SQL Server as shown below

image

image

4.  After Connection has been verified, you should be able to see all objects in the database. Expand the table node and right click on Products table from the context menu select new Read item operation as shown below

image

In the Operations name text box, type the name and click next to continue

image

On the input parameters page, you can see ProductID is highlighted as an identifier. Define at least one identifier though you can add more than one identifier to the model. Accept the default settings by clicking next, On the Returns Parameter page, each field can be checked or unchecked. You cannot uncheck the identifier field.

image

Create an External List from External Content Type

Select the model external content type, then click on create lists & form button in the ribbon

image

In the dialogue box, select Create new external list as shown below

image

Click ok to create a new external list based on your model external content type.


Share this post :





Related Posts:

%d bloggers like this: