Connect to Hana Cloud from solaris or aix machine

[daniela_boamba]

Hello,

Did anyone arrived to connect to hana cloud from a aix or solaris machine?

I have the next config :

DSN entry in Odbc.ini :

[Hanawarehousecloud]

Driver=/usr/u/qaunix/hana2sp05/sap/libodbcHDB.so

ServerNode=hanacloud.ondemand.com:443

USER=test

PASSWORD=password

encrypt=TRUE

I have the next error message : SSL certificate validation failed: SSL3_GET_SERVER_CERTIFICATE

Thank you all.

Daniela

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[dvankempen · Accepted solution]

Hi Daniela (bonjour !),

Assuming ServerNode is configured with the complete string, e.g=12345678=abcdefg-1234567-etc.hana.prod-eu10.hanacloud.ondemand.com:443

Does the SAP HANA client contains the certificate?

As documented:

If you encounter issues with the encrypted SQL connection, then verify that the trust store used by the SAP HANA client contains the root certificate 'DigiCert Global Root CA'. This can be downloaded in CRT or PEM format. For hdbsql connections, the connection string must either explicitly reference the trust store that contains this root certificate or you can configure the SAP Common Crypto Library to get the certificate information from $SECUDIR/sapcli.pse

• How to Use the Client Interfaces with SAP HANA Cloud, SAP HANA Client Interface Programming Reference

For the SAP HANA service, we recorded a video tutorial series at the time about how to configure the clients.

• https://blogs.sap.com/2019/01/17/secure-client-connections-for-the-sap-hana-service-by-the-sap-hana-...

[daniela_boamba · Accepted solution]

Hello Denys for your time and answer.

We found that we need to download the certificate from https://www.digicert.com/kb/digicert-root-certificates.htm and modify the odbc.ini by adding sslTrustStore=<certificate string>;

I'm a fan of your video academy 🙂

Thank again.

Daniela

[dvankempen · Accepted solution]

Hi Daniela,

Thanks for watching and good to hear this solve the issue. Would you mind marking the answer as correct should this be the case? This helps to improve search results on the Q&A. Merci !