Whats New in Business Connectivity Services Evolution of
What's New in Business Connectivity Services (Evolution of BDC!) Michal Gideoni Senior Product Manager Microsoft Session Code: OFS 205
Feedback 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 offline?
Microsoft Share. Point 2010 The business collaboration platform for the Enterprise and the Web Connect and Empower People Cut Costs with a Unified Infrastructure Rapidly Respond to Business Needs 4
Share. Point Composites Enabling no-code collaborative solutions that balance self-service with control Rapidly create no-code collaborative solutions Unlock the value of your enterprise data Maintain control over end user solutions 5
Agenda Challenges with Back-End Data Introducing Business Connectivity Services Investment Areas Presentation Demo: External data in Share. Point and Office Connectivity Tooling Demo: External Content Type Designer in VS 2010 How do I get it? Q&A
Challenges With Back End Data End User Challenges IT Challenges Islands of business data Multiple user interfaces Overhead for IT to service all user requests External systems can be difficult to use Manage security, auditing, connectivity One off projects for connecting to external systems 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
Challenges With Back End Data
Investment Areas
demo
Business Connectivity Services Office Applications Design Tools Share. Point
External Content Type (ECT) Superset of entity capabilities; describes: Structure of the external system (Fields, Methods, Connection) How this data behaves within Share. Point and Office Manage and reuse from a central location Added to the Business Data Connectivity service through: Share. Point Designer Visual Studio 2010 Import into the Business Data Connectivity service as part of a model
External Content Type (ECT) BCS-enabled solutions rely on ECTs to integrate external data into Share. Point and the Office client applications Can be reused in External List Search Outlook Share. Point Workspace Word Info. Path Access Other Office applications via code
External Content Type Share. Point External Lists Share. Point Workspace with Info. Path Forms Outlook Forms and Task Panes External Content Type Customer. ID First. Name Last. Name Email. Address Search Results External data Office Applications
Presentation Connectivity Tooling Expose external data as a native Share. Point 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 Info. Path Offline-able
Presentation Key Differences No default fields – Title, Created (By), Modified (By) List Items don’t have a unique int 32 ID No Event notifications (eg. items being changed) Item level permissions provided by external source Read/Write depends on external source support Data stored in the External System List features that behave differently Search Lookup columns Paging (UX only; use filters to scope the view) Not supported RSS feeds Edit in Datasheet/grid view Export to Excel REST interface Presentation Connectivity Tooling
Presentation Connectivity Tooling Connect to Outlook as Contacts Tasks Calendars Posts Download to Share. Point Workspace as Lists Word doc libraries with external data columns
Presentation Connectivity Tooling External Data Columns Add data from external content types to standard Share. Point lists Can be made available as Content Controls in Word Web Parts Scenario: Use for Dashboard pages External Data List External Data Item Builder External Data Related List External Data Connectivity Filter Chart Web Part External Data Search Integrate External Data into search results
demo
Contoso Sales Solution External Systems Office Client Share. Point Server
Demo Overview Bring Customer data into Share. Point and Outlook • External Content Type • External List • Outlook integration Connect Customer data from Share. Point to Share. Point Workspace • External List • Info. Path Forms • Share. Point Workspace integration Create a Customer agreement document in Word • External Data Column • Word Content Controls
Connectivity Business Data Connectivity (BDC) BDC Client Runtime Client Data Cache BDC Metadata Store DB Connector WCF/WS Connector External data . NET Assembly Connector Custom Connector
Connectivity 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
Connectivity Presentation Connectivity Tooling OOB Support for: Windows Auth FBA Claims based Authentication modes Revert to Self Passthrough SSS Secure Store Service Can store windows creds or non-windows creds A credentials page is available to gather credentials from a user and store it in SSS Extensibility through ISSSProvider to plug in another SSO
Connectivity Presentation Connectivity Tooling Share. Point Server Process Account External List Web. Part Logged-on user Credentials Ticket Delegation Token Other BCS Runtime Application Secure Store Service SAML Token Claims Aware Service Application Delegated Token Credentials Web 2. 0 Legacy LOB Pass. Through (Uses logged-on user) Revert. To. Self (Uses process account) SSO Authentication (Credentials, etc. from Secure Store )
Support Matrix Popular Auth WCF types Connector SQL Auth Connectivity Tooling DB Connector n/a . NET Assembly Connector In code Username & Password NTLM Pass through Or Kerberos Claims Token Oauth / Live. ID Presentation In code x In code
Tooling Presentation Connectivity Tooling Assembly No-code solutions in SPD External Content Type definitions Form layout and validation Workflow integration Build Pro-Dev Solutions in Visual Studio Create reusable components (UI parts, ECTs, actions) Custom Office Integration (add-ins) Custom connectivity. Net Assembly Connector Custom Connector Code-based business logic
Solution Types • Surface data in External Lists • Connect those lists to Outlook, SPW Simple Create reusable components (UI parts, ECTs, actions) Intermediate Advanced
Tooling Discover Database Web services. NET type Map operations Create, read, update, delete, lookup Connect to Share. Point/Office External List Contact Task Appointment Post Presentation Connectivity Tooling
Tooling 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 Share. Point Designer Bring external data into other Office clients with VSTO Add-Ins (e. g. , Excel)
demo
Lifecycle Management Presentation Connectivity Tooling Part of WSP-based Share. Point application packaging, deployment, and administration Deploy solution to Server and Client Artifacts are packaged into a single versioned unit Solution Package is published to Share. Point Deployed to Office Client using Click. Once Application upgrade management
Investment Areas
Baked into the Platform… Secure Store Service External Data Search Profile Pages External List Rich Client Extensions BDC Client Runtime External Data Web Parts External Data Column Business Data Connectivity Service
Business Connectivity Services Bring External Data into Share. Point and Office Client/server connectivity with Read/write Online/offline Tools for rapid assembly of business solutions Baked into the Platform
Related Content Breakout sessions OFS 212 - Microsoft Share. Point 2010 Overview OFS 202 - Overview and What's New in Microsoft Share. Point Server 2010 for IT Pros OFS 215 - Microsoft Share. Point Server 2010 Introduction for Developers OFS 211 - Introduction to the Microsoft Visual Studio 2010 Share. Point Tools OFS 03 -IS - Capacity and Performance Management in Microsoft Share. Point Server 2010 OFS 208 - Microsoft Share. Point Online 2010 OFS 207 - Overview of Enterprise Content Management in Microsoft Share. Point Server 2010 OFS 209 - Microsoft Share. Point Online Overview: Today's World OFS 322 - Share. Point Social Networking and User Profiles for Business OFS 210 - Search in Microsoft Share. Point Server 2010 OFS 220 - Introduction to Microsoft Share. Point Designer 2010: Top Ten Great Things to Know OFS 02 -IS - Upgrading from Microsoft Office Share. Point Server 2007 to Share. Point Server 2010 OFS 204 - Microsoft Business Intelligence in Office Systems OFS 04 -IS - Workflow Development in Microsoft Share. Point Server 2010 OFS 321 - Building Powerful Business Intelligence Solutions on the Share. Point 2010 Platform OFS 05 -IS - Microsoft FAST Search Server 2010 for Share. Point OFS 217 - Building Solutions with Business Connectivity Services Using Microsoft Visual Studio 2010 OFS 203 - Introduction to Service Applications and Topology in Microsoft Share. Point Server 2010
Learn More about Share. Point 2010 Information for at Tech. Net at MSDN IT Pros Developers Information for Everyone http: //MSShare. Point. ITPro. com http: //MSShare. Point. Developer. com http: //Share. Point. Microsoft. com
question & answer
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
Complete an evaluation on Comm. Net and enter to win an Xbox 360 Elite!
© 2009 Microsoft Corporation. All rights reserved. Microsoft, 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.
- Slides: 41