1 / 13

Introducing Business Connectivity Services

Introducing Business Connectivity Services. Brett Lonsdale. About Me. Email: brett@lightningtools.com Web: www.lightningtools.com Web: www.sharepointpodshow.com Blog: www.brettlonsdale.com Twitter: @ brettlonsdale. Agenda. Problems Solved by BCS Overview of BCS What’s new?

abla
Download Presentation

Introducing Business Connectivity Services

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing Business Connectivity Services Brett Lonsdale

  2. About Me • Email: brett@lightningtools.com • Web: www.lightningtools.com • Web: www.sharepointpodshow.com • Blog: www.brettlonsdale.com • Twitter: @brettlonsdale

  3. Agenda • Problems Solved by BCS • Overview of BCS • What’s new? • Server Capabilities • Client Capabilities • External Lists in Detail • Tooling • Demonstration

  4. Problems solved by BCS • Islands of data into 1 application IT Extranet Collaboration Site Human Resources Weekly Issue Tracking Meeting Finance

  5. Overview of BCS SPD VS SAP Siebel LOB CRM

  6. What’s new? • Entities become External Content Types • Now more than just a schema • ECT’s describe behavior • WCF and .NET Assembly Shims • External Lists • Client Runtime • Read/Write • Access consumes BCS • Tools

  7. Terminology • Enterprise Content Type – Table/View etc • Finder Method – Returns multiple columns/rows • Specific Finder – Displays a row • IDEnumerator – Used by the Enterprise Search to enumerate the rows • Action – URL and Parameters • Association – Join (Relationship)

  8. Server Capabilities • External Lists • Backend data presented in a SharePoint style list • InfoPath and Web Forms for Updating | Inserting data • Business Data Web Parts • Now Ajaxian • Really only here for backwards compatibility • External Data Column • Use LOB data in Lists & Libraries • Workflow • Search

  9. Client Capabilities • SharePoint Workspace • Outlook • Office Business Parts (OBPs) • List of Items • Single Item • Word • Access • VSTO

  10. External Lists • Create, Read, Update Delete operations • Sort/Filter • Standard and Customizable Views • Manipulation via the SPList OM • Portable Across Sites • Extend with InfoPath Forms, Custom Columns, SPList • No Datasheet view or RSS Feeds • Item Level permissions on External Data • Alerts

  11. Tools • SharePoint Designer • No code solution • Create External Content Types • Configure the connection to the Datasource • Define Methods • Simple Associations • Visual Studio • Code solution • Mashups of Datasources • Complex Associations • Output a .NET Assembly • Lightning Strikes Twice! BCS Meta Man 

  12. Demonstration • Use SharePoint Designer to connect to a Line of Business system • Create and use an External List • Take data offline using Outlook and SharePoint Workspace • Using the External Data Column

  13. Q & A

More Related