OData: There’s a Feed for That

Pablo Castro

Software Architect Microsoft Corporation [email protected]

• • • • What is it?

Why do you care?

How do you use it?

How to build one?

– Today at 3:00 PM Goals

what were we thinking?

data in modern web applications

odata in 1 slide…

• Uniform way of representing structured data – Atom, JSON formats • Uniform URL conventions – Navigation, filtering, sorting, paging, etc.

• Uniform operations – – Addressability GET, POST, PUT, DELETE always mean the same OData

great experiences over an open protocol

data sharing in business applications (or how we learned to say “Information Worker”)

SharePoint 2010 & OData • SharePoint needed 2 things in this space • Flexible data interface – Maximize reach, minimum barrier of entry – Data centric, but enforcing business logic • Developer story – Libraries for as many clients as possible – Great Visual Studio integration

Every SharePoint 2010 site is an OData server

Insight from Data • “Self-service business intelligence” – Let people find and use their own data – …but where’s the data?

• Broad direct database access is impractical – OData feeds expose data over application logic – PowerPivot can handle OData natively • Reports often represent the best data sources – All reports in Reporting Services are now OData feeds

data sharing at large

• • • • • Government data, e.g. OGDI Scientific data, e.g. OSDI Social data, e.g. NerdDinner Commercial public data, e.g. Netflix, Mix Premium data, Microsoft Codename “Dallas”

consistent, up to date

scale to large datasets hosting on the cloud, partitioning

maximize reach, focus investments share libraries, browsers, applications

monetize valuable data “dallas”

advertise data availability

• • • • • • • Servers WCF Data Services SharePoint 2010 Microsoft Media Room • • • Services Netflix Mix 2010 SQL Server Reporting Services 2008 R2 • Nerd Dinner

http://odata.org/producers

IBM WebSphere eXtreme Scale • Open Government Data Initiative Open Science Data Initiative WCF RIA Services • • Microsoft Codename “Dallas” City of Edmonton • • Client libraries • Clients Excel + PowerPivot OData Explorer • • .NET

http://odata.org/consumers

Windows Phone 7 Series • Javascript • • Java Objective-C • PHP

Call to Action • Share your data with OData • Teach data consumers about OData • To get started, go to http://odata.org

• All things OData: http://odata.org

• • • Email: [email protected]

Blog: http://blogs.msdn.com/pablo Data @ MSDN: http://msdn.com/data • Follow up questions in “MSDN Radio” – – Monday 3/22, 10 AM PST http://www.msdnradio.com/ Resources