Business Connectivity Services in SharePoint 2010 and Office 2010

2. Business Connectivity Services in SharePoint 2010 and Office 2010 Name Title Company

3. Agenda • BCS Overview • Investments • Presentation • Connectivity • Tooling

4. Business Connectivity Services SharePoint Office Applications Design Tools BCS Client Dev Platform Business Intelligence Enterprise Content Management Collaboration Social Enterprise Search SharePointDesigner External Lists External Content Type Repository Visual Studio Business Data Connectivity LOB Web Service WCF DB Web 2.0

5. Investment Areas • Extend Office and SharePoint‘s UX and capabilities to external data and processes • Presentation • Read-write capable connectivity from client and server to databases, WCF/WebServices and .NET sources • Connectivity • Integrated tooling experience scales from simple solutions to advanced pro-dev apps with rich client packaging and deployment • Tooling

6. Data & Connectivity SharePoint Client BCS in Office Client BCS in SharePoint Identity Federation service BCS Meta Data Store Client Data Cache BDC BDC DB Connector WCF /WS Connector .NET Assembly Connector ASCustom Connector Client to Backend Direct Connection External data Persistence Store Custom .NET assembly Data Cubes SQL SAP ORACLE Siebel

7. External Content TypesThe building block Describes the schema and data access capabilities of an external data source and its behavior within Office and SharePoint *formerly known as BDC Entity Office Clients (Rich) BCS External Data Source (Web Service, DB, .Net object, LOB system, Web 2.0 service, etc.) External Content Type (ECT) BCS BCS-enabled solutions rely on ECTs to integrate external data into SharePoint and the Office client applications SharePoint (Thin)

8. BCS Server Features by SKU

9. External Data is Surfaced In… • Connectivity Server • External lists • Web parts • Business Data • XSLTListView, XSLTListForm, Chart Web Part, InfoPath • External Data Column • Workflow • Search • External Content Type (ECT) Picker • ECT Instance Picker Client • SharePoint Workspace • Outlook • Can be extended to include Taskpane • Word • External Data Picker Presentation • Tooling

10. External Lists • Connectivity • Looks and feels like a SharePoint List • Sandbox Solutions • Silverlight • Custom client applications • InfoPath, Access • External content types as their data sources • Business Entity Metadata • Write back to business system • Doesn’t live in SharePoint DB Presentation • Tooling

11. External Lists: Limits • Connectivity • New columns • Workflow • Content types • Versioning • Check-in/check-out. • Rating • Managed Metadata Presentation • Tooling

12. External Data Columns • Connectivity • Business Data list column type • External Data • Read-only • Scenarios: • Tagging a document in a list • Extend or annotate without change • Pick values from a list Presentation • Tooling

13. External Content Type Picker • Connectivity • Create a column • Picking and resolving • Rich client support Presentation • Tooling

14. External Content Type Instance Picker • Connectivity • Choose an Item • Rich client support • Example, Choose a customer Presentation • Tooling

15. External Data Web Parts • Connectivity • No required coding • Connections • Customization • SPD and XSLT • Read-Only Presentation • Tooling

16. SharePoint WorkspaceThe next generation of the product formerly known as Groove • Connectivity • Offline capable • InfoPath forms UI (customizable) • Respects SharePoint view settings (filter/sort/group) • Error/conflict resolution • Search across business data Presentation • Tooling

17. Building Outlook Solutions • Connectivity • Offline Capable • Define ECTs to have behaviors • Error/conflict resolution Presentation • Tooling

18. Error & Conflict Resolution • Connectivity Presentation • Tooling

19. Presentation Connectivity • Connectivity • Business data connectivity enhancements • Read/write capability • Batch and bulk operation support • Claims aware • Connect via ADO/SQL, WCF/WS, .Net Assembly connectors • Symmetrical server and client runtimes • Connect from client or server directly to external data • Rich client cache • Allows for “cached mode” behavior on external data • Tooling

20. Presentation Business Data Connectivity Service Application • Connectivity • Setup • Farm Configuration Wizard • Manage Service Applications • PowerShell • Can be shared across farms • Delegated Administration • Tooling

21. Presentation What can be administered in the Business Data Connectivity service? • Connectivity • External content types • External data sources • Permissions • Associations • External data source instances • Authentication • Application models and resource files • Tooling

22. Presentation Rights – Suggested Settings • Connectivity • Tooling

23. Presentation Tooling • Connectivity • Simple solutions in SPD • External Content Type definitions • Workflow integration • Advanced Pro-Dev Solutions in Visual Studio • Code-based business logic • Custom connectivity • Tooling

24. Business Connectivity Services Demo

25. Summary • BCS Overview • Investments • Presentation • Connectivity • Tooling

27. © 2010 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.