Aller au contenu principal

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.