How to Discover SAP HANA Database

This section includes:

How to Discover SAP HANA Database by Shell

This section describes how to discover the topology of SAP HANA Database by Shell.

This task includes the following steps:

1. Prerequisite - Set up protocol credentials

   Configure the Shell protocol credential.

   For credential information, see Supported Protocols.

2. Run the hdbsql command line tool

   Shell-based HANA discovery uses the hdbsql command line tool to execute SQL queries. The following paths are searched:

   • <installation_path>/hdbclient/hdbsql
   • /usr/sap/hdbclient/hdbsql
   • /usr/sap/<db_sid>/hdbclient/hdbsql
   • /usr/sap/<db_sid>/exe/linuxx86_64/hdb/hdbsql
   • /usr/sap/<db_sid>/SYS/global/hdbclient/hdbsql
   • /sapmnt/<db_sid>/hdbclient/hdbsql
   • /sapmnt/<db_sid>/global/hdbclient/hdbsql

   where <db_sid> is the SID of the HANA database.

   If the tool is not available in any of those paths, then its presence is checked in the PATH variable. Otherwise, the discovery process throws a NoHdbsqlException and stops discovery for the current HANA database.

3. Configure the HDB User Store

   To perform shallow or deep discovery, you must properly configure the HDB user store for the destination being discovered. The current discovery mechanism uses cmdb<db_sid> HDB User Storename, where <db_sid> is the SID of the HANA database.

   Note  

   • The hdbsql tool requires a valid HDB user store entry to be specified with the -U option.

   • The HDB user store needs to be created under the same account as that of the protocol credential used by the Host Resources by Shell and HanaDb by Shell jobs.

4. Run the discovery

   Activate the following jobs:

   • Run the Range IPs by ICMP job to discover which of the machines in the IP range are up.

     To perform a shallow discovery where the basic topology is discovered (HanaDatabase, HanaInstance, and IpServiceEndpoint CITs), execute only the following two jobs and do not proceed to the following step:

     • Run the Host Connection by Shell job to discover a host's connectivity by shell protocol to HANA servers.
     • Run the Host Applications by Shell job to discover a HANA database, its instances, and the instance's IP service endpoints.
   • To perform a deep discovery, also run the HanaDb by Shell job to discover the topology of the target HANA Database. This job also discovers all HANA Database resources (schemas, database users, and configuration files) and HANA instances resources (data, trace files, and log files).

How to Discover SAP HANA Database by SQL

This section describes how to discover the topology of SAP HANA Database by SQL.

This task includes the following steps:

1. Prerequisite - Set up protocol credentials

   This discovery uses the Generic DB protocol (SQL).

   For credential information, see Supported Protocols.

   Copy the ngdbc.jar file to the following Data Flow Probe resource folder: <DataFlowProbe install folder>\runtime\probeManager\discoveryResources\db\hanadb.

2. Run the discovery

   If the instance name is configured in the protocol credentials, activate the following jobs in the listed order:

   1. Range IPs by ICMP
   2. Databases TCP Ports
   3. DNS Resolver - Run this job only when you select SSL as the Encryption Method in Generic DB Protocol (SQL)
   4. HanaDb Connection by SQL
   5. HanaDb Topology by SQL

   If the instance name is not configured in the protocol credentials, activate the following jobs in the listed order:

   1. Range IPs by ICMP
   2. Host Connection by Shell
   3. Host Applications by Shell
   4. DNS Resolver - Run this job only when you select SSL as the Encryption Method in Generic DB Protocol (SQL)
   5. HanaDb Connection by SQL
   6. HanaDb Topology by SQL