HANA XS ODATA

HANA XS ODATA: OData is a resource-based web protocol for querying and updating data. OData defines operations on resources using HTTP commands (for example, GET , PUT , POST , and DELETE ) and specifies the uniform resource indicator (URI) syntax to use to identify the resources.

Expose data residing in SAP HANA via Odata services

Introduction: HANA XS ODATA

The articles Introduction to OData Service and OData Architecture explain the basics of OData.
In the article Introduction to SAP HANA XS, we also explained that SAP HANA XS can be used to expose data from Tables, Views and Modeling Views to UI layer.
In HANA XS, there are major 2 ways to expose data the data to clients – OData and XSJS. In this article we will talk about OData.
In this article we will explain

  • How OData service works in SAP HANA?
  • What is XSOData (OData file in HANA)?
  • SAP HANA OData Framework.

Note: For XSJS, read the article SAP HANA XSJS Service

OData Service in SAP HANA:

An OData service exposes data stored in database tables or views as OData collections for analysis and display by client applications.

The client can be web browser, or SAPUI5 application or HTML5 application or any other application which supports OData.

An OData service for SAP HANA XS is defined in a text file with the file suffix .xsodata, for example, OdataSrvDef.xsodata.

The XSODATA services are great because they provide a large amount of functionality with minimal amounts of development effort.

Important points on HANA OData Service (XSODATA):

  • SAP HANA XS currently supports OData version 2.0
  • OData defines operations on resources using RESTful HTTP commands (for example, GET, PUT, POST, and DELETE).
  • Data is transferred over HTTP

XSOData Examples:

An OData service for SAP HANA XS is defined in a text file with the file suffix .xsodata

The file must contain at least the entry

service {

}

The following example shows how to include a reference to a table in an OData .

service {

“mySchema”.”myTable” as “MyTable”;

}

You can also expose Attribute, Analytic and Calculation view using XSOData.

Suppose there is a calculation view called “Sales” in a package “sap.hana”, then the service will be like:

service {

“sap.hana”::”Sales” as “Sales”;

}

Read-only XSOData Service: (HANA XS ODATA)

By default, all entity sets in an OData service are writeable, that is they can be modified with a CREATE, UPDATE, or DELETE requests.

However, you can prevent the execution of a modification request by setting the appropriate keyword (create, update, or delete) with the forbidden option in the OData service definition.

The following example of an OData service definition for SAP HANA XS shows how to prevent any modification to the table myTable that is exposed by the OData service.

service {

“mySchema”.”myTable” as “MyTable”

create forbidden

update forbidden

delete forbidden;

How to consume HANA XS OData service in SAP Netweaver Gateway

Step-by-Step Procedure

  • Related Posts

    Attachments for SAP XI/PI – ARIBA Invoices sent via PI to S/4HANA

    Integration with SAP systems has never been more intriguing, especially with Ariba, Workday, Concur, Successfactors, Fieldglass, Hybris, and other satellite cloud solution vendors banging on doors every day. 🙂 I…

    11 Steps to Include a New Field in an Already-Existing SAP LSMW Batch Input Recording

    Alright. Why in the world do we care about LSMW in this paper when S/4HANA migration cockpit should ideally replace it? 🔥🎥 The simple answer is that not all people…

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    You Missed

    SAP XI/PI – Invoice Attachment Transfer from ARIBA to VIM

    • By Varad
    • November 8, 2024
    • 3 views
    SAP XI/PI – Invoice Attachment Transfer from ARIBA to VIM

    11 Steps to Include a New Field in an Already-Existing SAP LSMW Batch Input Recording

    • By Varad
    • November 6, 2024
    • 3 views

    Part 23 of ABAP for SAP HANA. How Can AMDP Be Used to Access Database Schema Dynamically?

    • By Varad
    • November 4, 2024
    • 3 views

    S/4HANA VDM 1 Employing CDS Virtual Data Model for Embedded Analytics

    • By Varad
    • November 1, 2024
    • 5 views