SAP Cloud Platfom Integration – Connection to OData API in Hana fails
I am doing a lot of demos to my customers, so that we do a “reality check” in regards to what our actually can do. Once you start playing around with it, it’s pretty simple, but sometimes you get stuck and you don’t really now why. Hence this blog entry…
So this morning I was preparing a quick demo for a customer, where I would show the SAP Cloud Platform Workflow Service, API Management and Integration. However, the integration flow would not start. Thanks to the tracing capability of SAP Cloud Platform Integration, I could quickly narrow down the issue. I simply set the trace level to “Debug” and went to the Monitoring Screen of CPI. There I clicked on the “Debug” link.
From there, I could see that there was an issue with the communication with the OData REST API of Hana.
The message was quite clear:
OData Method : CREATE_ENTRY Request URI : GET https://mytenant.hana.ondemand.com/TicketAgency/data.xsodata/$metadata HTTP/1.1 Request Headers : Authorization : Basic ******** x-csrf-token : fetch , cause: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
So basically the certificate of the target system, Hana, was missing in CPI.
How to get it? Described here!
Once I downloaded the certificate, I imported it in SAP Cloud Platform: Monitoring > Manage Security > Keystore > Add > Certificate.
All done! And the demo was a success 🙂
Very nice post, thank you so much.
Do i have to do the same for other SAP cloud products (S/4HANA cloud etc...) ?
I am not sure wether you have to do this for other SAP products. However, to have systems communicate with each other, it is common to establish trust with the use of certificates: this is a standard mechanism that I believe is used in other SAP products as well.