Upgrade to Pro — share decks privately, control downloads, hide ads and more …

OData, Open Data Protocol, a brief introduction

OData, Open Data Protocol, a brief introduction

A really brief introduction to the OData protocol and how data are retrieved, transformed and exposed.

Eugenio Lentini

February 05, 2015

Transcript

9 slides
  1. • Defined by a data model • made by properties,

    for instance: • Person: {name, surname, gender, address} • Organized in collection and identified using URLs • serviceRoot/People 01 resource OData
  2. • Resources definition • Consuming resources using HTTP messages •

    REST APIs definition to publish and edit resources by a Web Client 02 enable OData
  3. GET serviceRoot/People get all the entities in the collection People

    PUT serviceRoot/People update an existing entity in the collection People POST serviceRoot/People add a new entity in the collection People DELETE serviceRoot/People delete an entity in the collection People 03 definition REST Api
  4. Query <XML> OData http://www.company.com/service/People select * from people Table people

    <people> <person> <person> </people> People is a resource exposed by the service the service URL 04 example of request OData
  5. 1. Define a query 2. Define a resource name 3.

    Define how to transform the result of a query into XML 4. Associate the resource to that query 5. Request (GET) the resource to have XML data without knowing data source 05 how to expose a resource OData
  6. • Hide the underlying data source whatever it is. •

    Hide the schema and where data comes from. • Standard way to publish and consume a resource. • Multiple clients can use the service. 06 pros OData
  7. • Connection is via the web, possible lost of performance

    on big data. • PowerPivot 2013 seems having issue managing associated big data. • PowerPivot does not recognize associations defined by OData. • Service must be implemented and tuned to optimized the performance. 07 cons OData

More Decks by Eugenio Lentini

Other Decks in Programming