In Qlik Cloud, the following error may occur when extracting data from SAP HANA cloud using JDBC connector
ex1: Error connecting to source: SAP DBTech JDBC: Cannot connect to jdbc:sap://xxxxxxxxxxxxxx.xxx.xx-xxx.hanacloud.ondemand.com:443/ [Cannot connect to host xxxxxxxxxxxxxx.xxx.xx-xxx.hanacloud.ondemand.com:443 [Received fatal alert: insufficient_security], -813.].
ex2: Error connecting to source: SAP DBTech JDBC: Cannot connect to jdbc:sap://xxxxxxxxxxxxxx.xxx.xx-xxx.hanacloud.ondemand.com:443/user=xxxUSER#xxx&password=???? [Receive of connect failed.].
However, connecting to the SAP Hana Cloud Database succeeds when using DBeaver tool with JDBC drivers.
Resolution
Problem Investigation "QB-22934" was reported to R&D
To connect to SAP HANA cloud using JDBC connector, you need to add "encrypt=true" in the connection string. An example can be found here https://help.sap.com/docs/cloud-integration/sap-cloud-integration/jdbc-for-sap-hana-cloud
If the connection string contains username and password, please use the Wallet Encrypted properties to add these kinds of values such that stored encrypted and never visible anywhere.
Ex: jdbc:sap://xxxx.hanacloud.ondemand.com:443/databaseName=xxx?user=xx_xx#xxxUSER&password=xxxxx&encrypt=true
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-22934 for reference.
Environment
