Creating a New Instance for a SAP HANA Pseudo-Client

You can create additional instances for a SAP HANA pseudo-client.

You can connect to the database by using the SAP HANA user store, or a database user.

Note

If you use a non SYSTEM user to connect to the database (New SAP HANA Instance dialog box, General tab, DB User Name box), then the user must have DBA COCKPIT privileges so that it can perform backup operations. For more information, go to the SAP Documentation site, DBA Cockpit for SAP HANA: Authorizations. In the Database Users section, look at the Customer-specific user row.

You can create a SAP HANA database user that has the required privileges by using the following SQL commands:

CREATE USER MY_BACKUP_USER PASSWORD BackupOnly01 NO FORCE_FIRST_PASSWORD_CHANGE; 
 GRANT BACKUP ADMIN, CATALOG READ, INIFILE ADMIN TO MY_BACKUP_USER;

Where:

MY_BACKUP_USER is the user name and BackupOnly1 is the password.

Important

If you have Commvault Service Pack 10 or earlier and you have a multinode SAP HANA database, then you must set the first node to a node that can successfully run hbdsql commands.

Before You Begin

Decide how to connect to the database. If you want to use the SAP HANA user store, create a key.

For information, go to the SAP website, hdbuserstore.
Determine the location of the SAP HANA hdbsql tools.
1. Log in to the SAP HANA server with the sid admin credentials.
2. On the command line, type the following command to find the location.
```
which hdbsql
```
  Use the location that the software returns in the hdbsql location directory box.
If the HANA environment uses a secured socket layer (SSL) connection, obtain the name of the SSL provider and the SSL trust store file that stores the CA-signed certificates.

Procedure

From the CommCell Browser, right-click Client Computers > pseudo-client > instance, and then click New SAP HANA Instance.

The New SAP HANA Instance dialog box appears.
On the General tab, specify the connection details.
- In the Instance Name box, type the SAP HANA instance name.
- In the SID box, type the name of the SAP HANA database SID.
- In the Number box, type the SAP HANA instance number.
- In the OS User Name box, enter the admin user name.
- Determine how to connect to the SAP HANA database:
  
  To use the SAP hdbuserstore key, select hdbuserstore KEY and in the box, type the hdbuserstore key that you created.
  
  To use the database credentials, select the DB User Name box and then type the credentials that you use to access the SAP HANA database.
- In the hdbsql location directory, enter directory that contains the SAP HANA hdbsql tools.
- To authenticate HANA environments that use an SSL connection, select the Enable SSL check box, and then provide the following details:
  - In the Service provider box, enter the service provider that is used for the SSL connection.
    
    For example, enter commoncrpto.
  - In the SSL trust store box, enter the trust store name for the SSL connection.
    
    For example, enter sapcli.pse.
On the Details tab, add the SAP HANA instances.
1. Click Add.
  
  The Create SAP Hana client dialog box appears.
2. From the Hana physical client Name list, select the client that hosts the SAP HANA instance.
3. Click OK.
On the Storage Device tab:
- On the Command Line Backup tab, from the Storage Policy used for user command backup of data list, select the storage policy to use for command line backups.
- To select a log storage policy, on the Log Backup tab, select a policy from the Storage Policy used for all Archive log backups list.
Click OK.

Result

The software performs a validation check on the instance to verify that it can connect to the instance. If the software cannot establish connectivity, then an error dialog box appears and you must verify and up the connection detail values, and then save the instance.

A default subclient is automatically added to the instance. When you add a storage policy to the default subclient, if the storage policy is associated with a server backup plan, then after saving the subclient, the plan is also associated with the default subclient.