Set up Snowflake connector in SAP BO

[former_member605167]

Hi All,

To connect to snowflake from SAP BO, I followed the steps in

https://blogs.sap.com/2018/11/20/how-to-set-up-sap-businessobjects-with-snowflake-using-jdbc/

After everything is setup I am seeing error.

JDBC driver encountered communication error. Message: Exception encountered for HTTP request: sun.security.validator.ValidatorException: No trusted certificate found./ No root CA found

I can see certificate in keystore list both Server and client locations.

Please help if anything is missing.

Thanks,

Bala

[Patrick_Perrier]

Hi,

You can do this without certificates now that it is officially supported:

https://blogs.sap.com/2020/03/12/snowflake-for-sap-businessobjects-4.2-sp08/

[former_member552250]

Hi Abhinav,

Do you have any steps on how to add right certificate ? I have added the certificate downloaded from snowflake site however Im still getting the error "JDBC driver encountered communication error. Message: Exception encountered for HTTP request: java.security.cert.CertificateException: Failed to find the root CA.."

[abhinav_shrivastava1]

Hi Bala,

Seems the certificate added either not added correctly or its not the right certificate.

As a best practice, I first added the certificate on my client installation, created and tested the connection using local connection, later modified the cacert on server.

Regards,

Abhinav