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:
| Field | Value |
|---|---|
| Host name | Name of the host |
| Alias | Host description |
| IP | Host IP Address |
| Monitored from | Monitoring Poller to use |
| Host Multiple Templates | App-DB-Sap-Hana-custom |
Click on the Save button.