Skip to Content
0
Jul 20, 2023 at 01:09 PM

How to make connection with sap hana db with sap ai core by using libraries hdbcli or sqlalchemy?

512 Views

Hi ,

I'm trying to make a connection between sap hana db and sap ai core but getting below error:

hdbcli.dbapi.Error: (-10709, 'Connection failed (RTE:[89009] Socket connect timeout (60000 ms)(<some IP:port> -> <db ip:port>))'). I have tried with hdbcli and sqlachemy both but getting stuck on above error. I have used below code to make the connection and it worked in my local system (jupyter notebook) as they are in same network but throwing error in sap ai core. Kindly suggest how to resolve this issue. My motto is to extract tabular data from sap hana db only and utilize in SAP AI core to perform ML scenarios.

Thanks

Attachments

image.png (23.5 kB)
image.png (25.3 kB)