19 may 2012 business connectivity services (bcs) brett lonsdale – lightning tools @brettlonsdale...
TRANSCRIPT
![Page 1: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/1.jpg)
19 May 2012
Business Connectivity Services (BCS)
Brett Lonsdale – Lightning Tools@brettlonsdale #SPSJHB
The
first
eve
r all
gree
n Sh
areP
oint
eve
nt o
n ea
rth
![Page 2: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/2.jpg)
• Brett Lonsdale, MCTS, MCSD, MCT– Email
[email protected] – Blog
www.lightningtools.com/blog– Twitter
@brettlonsdale@lightningtools
– LinkedInhttp://www.linkedin.com/in/brettlonsdale
About Me
![Page 3: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/3.jpg)
Author of
![Page 4: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/4.jpg)
Agenda
Putting BCS into use
SharePoint Foundations SharePoint Server
The ServicesClient Services Server Services
Business Connectivity Services IntroductionWhat is BCS? How does it Help?
![Page 5: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/5.jpg)
Office 2010
SharePoint Workspace InfoPath Word Outlook
SharePoint Server
External Lists
Enterprise Search
External Bus field
TypeWeb Parts User
Profiles
What is BCS?
BDC Client Runtime BDC Cache Offline
Operations ECT BDC Runtime Security Solution
Packaging
Out of the Box
UI
CRM SAP Siebel LOB
SPD
VS
![Page 6: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/6.jpg)
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
![Page 7: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/7.jpg)
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)
![Page 8: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/8.jpg)
Problems solved by BCS
• Islands of data into 1 application
Finance
Human Resources
IT
Weekly Issue Tracking Meeting
Extranet Collaboration
Site
![Page 9: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/9.jpg)
External Lists
• Treat External Data like SharePoint Lists• Limitations include:– Workflow– RSS Feed– Item Level Permissions– Datasheet View
![Page 10: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/10.jpg)
Business Data Web Parts
• Business Data Connectivity Web Parts– Business Data List– Related List– Item Builder– Data View Web Part
![Page 11: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/11.jpg)
External Data Column
• Enforces consistent meta data• Document Information Panel• Quick Parts
![Page 12: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/12.jpg)
Search
• Search External Data and SharePoint• Content Sources• Search Scope
![Page 13: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/13.jpg)
User Profile Import
• Audience Targeting• People Search• My Sites
![Page 14: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/14.jpg)
Client Capabilities
• SharePoint Workspace• Outlook• Office Business Parts (OBPs)– List of Items– Single Item
• Word• Access
![Page 15: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/15.jpg)
SharePoint Workspace
• External Data available offline in the client
![Page 16: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/16.jpg)
Outlook 2010
• Office Types– Posts– Events– Contacts– Tasks
• Sync 2-Way
![Page 17: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/17.jpg)
Office Quick Parts
• Meta Data available throughout Word Documents
![Page 18: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/18.jpg)
InfoPath
• Customize External Lists• External Data lookup
![Page 19: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/19.jpg)
Putting BCS into use
SharePoint Foundations SharePoint Server
The ServicesClient Services Server Services
Business Connectivity Services IntroductionWhat is BCS? How does it Help?
![Page 20: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/20.jpg)
SharePoint DesignerSharePoint Designer– No code solution– Create External Content Types– Configure the connection to the
Datasource– Define Methods– Simple Associations
![Page 21: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/21.jpg)
Visual Studio 2010 ProVisual Studio– Code solution – Mashups of Datasources– Complex Associations– Output a .NET Assembly
![Page 22: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/22.jpg)
Putting BCS into use
SharePoint Foundations SharePoint Server
The ServicesClient Services Server Services
Business Connectivity Services IntroductionWhat is BCS? How does it Help?
![Page 23: 19 May 2012 Business Connectivity Services (BCS) Brett Lonsdale – Lightning Tools @brettlonsdale #SPSJHB The first ever all green SharePoint event on earth](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649ee75503460f94bf8741/html5/thumbnails/23.jpg)
@LightningTools@BrettLonsdale