190 likes | 313 Vues
Discover how to effectively utilize OData data sources within SharePoint 2013 solutions in this insightful guide by Hunter Pankey. Learn about OData's principles, its interaction with RESTful services, and how it operates over HTTP to return data in ATOM or JSON formats. Explore the differences between SOAP and REST, the functionality of OData providers, and the benefits of integrating OData with SharePoint. This resource will help enhance your SharePoint applications with robust external data connectivity and improved performance.
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