230 likes | 371 Views
19 May 2012. Business Connectivity Services (BCS). The first ever all green SharePoint event on earth. Brett Lonsdale – Lightning Tools @ brettlonsdale #SPSJHB. About Me. Brett Lonsdale, MCTS, MCSD, MCT Email brett@lightningtools.com Blog www.lightningtools.com/blog
E N D
19 May 2012 Business Connectivity Services (BCS) The first ever all green SharePoint event on earth Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB
About Me • Brett Lonsdale, MCTS, MCSD, MCT • Email brett@lightningtools.com • Blog www.lightningtools.com/blog • Twitter @brettlonsdale @lightningtools • LinkedInhttp://www.linkedin.com/in/brettlonsdale
What is BCS? SPD VS SAP Siebel LOB CRM
What’s new? • Entities become External Content Types • Now more than just a schema • ECT’s describe behavior • WCF and .NET Assembly Connectors • External Lists • Client Runtime • Read/Write • Access consumes BCS • Tools
Terminology External Content Type – Table/View etc Finder Method – Returns multiple columns/rows Specific Finder – Displays a row Action – URL and Parameters Association – Join (Relationship)
Problems solved by BCS IT Extranet Collaboration Site Human Resources Weekly Issue Tracking Meeting Finance Islands of data into 1 application
External Lists • Treat External Data like SharePoint Lists • Limitations include: • Workflow • RSS Feed • Item Level Permissions • Datasheet View
Business Data Web Parts • Business Data Connectivity Web Parts • Business Data List • Related List • Item Builder • Data View Web Part
External Data Column Enforces consistent meta data Document Information Panel Quick Parts
Search Search External Data and SharePoint Content Sources Search Scope
User Profile Import Audience Targeting People Search My Sites
Client Capabilities • SharePoint Workspace • Outlook • Office Business Parts (OBPs) • List of Items • Single Item • Word • Access
SharePoint Workspace External Data available offline in the client
Outlook 2010 • Office Types • Posts • Events • Contacts • Tasks • Sync 2-Way
Office Quick Parts Meta Data available throughout Word Documents
InfoPath Customize External Lists External Data lookup
SharePoint Designer • SharePoint Designer • No code solution • Create External Content Types • Configure the connection to the Datasource • Define Methods • Simple Associations
Visual Studio 2010 Pro • Visual Studio • Code solution • Mashups of Datasources • Complex Associations • Output a .NET Assembly