1 / 27

Business Connectivity Services in SharePoint 2010 and Office 2010

Business Connectivity Services in SharePoint 2010 and Office 2010. Name Title Company. Agenda. BCS Overview Investments Presentation Connectivity Tooling. Business Connectivity Services. SharePoint. Office Applications. Design Tools. BCS Client. Dev Platform. Business Intelligence.

dewey
Download Presentation

Business Connectivity Services in SharePoint 2010 and Office 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


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

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

  3. 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

  4. 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

  5. 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

  6. 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)

  7. BCS Server Features by SKU

  8. 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

  9. 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

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

  11. 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

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

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

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

  15. 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

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

  17. Error & Conflict Resolution • Connectivity Presentation • Tooling

  18. 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

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

  20. 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

  21. Presentation Rights – Suggested Settings • Connectivity • Tooling

  22. 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

  23. Business Connectivity Services Demo

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

  25. © 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.

More Related