What’s New with OData 4: OData 2 vs OData 4

What’s New with OData 4: OData 2 vs OData 4

Posted on October 26, 2017 0 Comments
What’s New with OData 4 OData 2 vs OData 4_870x220

OData 4 differs significantly from OData 2. Learn about the differences between them when using Hybrid Data Pipeline and decide whether you need OData 2, OData 4 or both.

OData (Open Data Protocol) defines a set of best practices for building and consuming RESTful APIs. OData is very popular and has been adopted by many technologies and companies including SAP, IBM, Salesforce, Tableau, Databoom, Progress, Red Hat and Dell. If you’d like to learn the basics of OData, see our OData FAQs.

Progress is proud to serve on the OData Technical Committee. In fact, we were one of the original members of this committee, along with other technical giants such as IBM, Microsoft, SAP, Redhat, CA and Citrix. We offer Hybrid Data Pipeline, the industry’s first vendor-agnostic data gateway, which lets you OData-enable your data source through simple clicks.

10 Major Differences Between OData 2 and OData 4

As you consider enabling your application or data source with an OData endpoint, you will invariably ask yourself if you should use OData 2, OData 3 or the latest OData 4 version. While OData 3 and OData 2 are very similar, OData 4 is drastically different from OData 2. With the latest release, Hybrid Data Pipeline can help you produce both OData 2 as well as OData 4 from your data sources. Understanding the differences between these endpoints from Hybrid Data Pipeline can help you decide if you need OData 2, OData 4 or both:

  • OData 2 was a Microsoft Open Specification Promise (OSP), while OData 4 is approved by OASIS and ISO. While developers were apprehensive about adopting OData 2, we are observing more adoption for OData 4.
  • According to the OData 2 specification, payload had to be retrieved in both XML and JSON formats. In OData 4 however, XML is optional. So, Hybrid Data Pipeline today supports both XML and JSON in OData 2 and only JSON in OData 4. However, the metadata can still be retrieved in the XML format in OData 4.
  • In OData 4, the JSON data format now allows you to control the amount of metadata that is returned in query responses. There are three levels of metadata supported:
    • Full—The response contains all the metadata needed to describe the response.
    • Minimal—The response metadata references the metadata document. Information in the metadata document is not repeated in the response.
    • None—The response contains no metadata. The application must understand the response structure.
  • Hybrid Data Pipeline supports batch requests in OData 4 only. Batch requests allow you to submit multiple operations in the form of a single endpoint request. Operations are submitted in the HTTP request payload and can include individual requests and change sets. (For more information on batch requests, see this article.)
  • OData 4 adds a new flexible search capability, $search. The search feature allows you to query a collection for entities that match a specified search expression. Unlike the existing filter capability, which allows a query to specify that a specific property or properties match certain criteria, the search feature can apply the search expression to any of the properties of an entity. Hybrid Data Pipeline extends this feature to OData 2 as well using the $ddsearch feature.
  • The $expand system query option has been enhanced in OData 4. This feature specifies the related resources to be included in line with retrieved resources. In OData 2, if a single value navigation property is expanded, you get all the properties of the entity if it was a single value navigation property. And if a collection navigation property is expanded, you get all of the entities in the collection and all of the properties of those entities. In OData 4, you can now refine the results using the $select, *, $filter and $top operations:
      * Used to expand all relationships for the entity.
      $filter Used to filter the child entities that appear in the expanded result.
      $top Used to limit the rows that appear in the expanded result.
      $select Used to limit the fields that appear in the expanded result.
  • When doing an update there are two ways to update an entity: replace the definition of the entity with a new entity (Replace semantics). Or, you can change individual properties of an existing entity (Edit semantics). The HTTP PUT method is used to update an entity with Replace semantics. In OData 4, the standard HTTP PATCH method is used to update an entity with Edit semantics. OData 2 used the non-standard MERGE HTTP method for updates with Edit semantics.
  • $count replaces $inlinecount in OData 4. $count has been enhanced to be used with $filter, $expand and $orderby options.
  • Changes in support for data types in OData 4:
    • DateTime has been deprecated. The lack of timezone information in OData 2 causes significant problems. Use DateTimeOffset instead.
    • Edm.Time has been replaced with Edm.Duration and Edm.TimeOfDay to make it clear whether it is duration of a specific time of day.
    • Edm.Date has been added as there was no way to express just a date in OData 2.
    • Edm.Float has been eliminated.

All these and many other enhancements in OData 4 give a significant performance boost to your application compared to OData 2. You can learn about the other differences in this article from OASIS.

Support OData 2 and OData 4—or Both—Using Hybrid Data Pipeline

Due to the significant changes in the way these frameworks are defined, you’ll need different clients to consume both the OData 2 and OData 4 endpoints. Thanks to all the latest changes, OData 4 shows significant performance improvement compared to OData 2. While some functions have been replaced and enhanced, some of them have been deprecated — for example support for the XML Data Format. 

If you’re building an application for the modern ecosystem, OData 4 is a no brainer as it gives you a significant performance boost. However, some existing applications need OData 2 or an XML payload. For that reason, you should leverage Hybrid Data Pipeline, which supports both interfaces without any coding at all.



Nishanth Kadiyala

Nishanth Kadiyala is a Technical Marketing Manager at Progress. He got his B.Tech degree from IIT Guwahati and his MBA from UNC Chapel Hill. He has worked on several technologies including database designing, SQL querying and Cloud Computing in the past. Currently, he is committed to educating enterprises about standards based connectivity via ODBC, JDBC, ADO.NET and OData. He is also proficient with DataDirect Hybrid Connectivity Services – DataDirect Cloud and Hybrid Data Pipeline. You can stay in touch with him through Twitter.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation