How to Consume a REST Web Service from SAP BW Datasource

[Former Member]

I am looking for information about consuming a REST Web Service from an SAP BW 7.3 Web Service Datasource.

The REST Web Service would exist in a non-SAP System and will be called from SAP BW 7.3 Web Service data source.

I don't even know if its possible from SAP BW 7.3 or not as SOAMANAGER seems to be only about SOAP but I could be wrong.

A Step by Step guide would be a great help.

Thanks in advance!

Suresh

[former_member198401]

Suresh,

You cannot call REST web service using SAP BW Source datastore as you can only use IDOCS, Open Hub Tables and Tables.

Below are two methods:

1) Using HTTP Adapter: You can achieve this using a HTTP Adapter Datastore. You need to create a HTTP Adapter instance in DS Management Console and then call the REST web service with parameters.

Follow the document

https://blogs.sap.com/2013/07/01/consuming-rest-web-service-with-parameters-in-bods-using-http-adapt...

2) Using Web Service Rest Datastore: If you dont want to use HTTP Adapter you can directly use REST Web Service Datastore.

https://blogs.sap.com/2016/06/07/consuming-rest-web-service-in-sap-data-services-using-web-service-r...

Regards

Arun Sasi