sharepoint usergroup yorkshire - presentation on business connectivity services in office 365...
TRANSCRIPT
![Page 1: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/1.jpg)
Business Connectivity Services in SharePoint OnlineBrett Lonsdale
![Page 2: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/2.jpg)
Brett Lonsdale
Owner of Lightning Tools Ltd
One of the hosts on the SharePoint Pod Show
Co-organizer of SharePoint Saturday UK (29th
November 2014)
Twitter: @brettlonsdale
![Page 3: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/3.jpg)
Books
![Page 4: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/4.jpg)
What are we hoping to achieve?
Better understanding of your business through the exposing of external data in SharePoint Online
Less confusion in the workplace
Islands of data joined together to build powerful solutions
Minimal training requirements
Adoption of SharePoint
Make data more accessible
![Page 5: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/5.jpg)
How do we hope to achieve it?
Power BI Data Management Gateway
Oracle, SQL, Salesforce
Microsoft Excel Power Query Power Pivot Power Q&A Power Map
Custom App CRUD OData App
Business Connectivity Services Web Parts External List External Data Column Office Integration
External List (Site Scoped ECT APP)
Third Party App
Access Web App
![Page 6: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/6.jpg)
BCS in SharePoint On-Premises
External Data in SharePoint
External Data in the Client
Authentication Options Secure Store
Windows Authentication
Revert To Self
Username & Password
Multiple Connectors SQL
WCF
.NET Assembly
OData
![Page 7: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/7.jpg)
BCS in SharePoint Online
No BCS Search (Only Hybrid)
Connectivity is different OData – BDC Model File
SPD & Azure & Secure Store
Visual Studio App
![Page 8: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/8.jpg)
Do you have BCS?
![Page 9: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/9.jpg)
External List
Like an internal list, but with external data
CRUD functionality
Views, Filters, Sorting
No item permissions
Export to Excel
External System doing Paging, Sorting & Filtering
![Page 10: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/10.jpg)
Web Parts
Read Only
Ideal for Dashboards
Formatting via XSLT
Web Part Connections
Browser Customization
![Page 11: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/11.jpg)
External Data Column Type
Lookup your meta data
Still no Content Type Support
Great Office integration
Powerful solutions
![Page 12: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/12.jpg)
Office Client Integration
Excel
Word (Quickparts)
Outlook (Office Types)
![Page 13: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/13.jpg)
External Content Types
Created through SharePoint Designer 2013
Created using Visual Studio 2012
![Page 14: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/14.jpg)
External Content Types
Methods Finder (Read List)
Specific Finder (Read Item)
Creator (Create)
Updator (Update)
Deleter (Delete)
ID Enumerator (Index)
Properties
Identifiers
Filters
Actions
Office Item Type
Title Column
![Page 15: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/15.jpg)
Expose an Odata End Point
WCF Service
ADO.NET Entity Data Model
![Page 16: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/16.jpg)
OData
Expose data out of silos by publishing it as OData
Automatic ECT creation in Visual Studio for OData.
![Page 17: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/17.jpg)
Deploy ECT’s as an App
No longer need to be Farm Solutions*
Easier deployment
Better development environment
External List Only
![Page 18: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/18.jpg)
Permissions
Permissions set at the Meta Data Store
Can be propagated to the LOB System to the ECT
Can be set at the ECT
![Page 19: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/19.jpg)
Secure Store
![Page 20: SharePoint Usergroup Yorkshire - Presentation on Business Connectivity Services in Office 365 SharePoint Online](https://reader034.vdocuments.us/reader034/viewer/2022051617/55a42c5c1a28ab595c8b46c5/html5/thumbnails/20.jpg)
Resources
Configuring Hybrid BCS (ADFS/Azure AD for Authentication) http://channel9.msdn.com/Events/SharePoint-
Conference/2014/SPC319
Deploy a Business Connectivity Services Hybrid Solution http://technet.microsoft.com/en-
us/library/dn197239%28v=office.15%29.aspx