The hdbuserstore (hana secure user store) is a tool which comes as an executable with the SAP Hana Client package.
This secure user store allows you to store SAP HANA connection information, including user passwords, securely on clients. With the help of secure store, the client applications can connect to SAP HANA without the user having to enter host name or logon credentials. You can also use the secure store to configure failover support for application servers in a 3-tier scenario (for example, SAP Business Warehouse) by storing a list of all the hosts that the application server can connect to.
To access the system using secure store, there are two connect options: (1)key and (2)virtualHostName. key is the hdbuserstore key that you use to connect to SAP HANA, while virtualHostName specifies the virtual host name.
This option allows you to change where the hdbuserstore searches for the data and key files.
Note: The secure user store can only be used for SQLDBC and JDBC-based connections. As SAP HANA studio is based on eclipse, it uses the Eclipse secure storage instead of hdb secure store.
LOCATION OF HDBUSERSTORE PROGRAM:
%SystemDrive%\Program Files\sap\hdbclient (Microsoft Windows)