what s new in business connectivity services evolution of bdc l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
What's New in Business Connectivity Services (Evolution of BDC!) PowerPoint Presentation
Download Presentation
What's New in Business Connectivity Services (Evolution of BDC!)

Loading in 2 Seconds...

play fullscreen
1 / 29

What's New in Business Connectivity Services (Evolution of BDC!) - PowerPoint PPT Presentation


  • 151 Views
  • Uploaded on

What's New in Business Connectivity Services (Evolution of BDC!). Barry Boudreau Principal Technology Specialist Microsoft Corporation. Agenda. Challenges with Back-End Data Business Data Catalog 2007 Summary Introducing Business Connectivity Services Investment Areas Presentation

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 'What's New in Business Connectivity Services (Evolution of BDC!)' - verdi


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
what s new in business connectivity services evolution of bdc

What's New in Business Connectivity Services (Evolution of BDC!)

Barry Boudreau

Principal Technology Specialist

Microsoft Corporation

agenda
Agenda
  • Challenges with Back-End Data
  • Business Data Catalog 2007 Summary
  • Introducing Business Connectivity Services
  • Investment Areas
    • Presentation
      • Demo: External data in SharePoint and Office
    • Connectivity
    • Tooling
  • How do I get it?
  • Q&A
challenges with back end data
Challenges With Back End Data

End User Challenges

Multiple user interfaces

External systems can be difficult to use

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

IT Challenges

Islands of business data

Overhead for IT to service all user requests

Manage security, auditing, connectivity

One off projects for connecting to external systems

challenges with back end data4
Challenges With Back End Data

Provide External Data in a Centrally Managed Way

Bring external data into SharePoint and Office

Business Connectivity Services

bdc 2007 connect to business data
BDC 2007 - Connect to Business Data
  • Connect SharePoint to any business application or structured database
  • SharePoint Provides:
    • Business Data in Search
      • Crawl back-end systems like ERP, CRM, Custom Databases, SAP, Siebel, etc
    • Business Data Web Parts
      • Display back-end data
    • Business Data in Lists
      • Add business data as list columns and as document metadata
    • Business Data in User Profiles
      • Add business data as properties in User Profiles
bdc 2007 connect to business data6
BDC 2007 - Connect to Business Data

Web Parts

Lists

Search

User Profiles

Custom Apps

List Columns

Search

Index

Profile Store

Metadata

Business Data Catalog

WS Proxy

ADO.NET

Web Service

Database

BizTalk, SAP, Siebel, Legacy, …

SQL Server, Oracle, OLEDB, ODBC

business data catalog summary
Business Data Catalog – Summary

Business Data Catalog

Business Data Web Parts

Business Data Columns

Business Data Search

feedback on 2007 bdc
Feedback on 2007 BDC
  • 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 use offline?
a bit of terminology
A bit of Terminology…
  • Business Connectivity Services – All up
  • Business Data Connectivity (BDC) – plumbing, runtime, connectivity
  • External System – back ends
  • External Content Type (ECT) - a building block, entity++
  • Model – XML file
  • External List – newest type of SP list
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

external content type ect the building block
External Content Type (ECT)The building block
  • Superset of entity capabilities; describes:
    • 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 into the Business Data Connectivity service as part of a model
external content type the building block
External Content TypeThe building block

SharePointWorkspace with InfoPath Forms

Outlook Forms and Task Panes

SharePoint External Lists

External Content Type

Customer

CustomerID

FirstName

LastName

EmailAddress

Search Results

External data

Office Applications

presentation external lists in sharepoint
PresentationExternal Lists in SharePoint
  • Presentation
  • Connectivity
  • Tooling
  • 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
presentation offline external list

Connect to Outlook as

Contacts

Tasks

Calendars

Posts

PresentationOffline External List
  • Presentation
  • Connectivity
  • Tooling
  • Download to SharePoint Workspace as
    • Lists
    • Word doc libraries with external data columns
