SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Search Topics
Topic Index
SAP HANA Overview
SAP HANA Architecture
Reporting in HANA
SAP HANA Text analysis

Add HANA System in HANA Studio

In the article Download and Install HANA Studio we explained how to download and install HANA Studio. 
In this article we will explain how to add HANA system into HANA Studio

In order to connect to a SAP HANA system we need to know the Server Host ID and the Instance Number. Also we need a Username & Password combination to connect to the instance. The left side Navigator space shows all the HANA system added to the SAP HANA Studio.

Steps to add new HANA system:
    1. Right click in the Navigator space and click on Add System
  • Enter HANA system details, i.e. the Hostname & Instance Number and click Next.
  • Enter the database username & password to connect to the SAP HANA database. Click on Next and then Finish.
  • The SAP HANA system now appears in the Navigator.

  • Support us by sharing this article.

    Explore More
    Close X
    Close X

    36 thoughts on “SAP HANA Studio – Add System

    1. Micha says:

      do you have a tip on how to exportien a HANA system so that you can distribute to 100 clients, after an automatic silent installation?
      A copy of the file secure_storage not enough. When starting the HANA Studio you get the message “Secure storage is locked”


    2. imran says:

      hi i want to open sap hana studio, thanks

    3. harry says:

      Hi can you please provide me the link or procedure to download hana Studio??

    4. Erwin says:

      Hi There I can seem to see the files…are the files still available for download?

    5. vaghani rushi says:

      when i add system in SAP hana studio at that time how to give hostname i have no any idea about that so please help me??

    6. Sathish says:

      I am trying host name as along with my account details but it is returning error as “Not a valid SAP HANA Cloud Platform landscape” while I know it was wokring in past for me so is there any change recently for their trial cloud instance? Please help.

    7. Sri says:

      I have SU01 user id of my Hana system . I have tried connecting using my SU01 user id and it is not connecting. Do we need to ask our administrator to create a different database user to access HANA database from HANA studio ?

    8. Prasenjit Bist says:


      I have a free web HCP a/c, can i use it to add to my eclipse hana developer’s perspective.
      I tried today but it failed.

      Could you please help.

    9. Arun says:

      Hi what is system id?

      • Admin says:


        Send us the screenshot of what the steps were you following at “”.


    10. Anand says:

      Hi Admin,

      i can able to logon my sap system successfully and i am trying to add the same system in HANA studio, but ended with error due to invalid credentials. Could you please help on this..


      • Admin says:

        Please, send us the steps and screenshots at “”, we would look into that.


    11. venkata says:

      I am unable to login through ecllipse.where can I get the username,hostname and password.I entered the details but it is not connecting to the data base.can you look in to this.

    12. srikanth says:

      Hi, i installed eclipse and then installed sap hana tools, sap hana cloud platform tools. After that it says Add HANA System in HANA Studio.

      Where i will find Administration console – SAP Hana Studio.

      When i open eclipse i am not able to find that window.

    13. Juan David Jaramillo says:

      Hi, thanks for the post.

      I have a problem in the last step, I’ve already installed SAP Hana studio but when i tried to connect to the Data Base with the hostname “hanab1” and user name SYSTEM the next message appears “The System cannot be reached, the logon data cannot be used”. I’ve already Restarted the instance usig the command ./HDB stop and start. Any suggestions of how to solve this?

      Best regards.

      Juan David Lozano

      • Admin says:

        Hi Juan,
        There could be multiple reason. May be your HANA system is not reachable or it is the proxy configuration problem. Please try to excess below url in browser.
        If this shows a page with message “HANA XS engine is up and running” then your HANA system is accessible. Otherwise your HANA system itself is not accessible.

        If you are behind a proxy, check the proxy configuration in eclipse as described in the page

        Let me know if the problem still persists.

        Regards, Team

    14. sami says:

      when i Right click in the Navigator space i cannot find Add System ?
      eclips mars v4.5

    15. Michael says:

      Hi, I could not add a system, if fails with the error: “The system cannot be reached. The login data cannot be used”.
      The verification of XSA by using the command: “https://:39030 was not successful. I guess these two things are related to each other.
      I used HANA express 2.0 and Hana studio version 1.0.60. I used instance id 90. The hostname is correct. Does any one have some idea where the problem is?

      Thank you,

      • Admin says:

        Hi Michael,
        Test if HANA XS engine is running by entering a URL in the browser as http://:80.
        If this does not work, then the issue is in your HANA system. Try restarting your HANA system.

        You can also test the port using a telnet session from the command prompt (telnet 30015). Please note that the second and third digit of the port reflects the HANA system number, so if you installed HANA with number 90, the port to check would be 39015.

    16. Syed says:

      I want to use this for learning on my own desktop at home. I have installed studio, is there a way I can hoop up a cloud system (ex. azure) to it to teach myself?


    17. Rahul says:

      Hi Buddy,
      THANKS SO MUCH for sharing this!
      I would love to buy you a coffee, since I now won’t be up all night that has been driving me crazy (until now!!). I just wish I knew what was going wrong but so glad it’s in the right place now! Thanks again:)

      ColumnA ColunmnB ColumnC ColumnC
      A 10 xyz Ab
      A 20 def Ab
      A 5 mno Xy
      B 10 pqr Ab
      B 40 abc Xy
      C 10 uvw Xy
      I need to calculate total average as well as average for each value of ColumnD
      Total Average(divided by unique ColumnA):
      Now I need Average for Ab=>
      Average for Xy=>
      I made Calculated Column in Hana:
      Counter-> CA_Count on ColumnA(to get unique Count) CA_Avg ->
      for Avg of Ab: CA_AVG_Ab :
      but this Value is not coming correctly when we use filter in output

      Appreciate your effort for making such useful blogs and helping the community.
      Best Regards,
      Kevin Durant

    18. Irene Hynes says:

      Hello Buddie

      THANKS SO MUCH for sharing this! I would love to buy you a coffee since I now won’t be up all night that has been driving me crazy (until now!!). I just wish I knew what was going wrong but so glad it’s in the right place now! Thanks again:)

      I have created one ADSO through SAP BWMT 1.18 version on SAP HANA edition 1. sps11 with SAP HANA Studio version been 2.3.32 and then created calculation view on top of the hana view table for my ADSO.
      The view is active without any error, Checked SYS_BIC column views. but when i do Data preview i get error “View not found. Either the view is inactive or the selected attribute is not present in the active view.”
      I went through few discussion and it was noted that latest version of the HANA studio solved the issue but they did not precise what was their version and Environment details.
      Could you please help me out on what could be the reason for such error?

      By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).

      Please keep providing such valuable information.

      Thank you,
      Irene Hynes

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    Current day month ye@r *

     © 2017 :, All rights reserved.  Privacy Policy