Script that loads dummy data into HanaDB for testing purposes.
This script was written to load dummy test data in a HANA database to test different behaviorial aspects of a HA cluster.
Prerequisites
-
SAP/Hana DB 2-node cluster (SLES4sap). This script was developed and tested on an AZURE sles12.sp4-sap 2-node perf-optimized cluster with SPS05.
-
Access to SAP HANA Database System Administrator account on each node.
-
A SYSTEM DB user account (or equivalent). Although it is not required, you will not be able to use the CSV load feature and will have to use the slower 1 record at a time function.
-
Know which node is primary.
Installation On primary node:
- sudo su - prdadm
- Copy src/*.py ~prdadm/
To Run
python populateHanaDB.py