19 may 2012
DESCRIPTION
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 [email protected] Blog www.lightningtools.com/blog - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/3.jpg)
Author of
![Page 4: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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 Packagin
g
Out of the Box
UI
CRM SAP Siebel LOB
SPD
VS
![Page 6: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/11.jpg)
External Data Column
• Enforces consistent meta data• Document Information Panel• Quick Parts
![Page 12: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/12.jpg)
Search
• Search External Data and SharePoint• Content Sources• Search Scope
![Page 13: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/13.jpg)
User Profile Import
• Audience Targeting• People Search• My Sites
![Page 14: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/15.jpg)
SharePoint Workspace
• External Data available offline in the client
![Page 16: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/16.jpg)
Outlook 2010
• Office Types– Posts– Events– Contacts– Tasks
• Sync 2-Way
![Page 17: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/17.jpg)
Office Quick Parts
• Meta Data available throughout Word Documents
![Page 18: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/18.jpg)
InfoPath
• Customize External Lists• External Data lookup
![Page 19: 19 May 2012](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/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](https://reader035.vdocuments.us/reader035/viewer/2022081604/56815e60550346895dccdbf8/html5/thumbnails/23.jpg)
@LightningTools@BrettLonsdale