ODATA Adapter in SAP CPI

This blog will cover the configuration steps of the ODATA Adapter in SAP CPI.

What is OData Protocol

OData is an open standard protocol that allows service providers to define access to their resources in a standardized manner. The service definition is available via the service metadata document (EDMX).

OData allows resources (Entity Sets) to be identified using Uniform Resource Identifiers (URIs) and defined in an abstract data model.

More details about OData protocol at http://www.odata.org/

ODATA Adapter in SAP CPI

The OData adapter allows you to communicate with an OData service using the OData protocol. You use messages in ATOM-XML or JSON format for communication.

To under the configuration of the ODATA adapter in sap CPI, we will create a scenario to call OData service.

Here is a free ODATA service available which will be used in IFlow

https://services.odata.org/V3/(S(bid50yrhxb1npwijxs1xdnpv))/OData/OData.svc/

Integraition Flow 

HTPPS–> SAP CPI–> ODATA

Iflow in sap cpi

Configure OData Adapter

Select the receiver adapter type as ODATA.

In Connection Tab put

Address: https://services.odata.org/TripPinRESTierServic.

Authentication: None ( as this is free service but use the appropriate for your odata connection)

ODATA adapter in sap cpi

Select the Tab Processing

This tab provides the information on how the query needs to process

ODATA Adapter

Choose the appropriate Operation. In this case its GET

Resource Path: click on select and it will open a pop-up

Odata adapter

Click Step2

Odata Adapter

Select the Entity

odata adapter in sap cpi

In this case, we will be using People.

Odata Adapter

Select the fields and Finish.

ODATA adapter

Now Save and deploy the Iflow.

Using Postman test the Iflow

Postman Testing in sap cpi

 

Reference

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/2d8251111ea74dbbb9f5525db5d9ad04.html?q=ODATA

 

More CPI Blogs

Data Store in SAP CPI

How to Test Iflow in SAP CPI

SOAP To Mail Scenario in SAP CPI

 

One thought to “ODATA Adapter in SAP CPI”

  1. Sandeep Raman says:

    I like your post very much. please keep posting on SAP PI and CPI topics.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.