presentation surfacing external data
PresentationSurfacing External Data
  • Presentation
  • Connectivity
  • Tooling
  • External Data Columns
    • Add data from external content types to standard SharePoint lists
    • Can be made available as Content Controls in Word
  • Web Parts

Scenario: Use for Dashboard pages

    • External Data List 
    • External Data Item
    • External Data Item Builder
    • External Data Related List
    • External Data Connectivity Filter
    • Chart Web Part
  • External Data Search
    • Integrate External Data into search results
contoso sales solution
Contoso Sales Solution

External Systems

Office Client

Sales

Database

SharePoint Server

demo overview
Demo Overview

Bring Customer data into SharePoint and Outlook

  • External Content Type
  • External List
  • Outlook integration

Connect Product data from SharePoint to SharePoint Workspace

  • External List
  • InfoPath Forms
  • SharePoint Workspace integration

Create a Sales Quote document in Word

  • External Data Column
  • Word Content Controls
connectivity
Connectivity

Business Data Connectivity (BDC)

Business Data Catalog (BDC)

Presentation in SharePoint

Business Data Connectivity (BDC)

BDC Metadata Store

BDC Client Runtime

BDC Server Runtime

Client Data

Cache

DB

Connector

WCF/WS

Connector

.NET Assembly

Connector

Custom

Connector

Client to Backend Direct Connection

External data

Custom .NET assembly

SQL

SAP

ORACLE

Siebel

connectivity connecting to external data
ConnectivityConnecting to External Data
  • 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
tooling assemble solutions via sharepoint designer
ToolingAssemble Solutions via SharePoint Designer
  • Presentation
  • Connectivity
  • Tooling
  • Discover
    • Database
    • Web services
    • .NET type
  • Map operations
    • Create, read, update, delete, lookup
  • Connect to SharePoint/Office
    • External List
    • Contact
    • Task
    • Appointment
    • Post
tooling building prodev apps using vs
ToolingBuilding ProDev Apps using VS
  • 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 SharePoint Designer
  • Bring external data into other Office clients with VSTO Add-Ins (e.g., Excel)
baked into the platform
Baked into the Platform…

SharePoint Server 2010

Office 2010

Secure Store Service

External Data Search

Rich Client Extensions

BDC Client Runtime

Profile Pages

External Data Web Parts

SharePoint Foundation 2010

External List

External Data Column

Business Data Connectivity Service

business connectivity services key takeaways
Business Connectivity ServicesKey Takeaways
  • Bring External Data into SharePoint and Office
  • Client/server connectivity with
    • Read/write
    • Online/offline
  • Tools for rapid assembly of business solutions declaratively
  • Baked into the Platfom
slide25

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

why the business data catalog
Why the Business Data Catalog?

Integrate other systems with SharePoint sites

  • Reporting dashboards
  • Line of business applications

Integrate Business Data Catalog data into hybrid Windows Forms Applications

Search for data in other systems via the SharePoint Search service

Save the time, cost, and monotony of writing yet another data layer!

connectivity27
Connectivity

Business Data Connectivity (BDC)

Business Data Catalog (BDC)

Presentation in SharePoint

Presntation in SharePoint

Business Data Connectivity (BDC)

Business Data Connectivity (BDC)

BDC Metadata Store

BDC Metadata Store

BDC Client Runtime

BDC Server Runtime

BDC Server Runtime

Client Data

Cache

DB

Connector

WCF/WS

Connector

.NET Assembly

Connector

Custom

Connector

DB

Connector

WCF/WS

Connector

.NET Assembly

Connector

Custom

Connector

Client to Backend Direct Connection

External data

Custom .NET assembly

SQL

SAP

ORACLE

Siebel

the building block

External Content Type

The Building Block

SharePoint Workspace with InfoPath Forms

Outlook Forms andTask panes

SharePoint External lists

Search results

Office Apps