How to access from Cloud Platform Java app via JDBC to HANA instance on Premise?

[lionel_passerino]

Hello all,

Does someone has an example/tutorial of coding snippets on how to access from a Cloud Platform Java app an HANA instance via JDBC through a Cloud Connector attached HANA instance on Premise?

Thanks and best regards,

Lionel.

[former_member197689]

Hi Lionel,

You need to install the cloud connector on the same network with your HANA system.

https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/89ab9f9a29ff4f47a9cf8bda1d1...

Part 2:

Look at the SAP HANA and SAP ASE tutorials section.

https://help.sap.com/viewer/65de2977205c403bbc107264b8eccf4b/Cloud/en-US/8105b26e430a4aea9dc46a7aa6f...

Thanks,

Jin

[lionel_passerino]

Hello Jin,

Thanks. I did already find the linked descriptions (and working examples) to run JDBC against the build-in (shared or "hosted") HANA instance running on Cloud Platform... but my quest is:

How to attach/bind an OnPremise HANA instance (through SAP Cloud Connector) to a java application running on Cloud Platform?

The native HANA JDBC (ngdbc.jar) is failing to load when trying my app in on the Cloud Platform. Secondly SAP Cloud Connector offers only to open an TCP (SOCKS) channel to my HANA OnPremise instance.

Would be nice if anyone could point me into the right direction.

Thanks and best regards,

Lionel.