![Page 1: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/1.jpg)
![Page 2: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/2.jpg)
BUILDING BUSINESS APPLICATIONS USING BUSINESS CONNECTIVITY SERVICES AND SHAREPOINT DESIGNER
Steve Letford - Microsoft
Chakkaradeep Chandran - Intergen
![Page 3: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/3.jpg)
AGENDA
• BCS Overview – (Steve)
• Demo – (Chakkaradeep)• Connecting to SQL and creating an external list (Hello world)
• Using an external lists and creating BCS associations
• BCS integration with Office
• Attaching workflows to external lists
• Search
![Page 4: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/4.jpg)
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?
![Page 5: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/5.jpg)
Rapidly create no-code collaborative solutions
Unlock the value of your enterprise data
Maintain control over end user solutions
SHAREPOINT COMPOSITESENABLING NO-CODE COLLABORATIVE SOLUTIONS THAT BALANCE SELF-SERVICE WITH CONTROL
Communities
Search
Sites
Composites
ContentInsights
![Page 6: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/6.jpg)
SharePointDesign Tools
Office Applications
BCS Client
Business Data Connectivity
External Content Type Repository
External Lists
Dev Platform Enterprise Search
Business Intelligence
Collaboration Social
Enterprise Content
Management
Web 2.0DBWCFWeb ServiceLOB
SharePoint Designer
Visual Studio
BUSINESS CONNECTIVITY SERVICES
![Page 7: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/7.jpg)
Outlook Forms and Task Panes
SharePoint External Lists SharePoint Workspace with InfoPath Forms
Search Results
EXTERNAL CONTENT TYPETHE BUILDING BLOCK
Office Applications
External Content Type
Customer CustomerID FirstName LastName EmailAddress
External data
![Page 8: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/8.jpg)
CONNECTIVITYBusiness Data Connectivity (BDC)
SAP ORACLE Siebel
SQLCustom .N
ET assembly
DBConnecto
r
WCF/WSConnector
.NET AssemblyConnecto
r
CustomConnecto
r
Client to Backend Direct Connection
BDC Client RuntimeBDC Metadata
Store
External data
Business Data Connectivity (BDC)
BDC Server Runtime
Client DataCache
Presentation in SharePoint
![Page 9: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/9.jpg)
SOLUTION TYPES, TOOLSAND ROLES
Intermediate AdvancedSimple
• Customize• InfoPath forms• Word (QuickParts)• Workflow• Web Part Pages
• Custom connectivity for data aggregation, transformation, security, etc.
• Use custom code to integrate data into any Office app
• Business logic in forms
• Create reusable components (UI parts, ECTs, actions)
• Surface data in External Lists
• Connect those lists to Outlook
• External data columns
SharePoint Designer
SharePoint SDK
DeveloperPower User
NO CODE*
Advanced Developer
VisualStudio
CODE
![Page 10: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/10.jpg)
BAKED INTO THE PLATFORM…
Secure Store Service
External Data Search
Rich Client Extensions
External Data Web Parts
BDC Client Runtime
Profile Pages
External List External Data Column
Business Data Connectivity Service
SharePoint Server 2010 Office 2010
SharePoint Foundation 2010
![Page 11: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/11.jpg)
BCS SERVICES AUTHENTICATION
• Credentials These are typically in the form of name/password. Some external systems may also require additional credentials such as a personal identification number (PIN) value.
• Claims Security Assertion Markup Language (SAML) tickets can be passed to claims-aware services that supply external data.
![Page 12: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/12.jpg)
AUTHENTICATION FROM SHAREPOINT SERVER TO EXTERNAL DATA SOURCE - IMPERSONATION
SharePoint Server
Process Account
Logged-onuser
BCSRuntime
Web Parts
External List
PassThrough - Uses logged on user
RevertToSelf - Uses process account
SSS Authentication - Credentials, etc. from Secure Store)
Modes:
Custom App
Legacy LOB
Credentials OR Windows Identity Through Kerberos
Identity
![Page 13: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/13.jpg)
AUTHENTICATION FROM SHAREPOINT SERVER TO EXTERNAL DATA SOURCE
SharePoint Server
Process Account
Logged-onuser
BCSRuntime
Web Parts
External List
Custom App
Legacy LOB
Credentials OR Windows Identity Through Kerberos
Identity
PassThrough - Uses logged on user
RevertToSelf - Uses process account
SSS Authentication - Credentials, etc. from Secure Store)
Modes:
![Page 14: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/14.jpg)
AUTHENTICATION FROM SHAREPOINT SERVER TO EXTERNAL DATA SOURCE
SharePoint Server
Process Account
Logged-onuser
BCSRuntime
Web Parts
External List
Custom App
Legacy LOB
Credentials OR Windows Identity Through Kerberos
Secure Store Service
- Credentials- Ticket- Delegation Token
Identity Creds/Token
PassThrough - Uses logged on user
RevertToSelf - Uses process account
SSS - Credentials, etc. from Secure Store)
Modes:
![Page 15: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/15.jpg)
DEMOS
![Page 16: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/16.jpg)
Connecting to SQL and creating an external list (Hello world)
![Page 17: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/17.jpg)
Using an external lists and creating BCS associations
![Page 18: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/18.jpg)
BCS ASSOCIATIONS
Sales Order Table Customers Table
Sales Order External ListSales Order External List
![Page 19: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/19.jpg)
BCS integration with Office
![Page 20: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/20.jpg)
Attaching workflows to external lists & Search
![Page 21: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/21.jpg)
RESOURCES
• BCS Overview• http://technet.microsoft.com/en-us/library/ee661740.aspx
• Plan to upgrade BCS• http://technet.microsoft.com/en-us/library/ff607947.aspx
• BCS Resource Centre• http://msdn.microsoft.com/en-us/sharepoint/ff660755.aspx
• BCS Video – Secure Store• http://blogs.msdn.com/b/bcs/archive/2010/05/06/bcs-team-channel-secure-store-service.aspx
• BCS Team blog• http://blogs.msdn.com/b/bcs/
• BCS Security Overview• http://technet.microsoft.com/en-us/library/ee661743.aspx
• Plan SharePoint 2010 Authentication• http://technet.microsoft.com/en-us/library/cc262350.aspx
![Page 22: Building Solutions With Business Connectivity Services](https://reader033.vdocuments.us/reader033/viewer/2022061112/545709e3af7959b6358b7422/html5/thumbnails/22.jpg)
Platinum Sponsor
Gold Sponsors
Silver Sponsors
Bronze Sponsors