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 🙂