PowerConnect for SAP HANA DB Agent Installation
Overview
The PowerConnect Java agent can be installed as a standalone agent on a SAP HANA Database host to monitor operating system metrics (cpu, memory, disk etc.) as well as SAP HANA audit logs and trace logs.
Hardware Requirements
x86 64-bit chip architecture
1 CPU cores at 2GHz or greater
512 MB RAM
A 64-bit Linux distribution
Software Requirements
A 64 bit Linux distribution running SAP HANA
Java 11 (SAPMachine, OpenJDK or Oracle)
Network Requirements
HTTP or HTTPS outbound on port 8088 to connect to the Splunk HTTP Event Collector (Splunk on premises or Splunk Cloud)
Pre-Installation Steps
Login to the SAP HANA database server
Create Installation Folder
Create a directory where the PowerConnect for SAP HANA agent software will be installed
sudo mkdir /opt/powerconnect
The agent should run as the SAP HANA database OS user so it is able to access log files inside the SAP HANA installation folder
Make sure the SAP HANA OS user has full ownership of the PowerConnect directory (in the example below SAP HANA is running as hd5adm and is part of the sapsys group)
sudo chown -R hd5adm:sapsys /opt/powerconnect
Install Java
Install Java 11 (SapMachine, OpenJDK or Oracle)
sudo zypper install java-11-openjdk-devel
Create a database user (for audit logs only)
Create a database user for the PowerConnect (skip this step if you do not want to collect audit logs)
Connect to the HANA database using hdbsql
hdbsql -n localhost:<insert hana port> -i 00 -u SYSTEM
Create a user (for example powerconect)
CREATE USER powerconnect PASSWORD <insert password>;
Grant the user permissions to read the audit logs
GRANT AUDIT READ TO powerconnect;
Connect to the database using the powerconnect user to verify
hdbsql -n localhost:35015 -i 00 -u powerconnect
Download the HANA JDBC Driver
Download the latest SAP HANA Database JDBC Driver - https://tools.hana.ondemand.com/additional/ngdbc-latest.jar
Copy it to the HANA machine for use during the installation
Installation Steps
Obtain the PowerConnect for SAP HANA DB package tarball file from your local distributor
Copy the tarball file to the SAP HANA DB host
scp powerconnect-hana-db-x.tgz <target-server>:/tmp
Login to the target server as the SAP HANA DB OS user
Unpack the package to the PowerConnect folder
tar -zxvf powerconnect-hana-db-x.tgz -C /opt/powerconnect
Switch to the PowerConnect folder
cd /opt/powerconnect
Make sure the java command runs and java is available on the path
java -version

Copy the SAP HANA Database JDBC driver named ngdbc-latest.jar you downloaded to the lib folder
cp /tmp/ngdbc-latest.jar /opt/powerconnect/lib
Make sure start script is executable
chmod +x bin/powerconnect.sh
The agent is now installed, follow the configuration steps to configure the agent