Python-SAP HANA cloud connection

[former_member16553]

Hi Expert,

I was trying to establish connection between python (Juypter notebook) to SAP HANA cloud(trial version) using HANA_ML by following the blog https://blogs.sap.com/2020/07/27/hands-on-tutorial-automated-predictive-apl-in-sap-hana-cloud/ but getting connection time out error ' Error: (-10709, 'Connect failed (connect timeout expired)')' .

It looks like it may be due to any firewall or VPN. Hence , have tried by passing the proxy server details by following https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/ee592e89dcce4480a99571a4ae... as well but no luck.

Can you please suggest if it's due to any other issue or if there any other settings require for proxy? Thanks.

Regards,

Girdhari

[dvankempen]

Hi Girdhari,

When you created the SAP HANA Cloud instance, how did you configure the IP allow/blocklist?

As documented, SAP HANA Cloud Getting Started, Allowed Connections

• https://help.sap.com/viewer/db19c7071e5f4101837e23f06e576495/2020_03_QRC/en-US/f7febb16072b41f7ac90a...

[girdhari]

Hello Denys,

Thanks for your response.

Had tried with both option 'Allow all IP addresses' and Allow specific IP address but got same error.

Regards,

Girdhari

[dvankempen]

That's good; so your HC instance is accessible. We can get in, in other words. Then the issue is probably that the Python client cannot get OUT.

Assuming you work from an office location? Maybe you try a public type WiFi and see if that works. Next step then would be to configure proxy/fw

[former_member16553]

Thanks Denys.

Yes, I'm trying with office machine. Have tried to set up proxy in Jupyter notebook by following the suggestion given in https://stackoverflow.com/questions/36629707/using-jupyter-behind-a-proxy and then tried to connect HC instance by adding proxy parameters in HANA_ML Connection context function but no luck. Am I following the right approach or Is there any other steps needs to be execute to configure proxy/fw? Please suggest.

Regards,

Girdhari