Hi everyone,
I’ve been working on a small integration project that connects SAP HANA system logs with the Frappe framework for real-time visibility into database performance metrics. The goal is to surface key SAP database events, like lock waits, expensive statements, and memory alerts, directly in a Frappe dashboard for operational monitoring.
The setup works well in theory, but I’m facing a challenge with the frequency and reliability of log updates. The API-based connection between HANA and Frappe occasionally drops when transaction volumes are high, which causes data delays or incomplete records in the dashboard. I’ve tried adjusting batch sizes and API intervals, but it hasn’t stabilized fully.
I came across some similar use cases while preparing for the SAP C_DBADM_2404 certification, especially around database performance optimization and monitoring strategies. That’s what gave me the idea to build this integration in the first place.
Has anyone here experimented with Frappe as a monitoring front-end for external systems like SAP HANA or other enterprise databases? I’d appreciate any advice on improving the reliability of data syncs or handling API timeouts efficiently within Frappe’s job queue.
For reference, I’ve been studying through Pass4Future practice materials, which helped me understand the underlying SAP HANA admin principles before building this. Now I’m trying to connect that theory to a real-world use case.
Thanks in advance for any insights or approaches that might help improve this setup.