Go Beyond With the Business Data Catalog

2. Go Beyond With the Business Data Catalog Todd Baginski Enterprise Solution Strategist Advaiya, Inc. OFC318

3. Agenda • What is the Business Data Catalog? • Why the Business Data Catalog? • Business Data Catalog APIs • Exposing the Business Data Catalog with WCF Services • Demos • Take a quick tour of the out of the box BDC Web Parts and search functionality • Use the BDC administration API to edit BDC metadata • Query and display BDC data in a custom Web Part • Query and display BDC data in a Microsoft® Windows Forms Application • Create a custom WCF Service to query BDC data • Query and display BDC data in Microsoft® Silverlight™ Applications • Questions and Answers

4. What is the Business Data Catalog? Queries, filters, and indexes data Integrates and exposes back end systems within Microsoft® Office SharePoint® Server Respects permissions of back-end systems Queries databases and Web services

5. The Business Data CatalogComponent Diagram Business Data Web Parts Lists Search User Profile Importer Custom Solutions Business Data Catalog Metadata Database ADO.NET Web Service Proxy Data Sources

6. Why the Business Data Catalog? Integrate other systems with SharePoint sites • Reporting dashboards • Line of business applications Integrate Business Data Catalog data into hybrid Windows Forms Applications Search for data in other systems via the SharePoint Search service Save the time, cost, and monotony of writing yet another data layer!

7. demo Take a quick tour of the out of the box BDC Web Parts and search capabilities

8. Business Data Catalog APIs • Administration API • Shared Service Provider Administration Web site functionality • Create, edit, delete metadata • Define security settings • Runtime API • Out-of-the-box BDC web parts • Search • Business Data Columns

9. demo Use the BDC administration API to edit BDC metadata

10. demo Query and display BDC data in a custom Web Part

11. demo Query and display BDC data in a Microsoft® Windows Forms Application

12. Exposing the Business Data Catalog with WCF Services • Why do this? • Remote systems • Silverlight applications • SOA approach

13. Exposing the Business Data Catalog With WCF Services • Approaches • Inside SharePoint Web Application • More complex • /_LAYOUTS/WCF/YourService • SPVirtualPathProvider • Provides site context • Outside a SharePoint Web Application • Simpler • No site context • Flexible authentication options • Safer for upgrades

14. demo Query and display BDC data in Microsoft® Silverlight™ Applications

15. Summary • What is the Business Data Catalog? • Why the Business Data Catalog? • Business Data Catalog APIs • Exposing the Business Data Catalog with WCF Services • Demos • Take a quick tour of the out of the box BDC Web Parts and search functionality • Use the BDC administration API to edit BDC metadata • Query and display BDC data in a custom Web Part • Query and display BDC data in a Microsoft® Windows Forms Application • Create a custom WCF Service to query BDC data • Query and display BDC data in Microsoft® Silverlight™ Applications

16. question & answer

17. Required Slide Speakers, TechEd 2009 is not producing a DVD. Please announce that attendees can access session recordings at TechEd Online. Resources • www.microsoft.com/teched Sessions On-Demand & Community • www.microsoft.com/learning • Microsoft Certification & Training Resources • http://microsoft.com/technet • Resources for IT Professionals • http://microsoft.com/msdn Resources for Developers www.microsoft.com/learning Microsoft Certification and Training Resources

18. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Track Resources Spin the Wheel: Attend SharePoint breakout sessions Mon-Thurs and collect the picture of the day. Come by the booth for a chance to spin the SharePoint wheel. Collect all 4 pictures and enter to win a Microsoft Arc Mouse, drawing 11:30am on Friday, game cards at the booth. Product Info http://www.microsoft.com/SharePoint Dev Resources SharePoint MSDN Web Site: http://msdn.microsoft.com/sharepoint SharePoint Developer Resources: http://mssharepointdeveloper.com/ • SharePoint Conference 2009www.mssharepointconference.com ITPro Resources SharePoint Tech Center:http://technet.microsoft.com/en-us/office/sharepointserver/ SharePoint Best Practices:http://technet.microsoft.com/en-us/office/sharepointserver/bb736746.aspx

19. Collect the SharePoint Session Picture of the Day Attend any SharePoint Breakout Session day 1 – 4 and check the last slide for a daily picture. Come to the TLC yellow area, SharePoint booths OFC 4 & 5 to spin the wheel for a chance to win a prize. The wheel only spins when the SharePoint spotlight is flashing. One spin per person. Collect all four daily SharePoint pictures and enter to win a Microsoft ARC Mouse. Game cards can be picked up at the booth. Drawing for Mice on Friday at the wheel at 11:30AM. Wednesday’s Picture is: Box shot Attend an Interactive Theater Session and enter to win a Microsoft ARC Mouse

21. Complete an evaluation on CommNet and enter to win!

22. Required Slide © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.