Building Business Applications using BCS using SharePoint Designer

2. Chakkaradeep Chandran (Chaks) Solutions Specialist Intergen Building Business Applications using BCS & SharePoint Designer 2010

3. Agenda Overview of Business Connectivity Services (BCS) Building BCS Solutions using SharePoint Designer 2010 BCS Authentication Workflows and BCS BCS Limitations More demos�

4. What is BCS A set of features that provide the capability to connect SharePoint 2010 and Office 2010 applications to any external system: Line-of-Business system (Microsoft Dynamics, Oracle, or Siebel) Web 2.0 service Custom home-grown application Provides read/write capabilities to those external systems It provides out-of-box features, services and tools that streamline development to deeply integrate external data and services

5. What about Business Data Catalog (BDC) Introduced in Microsoft Office SharePoint 2007 Read/Write Support 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 take it offline?

6. BCS Features Write-back to External Systems Familiar UI More Connectivity Options Extensible Provider Model Batch and Bulk Operation Support Read BLOBs Read and Write-back of Complex Types Life Cycle Management Rich Client Integration

7. BCS Tooling Support

8. Business Connectivity Services

9. BCS Connectivity

10. External Content Types Superset of entity capabilities: 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/Export BCS-enabled solutions rely on ECTs to integrate external data into SharePoint and the Office client applications

11. External Content Types

12. Presentation Features External Lists External Data Columns Business Data Web Parts External Content Type Picker External Item Picker Profile Pages Presentation Features in Office 2010

13. External Lists 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. Surfacing External Data External Data Columns Add data from external content types to standard SharePoint lists Can be made available as Content Controls in Word Web Parts (SharePoint Server 2010) Business Data List� Business Data Item Business Data Item Builder Business Data Related List Business Data Connectivity Filter Chart Web Part External Data Search (SharePoint Server 2010) Integrate External Data into search results

15. Solution Types Surface data in External Lists Connect those lists to Outlook, SPW

16. BCS Hello World Demo

17. Authentication in BCS OOB Support for: Windows Authentication Forms Based Authentication Claims based Authentication Authentication modes Revert-to-Self (process account) Pass-through (logged on user) Single Sign On (Secure Store) Secure Store Service Can store windows credentials or non-windows credentials A credentials page available to gather credentials from a user & store it in SSS Extensibility to plug in another SSO

18. Authentication in BCS

19. Permissions in BCS

20. Using Secure Store Service with BCS

21. BCS Associations

22. BCS Associations Supported Associations One-to-many Associations - based on a foreign key A foreign key must be present in the External system Un-Supported Associations Many-to-Many Associations � no foreign key Users will have to develop these Associations in the XML of the BDC Model files manually using an XML editor or through another External Content Type designer such as Visual Studio 2010. Associations with Multiple Related External Content Types

23. BCS Associations Demo

24. Searching External Data Create Search Content Source Ensure Permissions are set Create ProfilePage Site Enable ProfilePages in BCS Central Admin Crawl

25. Searching External Data using BCS Demo

26. External Lists and Workflows Workflows cannot be associated with an External List This does not mean that workflow does not work with external lists You can create a site workflow or list workflow and have it read or update from an external list Workflows accessing BCS will always run as service account, even under impersonation step Only supported with Secure Store Service (SSS) or RevertToSelf authentication modes

27. Workflows and BCS

28. Read BLOB using BCS Demo

29. BCS Limitations Workflows cannot be configured on External List Item level Permissions cannot be given on items in External List interface Export to Excel feature is not available on External Lists Versioning cannot be configured on items in External Lists Item History is not available in External Lists

30. BCS Limitations Datasheet View cannot be used in External Lists RSS Feed cannot be configured on External Lists Ratings are not supported on in External Lists ListData.svc can�t be used for providing REST based access to External List data External Data Columns cannot be used as Site Level columns (can�t be consumed in Site Level Content types)

31. Breakout sessions - Wednesday, September 1 16:15 - 17:15OFS401 Business Connectivity Solutions Runtime and Object Model Deep Dive Breakout sessions - Monday, August 30 17:25 - 18:25OFS209 The new world of SharePoint 2010 Architecture & Administration Breakout sessions - Wednesday, September 1 10:40 - 11:40OFS307 Office 2010 and SharePoint 2010: The whole is greater� Breakout sessions - Tuesday, August 31 14:55 - 15:55OFS303 Claims based authentication in SharePoint 2010 Related Content

32. What is Included in BCS