sharepoint design tools office applications
TRANSCRIPT
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Advanced Developer Training
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Consuming External Data with Business Connectivity Services in SharePoint 2010
NameTitleCompany
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Agenda
Business Connectivity Services (BCS) PrimerCreating BCS ApplicationsBCS SecurityBCS And Search
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BUSINESS CONNECTIVITY SERVICES (BCS) PRIMER
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
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
SharePointDesigner
Visual Studio
Business Connectivity Services
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Data & Connectivity
Identity Federati
onservice
BCS in SharePoint
BCS MetaData Store
DBConnector
WCF /WSConnector
BDC
AS CustomConnector
.NET AssemblyConnector
SharePoint ClientBCS in Office Client
Client to Backend Direct Connection
BDCClient Data
Cache
Persistence Store
SAP ORACLE SiebelSQL
Data Cubes
Custom .NET assembly
External data
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
External Content TypesThe building block
Office Clients (Rich)
SharePoint (Thin)
External Content Type (ECT)
External Data Source
(Web Service, DB, .Net object, LOB system,
Web 2.0 service, etc.)
BCS
BCSBCS-enabled solutions rely on ECTs to integrate external data into SharePoint and the Office client applications
Describes the schema and data access capabilities of an external data source and its behavior within Office and SharePoint
*formerly known as BDC Entity
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BCS Server Features by SKUBCS Server Features Foundation SharePoint Standard SharePoint Enterprise
External Data Column
External Lists
Connectors (ADO, WCF, .net)
CA BDC Admin Pages
BDC Muti-Tenant
BDC Admin OM
Runtime OM
Secure Store
BDC Web Parts
Profile Pages
Packaging
Rich Client Extensions
InfoPath Forms
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BDC RuntimeClient & Server symmetrical model
Write back capableBatch read operationsNavigate and create associationsBulk APIsRead blobs (streaming support)Read and write back complex types (Dot notation)
Uniform experience across various systems typesExtensibility mechanisms
.NET Assembly ConnectorCustom ConnectorSecure Store Provider (custom)
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
External Content Type Modeling with SPD
demo
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
CREATING BCS APPLICATIONS
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Solution Types
Intermediate AdvancedSimple
• 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)
• Out-of-box• Surface data in
External Lists• Connect those lists
to Outlook, SPW• External Data
Columns
SharePoint Designer
SharePoint SDK
DeveloperPower User
NO CODE*
Advanced Developer
VisualStudio
CODE
• Customize• InfoPath forms• Workflow• Web Part Pages• Outlook taskpane
and ribbon
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Solution Creation Approaches
Power User
SharePoint Designer
Developer
VisualStudio
SharePoint
Designer
SDK
Single machine Dev Environment
Create reusable ECTs that provide custom integration logic to virtually any data source using .Net codeAuthor thin and rich client UX as reusable componentsCreate Office Add-Ins in Visual Studio
Client-Server EnvironmentCompose solutions (no code) that connect to existing WCF, Sql Server databases and .Net ObjectsImplicitly author thin and rich client UX for External List and InfoPath Forms
IT AdminProduction
EnvironmentProduce WSP
Import & Configure
SharePoint Server(Shared, Dev/Prod)
“Live” ConnectionExport, Import
& Configure
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Exposing Your Data From SharePoint
External Data ColumnsExternal ListsChart WebPartBusiness Data WebParts
Business Data List/Related ListBusiness Data Item BuilderBusiness Data Item
BDC OMSharePoint OMClient Side OM (CSOM)
No Code Solutions
Custom Code
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BDC Models in VS 2010
BDC Model SharePoint Project Item (SPI)Farm Feature with Feature Receiver ImportModelReceiverBDC Model DesignerBDC ExplorerMinimal XML editing
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published April 2010
Using BDC OM
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published April 2010
Bulk API Example - Model
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published April 2010
Bulk API Example - Code
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published April 2010
Batching API Example - Model
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published April 2010
Batching API Example - Code
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
SharePoint & Client Side OM
Expose ECT as External ListCSOM
Use List and ListItem
SharePoint OMUse SPList, SPListItem for CRUD
LimitationsType must be represented within TableID Field type must be Int32No Bulk or Batching API SupportSPListItem not strongly typed
No BLOB streaming support
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Creating a .Net Connector in Visual Studio 2010
demo
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BCS SECURITY
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BDC Authentication
SharePoint Server
Legacy LOBWeb 2.0Claims AwareService
Secure StoreService
BCSRuntimeVL
WebPart
Application
Process Account
Logged-onuser
CredentialsTicketDelegation TokenOther
CredentialsApplicationDelegatedToken
SAMLToken
Modes:
PassThrough (Uses logged-on user)RevertToSelf (Uses process account)SSO Authentication (Credentials, etc. from Secure Store)
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Secure Store Service (SSS)
Used to avoid double-hop issueCan be used for ImpersonationBDCAuthException throw when
Credentials are not found in SSSBCS connector detects authentication exception from external data source
Default credentials page or custom pageCreate your own SS Provider with ISecureStoreProvider
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BCS Authentication Support MatrixPopular Auth types
WCF Connector
DB Connector
.NET HostConnector
SQL Auth
Username & Password
NTLM Pass through Or Kerberos
Claims Token
Oauth / LiveID
In code
n/a
In code
In code
In code
In code
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Authorization in BCS
RightsEdit – create, delete, update metadata objectsExecute – call external systemSet Permissions – give permissions to other usersSelectable in Clients – accessible to client applications like entity picker
AccessControlList applies to…ModelLobSystemEntityMethod
Set in CA or declaratively in the model XML
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
BCS SEARCH
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Enabling Your Model For Search
Search Specific PropertiesShowInSearchUI – LOB SystemRootFinder – Finder Method and InstanceLastModifiedTimeStampField – Configure for incremental crawlingWindowsSecurityDescriptorField – SpecificFinder instance
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
Summary
Business Connectivity Services (BCS) PrimerCreating BCS ApplicationsBCS SecurityBCS And Search
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
©2010 Microsoft Corporation. All rights reserved. RTM Content - Published May 2010
© 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.