Skip to main content

SAP HANA

Prerequisites

Centreon Plugin

Install this plugin on each needed poller:

yum install centreon-plugin-Applications-Databases-Sap-Hana

Sap Hana Client

To monitor Sap Hana DB, you need to install SAP Hana Linux Client. The client is on SAP support website (an account is needed).

yum install unixODBC perl-DBD-ODBC

Configuration of freetds.conf file

The /etc/odbcinst.ini file have to be modified. Add following lines:

[HDBODBC]
Description = "SmartCloudPT HANA"
Driver=/usr/sap/hdbclient/libodbcHDB.so

User account

An user with rights on SYS schema is needed.

Test the connection

An example of command to test database connection:

/usr/sap/hdbclient/hdbsql -n saphanadb\_servername:31041 -d databasename -u username -p password

Centreon Configuration

Create a new host

Go to Configuration > Hosts and click Add. Then, fill the form as shown by the following table:

FieldValue
Host nameName of the host
AliasHost description
IPHost IP Address
Monitored fromMonitoring Poller to use
Host Multiple TemplatesApp-DB-Sap-Hana-custom

Click on the Save button.