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.