How to add an SAP HANA System in HANA Studio ?

Prerequisites

• The relevant ports in your firewall are open.
• If you want to secure communication between the SAP HANA server and the SAP HANA studio using the Secure Sockets Layer (SSL) protocol, you have configured the server for SSL and imported the trust store file that contains the server root certificate into either the Java keystore or your user keystore on the client.
• You must have a database user, or the necessary infrastructure for Kerberos-based user authentication must be in place.

Procedure

1. From the Systems view toolbar, choose  (Add System...).
   The System wizard opens.
2. Enter the required system information:
• System connection properties (required)
  • Host name
  • Instance
  • Mode

  
  

System Connection Properties

To connect to an SAP HANA system or database in the SAP HANA studio, you must specify its connection properties (host, instance, and mode).

Property	Description
Host name	Fully qualified domain name (FQDN) of the host on which the system is installed Multi-host system If you are adding a multi-host system, specify the master host. You do not have to enter all host names explicitly as they are determined automatically. If the master host becomes unavailable, the connection is automatically established through one of the other hosts. Hosts that are added to the system later are also detected automatically. Tip Once you have finished adding the system, you can see all available hosts in the system properties. Right-click the system in the Systems view and choose Properties. All hosts are listed on the Hosts Used to Connect tab of the Database User Logon page. Note The host name of the server that hosts the database must be accessible from the client on which the SAP HANA studio is running, even if you add the system using its IP address. Tenant databases If you are adding a tenant database in a tenant database system, specify the FQDN of the system host.
Instance	Instance number of the system
Mode	Whether the system you are connecting to is a single-container system or multiple-container system If you are connecting to a system with tenant databases, then you must further specify the specific database that you want to connect to: The system database A tenant database

• 3: Choose the authentication type for user logon to the database:
• 4: Choose Finish.

Note: 

1. The system is added in the Systems view. The system entry displays the following information:

   • SID

     In the case of a multitenant database container, the database name is indicated before the SID, either SYSTEMDB@<SID> or <database>@<SID>

   • Connected user
   • System usage if it is a production system
   • System or database description if available

   Information about system availability and user connection status are indicated by icons.

You can now access the system or database in the SAP HANA studio.

HANA Studio administration Guide 

https://help.sap.com/docs/SAP_HANA_PLATFORM/f157e7b47b2a417a99eadd4b6c433b77/608b7dbfcc824b68a0a25b8644282195.html