How to Discover SAP HANA Database

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:

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Prerequisite - Set up protocol credentials

Configure the Shell protocol credential.

For credential information, see Supported Protocols.

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.

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.

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:

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.

Run the discovery

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

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

Or activate the following jobs in the listed order:

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