slide1
Download
Skip this Video
Download Presentation
Consuming External Data with Business Connectivity Services in SharePoint 2010

Loading in 2 Seconds...

play fullscreen
1 / 32

Consuming External Data with Business Connectivity Services in SharePoint 2010 - PowerPoint PPT Presentation


  • 217 Views
  • Uploaded on

Consuming External Data with Business Connectivity Services in SharePoint 2010. Name Title Company. Agenda. Business Connectivity Services (BCS) Primer Creating BCS Applications BCS Security BCS And Search. Business Connectivity Services (BCS) Primer. Business Connectivity Services.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Consuming External Data with Business Connectivity Services in SharePoint 2010' - ailis


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
agenda
Agenda
  • Business Connectivity Services (BCS) Primer
  • Creating BCS Applications
  • BCS Security
  • BCS And Search
business connectivity services
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

data connectivity
Data & Connectivity

SharePoint Client

BCS in Office Client

BCS in SharePoint

Identity Federation

service

BCS Meta

Data Store

Client Data

Cache

BDC

BDC

DB

Connector

WCF /WS

Connector

.NET Assembly

Connector

ASCustom

Connector

Client to Backend Direct Connection

External data

Persistence Store

Custom .NET assembly

Data Cubes

SQL

SAP

ORACLE

Siebel

external content types the building block
External Content TypesThe building block

Describes the schema and data access capabilities of an external data source and its behavior within Office and SharePoint

*formerly known as BDC Entity

Office Clients (Rich)

BCS

External Data Source

(Web Service, DB, .Net object, LOB system, Web 2.0 service, etc.)

External Content Type (ECT)

BCS

BCS-enabled solutions rely on ECTs to integrate external data into SharePoint and the Office client applications

SharePoint (Thin)

bdc runtime
BDC Runtime
  • Client & Server symmetrical model
      • Write back capable
      • Batch read operations
      • Navigate and create associations
      • Bulk APIs
      • Read blobs (streaming support)
      • Read and write back complex types (Dot notation)
  • Uniform experience across various systems types
  • Extensibility mechanisms
      • .NET Assembly Connector
      • Custom Connector
      • Secure Store Provider (custom)
solution types

Out-of-box

Surface data in External Lists

Connect those lists to Outlook, SPW

External Data Columns

Solution Types
  • 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)
  • Customize
    • InfoPath forms
    • Workflow
    • Web Part Pages
    • Outlook taskpane and ribbon

Simple

Intermediate

Advanced

NO CODE*

CODE

SharePoint Designer

SharePoint SDK

Visual

Studio

Developer

Power User

Advanced Developer

solution creation approaches
Solution Creation Approaches
  • Client-Server Environment
    • Compose solutions (no code) that connect to existing WCF, Sql Server databases and .Net Objects
    • Implicitly author thin and rich client UX for External List and InfoPath Forms
  • Single machine Dev Environment
  • Create reusable ECTs that provide custom integration logic to virtually any data source using .Net code
  • Author thin and rich client UX as reusable components
  • Create Office Add-Ins in Visual Studio

Import & Configure

Produce WSP

“Live” Connection

Export, Import

& Configure

Developer

Power User

Visual

Studio

SharePoint Server

(Shared, Dev/Prod)

SharePoint Designer

IT Admin

Production Environment

SharePoint

Designer

SDK

exposing your data from sharepoint
Exposing Your Data From SharePoint
  • External Data Columns
  • External Lists
  • Chart WebPart
  • Business Data WebParts
    • Business Data List/Related List
    • Business Data Item Builder
    • Business Data Item
  • BDC OM
  • SharePoint OM
  • Client Side OM (CSOM)

No Code Solutions

Custom Code

bdc models in vs 2010
BDC Models in VS 2010
  • BDC Model SharePoint Project Item (SPI)
  • Farm Feature with Feature Receiver ImportModelReceiver
  • BDC Model Designer
  • BDC Explorer
  • Minimal XML editing
sharepoint client side om
SharePoint & Client Side OM
  • Expose ECT as External List
  • CSOM
    • Use List and ListItem
  • SharePoint OM
    • Use SPList, SPListItem for CRUD
  • Limitations
    • Type must be represented within Table
    • ID Field type must be Int32
    • No Bulk or Batching API Support
    • SPListItem not strongly typed
    • No BLOB streaming support
bdc authentication
BDC Authentication

SharePoint Server

Process Account

Modes:

PassThrough

(Uses logged-on user)

RevertToSelf

(Uses process account)

SSO Authentication

(Credentials, etc. from

Secure Store)

Application

CredentialsTicket

Delegation Token

Other

BCS

Runtime

WebPart

VL

Logged-on

user

Secure Store

Service

Application

Delegated

Token

SAML

Token

Credentials

Claims Aware

Service

Web 2.0

Legacy LOB

secure store service sss
Secure Store Service (SSS)
  • Used to avoid double-hop issue
  • Can be used for Impersonation
  • BDCAuthException throw when
    • Credentials are not found in SSS
    • BCS connector detects authentication exception from external data source
  • Default credentials page or custom page
  • Create your own SS Provider with ISecureStoreProvider
bcs authentication support matrix
BCS Authentication Support Matrix

n/a

In code

In code

In code

In code

In code

authorization in bcs
Authorization in BCS
  • Rights
    • Edit – create, delete, update metadata objects
    • Execute – call external system
    • Set Permissions – give permissions to other users
    • Selectable in Clients – accessible to client applications like entity picker
  • AccessControlListapplies to…
    • Model
    • LobSystem
    • Entity
    • Method
  • Set in CA or declaratively in the model XML
enabling your model for search
Enabling Your Model For Search
  • Search Specific Properties
    • ShowInSearchUI – LOB System
    • RootFinder – Finder Method and Instance
    • LastModifiedTimeStampField – Configure for incremental crawling
    • WindowsSecurityDescriptorField – SpecificFinder instance
summary
Summary
  • Business Connectivity Services (BCS) Primer
  • Creating BCS Applications
  • BCS Security
  • BCS And Search
slide32

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

ad