1 / 29

What's New in Business Connectivity Services (Evolution of BDC!)

What's New in Business Connectivity Services (Evolution of BDC!). Barry Boudreau Principal Technology Specialist Microsoft Corporation. Agenda. Challenges with Back-End Data Business Data Catalog 2007 Summary Introducing Business Connectivity Services Investment Areas Presentation

verdi
Download Presentation

What's New in Business Connectivity Services (Evolution of BDC!)

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. What's New in Business Connectivity Services (Evolution of BDC!) Barry Boudreau Principal Technology Specialist Microsoft Corporation

  2. Agenda • Challenges with Back-End Data • Business Data Catalog 2007 Summary • Introducing Business Connectivity Services • Investment Areas • Presentation • Demo: External data in SharePoint and Office • Connectivity • Tooling • How do I get it? • Q&A

  3. Challenges With Back End Data End User Challenges Multiple user interfaces External systems can be difficult to use Can't work with the data when and where I want to Can’t easily search for business data Need to involve IT to service my requests for data access IT Challenges Islands of business data Overhead for IT to service all user requests Manage security, auditing, connectivity One off projects for connecting to external systems

  4. Challenges With Back End Data Provide External Data in a Centrally Managed Way Bring external data into SharePoint and Office Business Connectivity Services

  5. BDC 2007 - Connect to Business Data • Connect SharePoint to any business application or structured database • SharePoint Provides: • Business Data in Search • Crawl back-end systems like ERP, CRM, Custom Databases, SAP, Siebel, etc • Business Data Web Parts • Display back-end data • Business Data in Lists • Add business data as list columns and as document metadata • Business Data in User Profiles • Add business data as properties in User Profiles

  6. BDC 2007 - Connect to Business Data Web Parts Lists Search User Profiles Custom Apps List Columns Search Index Profile Store Metadata Business Data Catalog WS Proxy ADO.NET Web Service Database BizTalk, SAP, Siebel, Legacy, … SQL Server, Oracle, OLEDB, ODBC

  7. Business Data Catalog – Summary Business Data Catalog Business Data Web Parts Business Data Columns Business Data Search

  8. Feedback on 2007 BDC • Read/Write • Read is nice… Write back would be even more powerful • Tooling Support • Need an easier way to create, debug and maintain appdef XML files • I wish it was baked into the Platform • Wouldn’t it be nice to use offline?

  9. A bit of Terminology… • Business Connectivity Services – All up • Business Data Connectivity (BDC) – plumbing, runtime, connectivity • External System – back ends • External Content Type (ECT) - a building block, entity++ • Model – XML file • External List – newest type of SP list

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

  11. External Content Type (ECT)The building block • Superset of entity capabilities; describes: • Structure of the external system (Fields, Methods, Connection) • How this data behaves within SharePoint and Office • Manage and reuse from a central location • Added to the Business Data Connectivity service through: • SharePoint Designer • Visual Studio 2010 • Import into the Business Data Connectivity service as part of a model

  12. External Content TypeThe building block SharePointWorkspace with InfoPath Forms Outlook Forms and Task Panes SharePoint External Lists External Content Type Customer CustomerID FirstName LastName EmailAddress Search Results External data Office Applications

  13. PresentationExternal Lists in SharePoint • Presentation • Connectivity • Tooling • Expose external data as a native SharePoint list • Full CRUD capability • Familiar UI and navigation • Sort, Filter, Group • Programmatic access via SPList OM • Profile page available for each item in the list • Form • Auto-generated OOB • Upsize to InfoPath • Offline-able

  14. Connect to Outlook as Contacts Tasks Calendars Posts PresentationOffline External List • Presentation • Connectivity • Tooling • Download to SharePoint Workspace as • Lists • Word doc libraries with external data columns

  15. PresentationSurfacing External Data • Presentation • Connectivity • Tooling • External Data Columns • Add data from external content types to standard SharePoint lists • Can be made available as Content Controls in Word • Web Parts Scenario: Use for Dashboard pages • External Data List  • External Data Item • External Data Item Builder • External Data Related List • External Data Connectivity Filter • Chart Web Part • External Data Search • Integrate External Data into search results

  16. Contoso Sales Solution External Systems Office Client Sales Database SharePoint Server

  17. Demo Overview Bring Customer data into SharePoint and Outlook • External Content Type • External List • Outlook integration Connect Product data from SharePoint to SharePoint Workspace • External List • InfoPath Forms • SharePoint Workspace integration Create a Sales Quote document in Word • External Data Column • Word Content Controls

  18. Using BCS: External Data in SharePoint & Office demo

  19. Connectivity Business Data Connectivity (BDC) Business Data Catalog (BDC) Presentation in SharePoint Business Data Connectivity (BDC) BDC Metadata Store BDC Client Runtime BDC Server Runtime Client Data Cache DB Connector WCF/WS Connector .NET Assembly Connector Custom Connector Client to Backend Direct Connection External data Custom .NET assembly SQL SAP ORACLE Siebel

  20. ConnectivityConnecting to External Data • Presentation • Connectivity • Tooling • Business Data Connectivity enhancements • Read/write capability • Claims aware • Connect via ADO/SQL, WCF/WS, .Net Assembly and Custom Connectors • Batch and bulk operation support • BDC used for Search indexing connectors • Added blob, incremental crawl and item level Security • Symmetrical server and client runtimes • Connect from client or server directly to external data • Rich client cache • SQL CE database is used to cache external data • Allows for “cached mode” behavior on external data

  21. ToolingAssemble Solutions via SharePoint Designer • Presentation • Connectivity • Tooling • Discover • Database • Web services • .NET type • Map operations • Create, read, update, delete, lookup • Connect to SharePoint/Office • External List • Contact • Task • Appointment • Post

  22. ToolingBuilding ProDev Apps using VS • Presentation • Connectivity • Tooling • Simple drag and drop experience • Create connectivity packs in Visual Studio to • Aggregate data across multiple back-ends • Perform custom data transformations • Execute custom business logic/rules (e.g., trigger workflow) • Upsize IT solutions created in SharePoint Designer • Bring external data into other Office clients with VSTO Add-Ins (e.g., Excel)

  23. Baked into the Platform… SharePoint Server 2010 Office 2010 Secure Store Service External Data Search Rich Client Extensions BDC Client Runtime Profile Pages External Data Web Parts SharePoint Foundation 2010 External List External Data Column Business Data Connectivity Service

  24. Business Connectivity ServicesKey Takeaways • Bring External Data into SharePoint and Office • Client/server connectivity with • Read/write • Online/offline • Tools for rapid assembly of business solutions declaratively • Baked into the Platfom

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

  26. 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!

  27. Connectivity Business Data Connectivity (BDC) Business Data Catalog (BDC) Presentation in SharePoint Presntation in SharePoint Business Data Connectivity (BDC) Business Data Connectivity (BDC) BDC Metadata Store BDC Metadata Store BDC Client Runtime BDC Server Runtime BDC Server Runtime Client Data Cache DB Connector WCF/WS Connector .NET Assembly Connector Custom Connector DB Connector WCF/WS Connector .NET Assembly Connector Custom Connector Client to Backend Direct Connection External data Custom .NET assembly SQL SAP ORACLE Siebel

  28. External Content Type The Building Block SharePoint Workspace with InfoPath Forms Outlook Forms andTask panes SharePoint External lists Search results Office Apps

More Related