cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud Configuration to Import Data from API

LoBello
Newcomer
0 Kudos
108
Hello experts,
I am trying to import data from an API into sap analytics cloud, but it displays an error message when connecting.
I made the same connection through postman and it worked, but the SAC displays an error message.
More information: 
Connection type: Odata Services Authentication Type: OAuth 2.0 Client Credentials

LoBello_0-1725365465112.png

On system monitor shows the message:

 {"packageId":"sap.fpa.services.resource.dataAcquisition","objectName":"message_dataAcquisition","messageId":"AUTHENTICATION_ERROR","args":["Unauthorized"],"message":"Unable to connect to datasource. Check the connection details and user credentials, and then try again.","previous":null,"bUIMessage":false,"bWarning":false,"customData":"Authentication Failed:PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target (If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)","status":401}
what could be causing the error?

Thanks,
Lo Bello


 

Accepted Solutions (0)

Answers (1)

Answers (1)

JBARLOW
Contributor
0 Kudos

"Authentication Failed: PKIX path building failed":
This points to an issue with SSL/TLS certificate validation.
The error means that SAC cannot verify the certificate provided by the server (API) because the required intermediate or root certificate is missing from the trust store.

If the certificate chain is missing a trusted root or intermediate certificate, you’ll need to import these certificates into the SAC trust store.

Obtain the necessary certificates (usually available from the API provider or extracted via a tool like OpenSSL)

If you're a SAC administrator - import the missing certificates into SAC's trust store.