Demonstration Scenario-2010 Share Point 2010

To demonstrate the capabilities of BCS, we’ll design and build a simple application based on the following scenario: You’ve been asked to develop an application for the marketing department of Adventure Works Corp. that will assist them in building a repository of competitive analysis data. The repository will consist of a series of reports comparing the company’s product models with competing products from other vendors. Adventure Works has an ERP system in place that maintains details of all product models and associated products. Since product data is maintained in a separate ERP system, we’ll use BCS to surface this data in SharePoint. Additionally, we’ll attach Internet-based content by developing a connectivity assembly. Once these connections have been defined, we’ll be able to create a new document library to hold the reports. We’ll add columns to the reports library to allow the selection of the appropriate product model from the ERP system and a link to the competing product on an external web site.

To provide some sample data to work with in our various examples, you’ll need to download and install the SQL Server 2008 sample databases,. Our code examples make use of the AdventureWorks OLTP database installed on the local instance of SQL Server 2008. As well as connecting to a database, we also need to retrieve search results from To make use of the web service API, we must first generate a unique application ID (AppID) that can be used within our code. To create a new site for our sample application, take the following steps:

  1. Open SharePoint Designer.
  2. Click the New Blank Web Site button.
  3. In the dialog that appears, enter the name
  4. Click on OK to create the site.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Share Point 2010 Topics