Search This Blog

Friday, April 19, 2013

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.

1 comment:

  1. Can the option connectting SSLbeautomated and centrally configure for all users or does this have to be doneby each user locally on their machine?

    ReplyDelete