OData the silo buster

June 14, 2011


Like many others I am eagerly awaiting the release of SAP Netweaver Gateway, a technology which promises to simplify SAP integration. By exposing SAP Business Suite functionality as REST based OData services Gateway will enable SAP applications to share data with a wide range devices, technologies and platforms in an easy to understand and consume manner.

The intention of this blog is to give a high level overview to the Open Data Protocol (OData), showing by example how to access and consume the services.  For a more concise definition I recommend the following recently released article – Introducing OData – Data Access for the Web, the cloud, mobile devices, and more

What is OData?

“OData is to Rest what MS Access is to databases”  a complimentary tweet I read, because MS Access is very easy to learn it allows users to get close to the data and empowers them to build simple and effective data centric applications.

“OData can be considered as the ODBC API for the Web/Cloud” Open Database Connectivity (ODBC) is a standard API independent of programming language for doing Create, Read, Update and Delete (CRUD) methods on most of the popular relational databases.

“OData is a data silo buster” 



Essentially OData is an easy to understand extensible Web Protocol for sharing data. Based on the REST design pattern and AtomPub standard, it provides consumers with a predictable interface for querying a variety of datasources not only limited to traditional databases.

OData Services

Odata.org provides a sample of the Northwind Database exposed as OData formatted services, this is a great resource for exploring the protocol.

**If you are using IE you may want to disable the feed reading view.

The link below is to the Northwind service document, it lists all of the service operations, each operation represents a collection query-able data.



To access the Customers collection we append the link provided above to the base url as follows


We can accesses specific Customers via the links provided in the feed http://services.odata.org/Northwind/Northwind.svc/Customers(‘ALFKI’)

With the query string operations we can start to control the data provided, for example paging Customers 20 at a time.

http://services.odata.org/Northwind/Northwind.svc/Customers?$top=20 http://services.odata.org/Northwind/Northwind.svc/Customers?$skip=20&$top=20

Using filters we can search for Customers in a particular city or Products in our price range

http://services.odata.org/Northwind/Northwind.svc/Customers?$filter=City eq ‘London’

http://services.odata.org/Northwind/Northwind.svc/Products?$filter=UnitPrice le 200 and UnitPrice gt 100

Once we have found the data we wanted we can use the links to navigate to the related data. http://services.odata.org/Northwind/Northwind.svc/Suppliers(2)/Products


Finally we can format the response as JSON



Consuming OData

To illustrate how easy it is to consume OData, I am sharing simple JQuery Mobile application, it uses the following tables and relationships.


OData Sample Application – hopefully the 100 lines of HTML code, JavaScript and annotations are easy to follow, copy the source to a html file, save it locally and run in a browser. Best viewed in the latest versions of Firefox, Chrome and IE.

image image image

Opening up more than data

A couple of months ago I set off on a exercise to learn all I could about OData, along the way I started investigating some of the available opensource libraries like datajs and odata4j, rediscovering a passion for JavaScript and Java.  Through the many examples and resources available it was surprising how easy it was to take my limited skills into the world of Cloud and Mobile application development.


Similar in many ways to ODBC and SOAP, OData is an initiative started by Microsoft as means for providing a standard for platform agnostic interoperability. For it to become successful it needs to be widely adopted and managed.

From a high level the strengths of OData are that it can be used with a multitude of data sources, it is easy to understand and consume. From what I have seen it will be great for simple scenarios and prototyping. Early to tell what its real weaknesses are, however to be simple and easy to use there has to be either a lot of pipes and plumbing or constraints and limitations when used on top of technologies like BAPI’s and BDC’s, things like managing concurrency, transactions and state come to mind. Conversely the threats of not being adopted and competing standards and initiatives like RDF and GData represent some big opportunities for an extensible protocol.



June 5, 2008

This years SAP Teched tells us to

  • Connect, collaborate, and co-innovate with the best minds in the IT industry.
  • Get the knowledge, skills, and professional network needed to take advantage of SOA.
  • Learn how to use the power and flexibility of SAP NetWeaver to co-innovate with SAP
  • Inspiring I know. Before you run off to convince your boss that you should go to Vegas for a week long jolly. Enjoy
    Read the rest of this entry »

    Taking Confluence for a wiki testdrive

    May 28, 2008

    My boss must have just comeback from an IT conference, he calls me into his office starts off by saying “having effective knowledge management can increase the net worth of a consultancy by at least 100%”. He was preaching to the converted, I walk out of his office with the assignment of evaluating Confluence as a knowledge management solution for our company globally.

    ‘‘If HP Knew what HP Knows we would be three times more profitable.’’ Lew Platt, former CEO of Hewlett Packard

    I love Wiki’s after google, Wikipedia has to be my second most used site. I have used Confluence many times on many sites including SAP SDN, IBM dveloperWorks to name a few. I was looking forward to giving this product a test drive. Plus Atlassan are aussie as.
    Read the rest of this entry »

    SAP Certification gets a makeover

    May 26, 2008

    Queer eye for a SAP guy

    Move over big 5, training needs a makeover

    IN a radical move, German enterprise software giant SAP has finally loosened the grip on its tightly held training and certification program as the shortage of skilled consultants worsens.

    SAP certification gets total makeover | Australian IT

    The comments make for interesting reading.

    In the news i hear about this perceived shortage of labor. In the same bulletin you hear big bank has outsourced entire IT operations, large employer investigated for underpaying workers on 457 visas.

    Shortage of skilled consultants – Isn’t this just propaganda and the real shortage is cheap experienced labor?

    Read the rest of this entry »

    HP to consume EDS – bring it on

    May 17, 2008

    “More companies die of indigestion than starvation.”
    (“The HP Way,” Hewlett-Packard co-founder David Packard, page 142)

    Back in 2002 HP got heartburn from a Compaq takeover. EDS has over 135,000 staff – I hope they bought some Tums cause its a big fish to swallow.