Skip to Content

Setup Eclipse for SAP HANA in SAP Cloud Platform Neo Trial

Beginner
10 min.
Setup Eclipse for SAP HANA in SAP Cloud Platform Neo Trial
You will learn
  • How to open a tunnel to SAP HANA container in SAP Cloud Platform Neo trial
  • How to connect to you SAP HANA instance from Eclipse
fath-markusMarkus FathFebruary 7, 2023
Created by
Sygyzmundovych
September 13, 2018
Contributors
thecodester
jmmargo
Sygyzmundovych

Prerequisites

  • Completed software installation as per CodeJam prerequisites
  • Step 1

    Go to the location where you uncompressed SCP Neo SDK (like ...\neo-java-web-sdk\) and then to the subfolder tools.

    From the command line run the following to open a tunnel to your instance of a database.

    sh
    Copy
    neo open-db-tunnel -h hanatrial.ondemand.com -a <your_SCP_Neo_Trial_account> -u <your_SCP_user> -i <your_HANA_MDC_instance_name>
    

    Provide your SCP user password to open the tunnel.

    Open tunnel
    Log in to complete tutorial
  • Step 2

    Open Eclipse Oxygen with SAP HANA Tools installed.

    Open SAP HANA Administration Console perspective by going to Window -> Perspective -> Open perspective -> Other, and then choosing SAP HANA Administration Console from the list.

    In this perspective right click on empty area of Systems pane and choose Add System…

    Add System

    On the first dialog’s screen Specify System type:
    - Host Name: localhost
    - Instance Number: 00

    Click Next

    System

    On the dialog’s screen Connection Properties type:
    - User Name: SYSTEM
    - Password: the password you specified when creating the database, e.g. Welcome18Welcome18

    Click Finish

    User

    If all parameters where correct and the tunnel is open, then the new system entry is added.

    Log in to complete tutorial
  • Step 3

    Right click on your system and choose Open SQL Console

    In SQL Console type the following code and execute it to check everything is fine.

    SQL
    Copy
    select 'Hello CodeJam!' as Greeting from dummy;
    

    Log in to complete tutorial
Back to top