Adding a SAP HANA Instance to a SAP HANA System

Add a SAP HANA instance.

Before You Begin

1. Determine how to connect to the database. If you want to use the SAP HANA Secure User Store, create a key.

   For information on the SAP Secure User Store, go to the SAP website, hdbuserstore.

2. Make sure that you have the following information about the SAP HANA system:

   • The data storage policy name

   • The log storage policy name

   • The command line storage policy name

   • The admin user name

   • The SAP HANA instance SID

   • The SAP HANA instance number

   • The SAP HANA primary server

   • The SAP HANA worker node

   • The SAP HANA user credentials

   • The SAP HANA user store key

   • The directory that contains the SAP HANA hdbsql tools.

     To determine the location, log in to the SAP HANA server with the sid admin credentials and type the following on the command line:

     which hdbsql

Procedure

1. You can add an instance on server details page or the agent details page. You can edit the SAP HANA instance on the instance details page. Choose one of the options.

   • Server details: From the navigation pane, click Servers > server > agent, in the Actions column for the agent, click the action button , and then click Add instance.

   • Agent details: From the navigation pane, click Servers > server > agent. Then, in the center of the page click Add instance.

   • Instance details: From the navigation pane, click Servers > server > agent > instance. Then, in the upper-right of the page click Edit instance.

     The Add SAP HANA instance dialog box or the Edit SAP HANA instance dialog box appears.

2. On the General tab, provide the connection details.

   1. In the SID box, type the SAP HANA instance SID.

   2. In the Instance number box, type the SAP HANA instance number.

   3. In the HDB SQL Location box, type the directory that contains the SAP HANA hdbsql tools. In the OS username box, type the admin user name.

   4. From the Physical client list, choose the client that hosts the SAP HANA instance.

   5. Determine how to connect to SAP HANA system.

      • To use the SAP HANA Secure User Store, choose HDB User Store Key and then type the SAP HANA Secure User Store key in the box.

      • To use a database user, choose DB Username and then type the SAP HANA database user credentials in the boxes.

3. On the Details tab, from the Select a Database Worker Node list, select the SAP HANA client that is the worker node and then click Add.

4. On the Storage tab, choose the storage policies.

   • From the Data storage policy list, choose the storage policy the software uses for data backups.

   • From the Log storage policy list, choose the storage policy the software uses for log backups.

   • From the Command storage policy list, choose the storage policy the software uses for command line backups.

5. Click Add.