Whats-New-for-BCS-2013
Download
Report
Transcript Whats-New-for-BCS-2013
What’s New? – BCS 2013
Brett Lonsdale
Brett Lonsdale
Co-founder of Lightning Tools
One of the hosts on the SharePoint Pod Show
Co-organizer of SharePoint Saturday UK
Author of SharePoint 2010 Business Connectivity
Services
Author of SharePoint 2007 Developers Guide to the
Business Data Catalog
Contributing author of many other
books inc Admin Companions…
Twitter: @brettlonsdale
The next hour…
Intro to BCS
What’s new?
• High level view of
BCS
• Getting up to
speed
• History Lesson
• OData
• Alerts and Events
• External List
improvements
• Deployed as an
App
High Level View
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
Getting up to Speed
External Lists
Business Data Web Parts
Search
Business Data Column
User Profile Import
External Content Types
Tooling
History Lesson
2010 Business
Connectivity
Services
2007 Business
Data Catalog
•Read Only
•No Tooling
2003 - Data
View Web
Part/Custom
•No BDC/BCS
•SPD Tooling
•VS Tooling
•External List
•Foundations
2013 Business
Connectivity
Services
•OData
•Excel
•Apps
•Alerts & Events
What’s new?
Excel integration
One way sync with Excel
Used to have to code
with Visual Studio Tools
for Office (VSTO)
Demo
Syncing an External List with Microsoft Excel 2013
Connecting to External Data
SharePoint Designer
.NET Assembly
SQL Server
WCF Service
Visual Studio 2012
Anything
OData (New)
OData
Open Data Protocol (Microsoft)
Can use without Microsoft technology
SQL Azure (Supports OData)
Plug Ins for Excel
MySQL, PHP, (OData tools)
GData (Google Equivalent)
CRUD
(Create Read Update Delete)
Querying
Path/Products(1)
Path/Products?filter=name eq ‘value’
Path/Products?$Select
Path/Products?$Orderby
Path/Products?$top10
Path/Products(1)?$Expand=Orders
Metadata
Path/Products?$metadata
OData
Open Data Protocol
Return Data
Exchange Data Over the Web
HTTP
JSON
ATOMPUB (ATOM Publishing Protocol)
Service End Point
Get Patch Post Delete
OData
OData & BCS
Method
Finder
Get
http://server.crm.svc/clients
SpecificFinder
Get
http://server.crm.svc/clients(“LT”)
Creator
Post
http://server.crm.svc/clients
Updater
Put
http://server.crm.svc/clients(“LT”)
Deleter
Delete
http://server.crm.svc/clients(“LT”)
Association
Get
http://server.crm.svc/clients(“LT”)/country
Deploy ECT’s as an App
No longer need to be Farm Solutions
Easier deployment
Better development environment
Demo
Creating and deploying an ECT as an App using OData
Alerts and Events
External List Alerts
External List Event Receivers
Enabled as a Feature
Custom Code
Entity Event Receivers
Custom Code
Demo
Enabling Alerts on an External List
External List Event Receivers
Item Added
Item Adding
Item is Updated
Item is Updating
….
Attach Event Receiver to External List
Remote External Event Receiver
Notification of a change in the underlying data source
Data
Source
SharePoint
Notification System
http://msdn.microsoft.com/en-us/library/jj164024.aspx
Remote External Event Receiver
BDC Model with EventSubscriber
EventUnSubscriber
Determine Underlying Changes (Service)
Receive & Record Subscriptions
SubscriptionID
Delivery Address
Event Type
Entity Name
Post Notifications to REST
The End!