How to Manage Multiple SAP HANA Systems

You can manage multiple SAP HANA database systems in the SAP HANA studio.

Systems are displayed in the navigator, where they are labeled with their system ID (SID) and description (if one was specified). When you expand a system node in the navigator, you see the default catalog, which contains public synonyms, schemas with column views (info cubes), functions, indexes, procedures, sequences, (private) synonyms, tables, and views.

Adding Systems 

Before you can carry out administrative tasks on an SAP HANA database, you must add it to the navigator. Note that the hostname of the server that hosts the database must be accessible from the client where the SAP HANA studio runs, even if the system is added by means of its IP address.

Prerequisites : All the relevant ports in the firewall should be opened.

Procedure

1. In context menu of the navigator, choose Add System.

Note : You can also import existing systems. More information: Importing Systems

2. Enter the following data:

 . Hostname

Name of the host where the system is installed

 . Instance Number

Instance number of the system

Note : To add a distributed system, you specify the host of one of its index servers (that is, instances). Every index server in a system has information about all the other index servers within the same system.

 . Description

You can enter a description for the system, which is displayed next to the system name in the navigation structure.

 . Folder

If you have already created a system landscape in the navigator, choose the folder to which you want to add the system.

 . Locale

Your location

3. Choose Next.

4. If required, choose your authentication type and enter your user information.

5. If you want to use a secure connection, choose Connect using SSL.

6. To enter advanced connection properties, choose Next. The following options are available:

 . Connection URL: Defines the properties of the connection to the database.

 . Auto-Reconnect: If you select this option, the SAP HANA studio automatically

reconnects after the connection to the system has broken.

7. Choose Validate SSL Certificate to ensure that the SSL connection is secure.

To override the system hostname in the certificate, enter a hostname with a defined certificate.

8. Choose Use user key store as trust store to validate the server certificate's validity (whether signed by a known certificate issuer) using the user key store.

The trust store property configures the trust store for SSL connect, which is used to validate that the SSL certificate of the server is issued by a trusted entity. Each user can to import certificates into his or her own user key store in Java using the "keytool" option (part of JRE).

The set of root certificates delivered with the JRE from well-known issuers (for example, Verisign, Thawte, Deutsche Telekom) is used when this option is not selected.

9. Choose Finish.

Result : The system is added in the navigator.

Note : Systems that you added using a secure connection are shown with a padlock icon.