Question Re: Data Intelligence and Hana Cloud Connection error in Technology Q&A

Data Intelligence and Hana Cloud Connection error

former_member235648 — Fri, 25 Feb 2022 17:09:41 GMT

HI,

I am trying to create a connection between SAP Data Intelligence and Hana Cloud, but I am not able to create a connection due to an error below.

Exactly as suggested in the link

https://developers.sap.com/tutorials/hana-cloud-connection-guide-4.html

Code:1300004Message:Cannot establish JDBC connection. Error: SAP DBTech JDBC: Cannot connect to jdbc:sap://b8a1dd64.hana.prod-us10.hanacloud.ondemand.com:443 [Object is closed: com.sap.db.jdbc.SecureChannelSession@4fc1b-8d81ed0d64.hana.prod-us10.hanacloud.ondemand.com:443 ConnectionID:0 SessionID:0 on sun.nio.ch.UnixAsynchronousSocketChannelImpl[connected local=/1:37042 remote=b8a1d.hana.prod-us10.hanacloud.ondemand.com/54168:443]].

What do you suggest to resolve this situation and allow me to create a connection between the two tools?

Thanks

Re: Data Intelligence and Hana Cloud Connection error

lochner_louw — Mon, 28 Feb 2022 01:37:11 GMT

Hi Vitor,

From experience when I added HC instance to my DI instance it didn't work.

First error I had was that I had to leave "Validate host certificate" off and the second was that I had to add the DI instance IP to the allowed list in HC.

Thanks,

Lochner

Re: Data Intelligence and Hana Cloud Connection error

former_member789976 — Thu, 03 Mar 2022 14:13:05 GMT

Hi,

You need to configure hana and DI instance in cloud connector.

please refer below

https://blogs.sap.com/2020/05/27/how-to-integrate-sap-data-intelligence-and-sap-s-4hana-anypremise/

Thanks.

Deepak Rai