Hide Notes 

Slide 1: Lab 6: Accessing a Business Data Catalog Objectives After completing this lab, you will be able to: • Expose data/content from a Business Data Catalog source onto the Portal Prerequisites Before working on this lab, you must have: • Labs 1, 2, and 5 must be completed Scenario In this lab, you will connect to the AdventureWorksDW SQL2005 database and expose some of its data onto a team site via the Business Data Catalog. Estimated time to complete this lab: 45 minutes Exercise 1 Create a Reseller Explorer application In this exercise, you’ll use the Business Data Web Parts to create an AdventureWorksDW Reseller Explorer application with no code. The application will allow you to view all resellers information made available by the Business Data Catalog created in lab 5. By clicking on a reseller name, you’ll be able to view more details on the reseller profile page. ∑ Create the SharePoint site where you will build the Reseller Explorer 1. Launch you browser and point it to http://hol.litwareinc.com to return to the portal site – (http://hol.litwareinc.com should be the default home page.) 2. 3. 4. 5. 6. Click on Sites in the top navigation bar. Click Create Site in the Site Actions menu at the top right In the Title field, type “Reseller Explorer” In the URL name field, type “resellerexplorer” In the Template Selection section at the bottom, select Team Site in the Collaboration tab.
Slide 2: Lab 6: Accessing a Business Data Catalog 7. 8. 9. Click Create Click Edit Page in the Site Actions menu Click Add a Web Part in the Left zone. 10. The Add Web Parts – Web Page dialog is displayed Check the BusinessDataList Web Part and click Add 11. A Business Data List Web Part has been added to the top of the Left zone. Click Open the tool pane link inside the Business Data List Web Part. 12. You might be prompted to click OK to navigate away from the current page. If so, click OK. Else, proceed to the next step. 13. In the Tool pane and in the type section, type Reseller and click Check Type. The Reseller (AdventureWorksDSSQL2005) type should now be displayed. 14. 15. 16. 17. 18. 19. list. Click Apply at the bottom of the Tool pane. (a large page should now be available) Click Ok in the Reseller List Tool pane Click “Exit Edit Mode” located at the top far right hand side of the page. In the first drop down list of the Web part, select Name In the select drop down, select contains In the last field enter “bike” and press Retrieve Data arrow just below the first drop down 20. You have now created a Business Data List Web Part that displays Resellers information and data from the AdventureWorksDW database. Exercise 2 Create a SharePoint list to track reseller feedback Microsoft Windows SharePoint Services V3 allows you to create custom field types. Microsoft Office SharePoint Server 2007 uses this feature to provide a new field type called Business Data available to all lists in SharePoint Server 2007. The Business Data field type enables users to add data from business applications registered in the Business Data Catalog to lists. ∑ This topic shows how you can add a Product column to a SharePoint list. 1. In the Reseller Explorer site, click Create from the Site Actions menu. The Create Page appears. 2. Click Custom List in the Custom Lists section. The New page appears. 3. Type Reseller Feedback in the Name field. 4. Click Create
Slide 3: Lab 6: Accessing a Business Data Catalog 3 5. Click Settings on the list toolbar (below Reseller Feedback) and select Create Column. The Create Column: Reseller Feedback page appears. 6. Type Reseller in the Column name field. 7. Select Business data bullet under the “The type of information in this column is”. Once selected, you will notice that the Additional Column Settings section will change to accommodate the Business Data Catalog settings. 8. Click on the Browse button located at the end of the Type field. 9. Select Reseller 10. In the “Add a column to show each of these additional fields:” section, check Number. 11. Keep the “Add to default view” check box checked 12. Click OK. The customize Reseller Feedback page appears. Notice both new columns: the Reseller and the Reseller: Number columns 13. Click New on the list toolbar and select New Item to add a new item to the list. The New Item page appears. 14. Type Love the white snow of Whistler Mountains in the Title field. 15. Click the browse button at the end of the Reseller field 16. Locate and select the Volume Bike Sellers reseller by performing a “Name” search on “bike” in the Choose Reseller Dialog page. 17. You should be back to the “Reseller Feedback: New Item” page 18. Click OK. The reseller name and number have been added to the list. 19. To get more information about this reseller from this list, click the down arrow beside the “Volume Bike Sellers” and select “View Profile” under the Reseller column. Once on that new page click the back button to return. Exercise Completed