190 likes | 299 Views
Using OData Data Sources in SharePoint 2013 Solutions. Hunter Pankey @ thehunterpankey http://hunterpankey.com. What is OData?. Protocol for interacting with RESTful services Microsoft Open Specifications Promise Operates over HTTP Returns ATOM or JSON. What are RESTful services?.
E N D
Using OData Data Sources in SharePoint 2013 Solutions Hunter Pankey @thehunterpankey http://hunterpankey.com
What is OData? • Protocol for interacting with RESTful services • Microsoft Open Specifications Promise • Operates over HTTP • Returns ATOM or JSON
What are RESTful services? • Focuses on resources • Relatively simple to use • Four principles • Use HTTP methods appropriately • Be stateless • Expose data in a directory structure • Transfer either XML or JSON
REST URL Examples • http://odata.netflix.com/Catalog/Titles and • http://odata.netflix.com/Catalog/Titles?$filter=Name%20eq%20'Bad%20News%20Bears'
OData Principles • Metadata • Data • Querying • Editing • Operations • Vocabularies
Data Model • Entities • Entity sets • Relationships
Data Model • Complex types • Entity key • Properties • Declared properties • Open entity types/dynamic properties • Operations/Functions/Actions
Data model • Structural elements • Row types • Resources • Annotations/Vocabularies
Service Model • Metadata document • Service document
OData Providers • SharePoint itself • Azure, Azure Marketplace • SQL Reporting Services • Dynamics CRM • Many public feeds • Netflix • eBay • Twitpic • Windows Live
BCS Overview • Similarities to ORMs • External Content Types • Connectors • SharePoint Interface
BCS Overview • Metadata store • Secure Store Services • External Lists • New for SharePoint 2013 • Performance • Model generation • SharePoint 2013 apps
External Lists • Overview • Data source • Improvements in SharePoint 2013 • Export/offline access
Remote Event Receivers • New in SharePoint 2013 • Added BDC stereotypes • New Functionality