Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 27, 2017 at 02:38 PM

    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/89ab9f9a29ff4f47a9cf8bda1d135ef5.html

    Part 2:

    Look at the SAP HANA and SAP ASE tutorials section.

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

    Thanks,

    Jin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.