Transcript Todd Baginski Enterprise Solution Strategist Advaiya, Inc. OFC318 Agenda What is the Business Data Catalog? Why the Business Data Catalog? Business Data Catalog APIs Exposing the Business.

Todd Baginski
Enterprise Solution Strategist
Advaiya, Inc.
OFC318
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
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
The Business Data Catalog
Component Diagram
Business
Data Web
Parts
Lists
Search
User Profile
Importer
Custom
Solutions
Business Data Catalog
Metadata
Database
ADO.NET
Web Service Proxy
Data Sources
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!
Take a quick tour of the out of the box
BDC Web Parts and search capabilities
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
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
Exposing the Business Data Catalog
with WCF Services
Why do this?
Remote systems
Silverlight applications
SOA approach
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
Query and display BDC data in
Microsoft® Silverlight™ Applications
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
Resources
www.microsoft.com/teched
www.microsoft.com/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http://microsoft.com/technet
http://microsoft.com/msdn
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
Microsoft Certification and Training Resources
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
SharePoint Conference 2009 www.mssharepointconference.com
Dev Resources
SharePoint MSDN Web Site:
http://msdn.microsoft.com/sharepoint
SharePoint Developer Resources: http://mssharepointdeveloper.com/
ITPro Resources
SharePoint Tech Center: http://technet.microsoft.com/en-us/office/sharepointserver/
SharePoint Best Practices: http://technet.microsoft.com/enus/office/sharepointserver/bb736746.aspx
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.
Wednesday’s Picture is:
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.
Box shot
Attend an Interactive Theater Session and enter to
win a Microsoft ARC Mouse
Complete an
evaluation on
CommNet and
enter to win!
© 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.