3509759 - 'server certificate couldn’t be validated' error when connection SAP Datasphere to SAP Successfactors

Symptom

SAP Datasphere DSP data extraction from remote SuccessFactor table (e.g. JobRequisition) in is throwing the following certificate error:

Error: Connection "SuccessFactorsT5" is valid, but not all features are available. - Data flows are enabled. - Replication flows are not supported. - Remote tables can’t be used because of errors in the connection.
Remote Tables: Could not establish a secure connection because the server certificate couldn’t be validated. Please upload the certificate of the server or the certificate of the signing authority (CA). If you’re not authorized, please contact your administrat

Environment

SAP Datasphere
SAP Sucessfactors

Cause

Wrong certificate is being used.

Resolution

To establish the connection between SAP Sucessfactors and SAP Datasphere, follow all the configurations outlined in the SAP Blog Connecting SAP SuccessFactors and SAP Datasphere.
You can also use the guides of SAP Help below:

If you have followed all the above configurations and the issue persists, in addition to the instructions in the blog, you can retrieve the TLS server certificate from the endpoint specified in the connection definition. For example:

openssl s_client -showcerts -connect api41.sapsf.com:443 </dev/null

After retrieving the certificate, you can upload it under Configuration -> Security in SAP Datasphere.
Note: You should change the SuccessFactors Server to match your specific server (the sample uses api41).

Keywords

SF, SUccesfactors, T5, DS, Error, cer, pem, .pem, Certificate, issue, authorization, SSO, cert , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions