I'm new to Prometheus and have gone through the documentation not clear on couple of things related to collecting metrics:
1. How do I scrape metrics from Splunk logs?
Context: All application logs are sent to Splunk. You have the visibility of how the application is functioning based on the logs. Is there a way to easily scrape for interested log events related to Business use case and build metrics and transfer to Prometheus?
2. How do I scrape custom database tables on both MySQL & Oracle?
Context: Is there a way we can build custom metrics based on user defined DB tables?
Example, say we have a user master table. And say, there are 1K accounts created in a day, is there a way we can scrape number of user accounts created each hour?
I understand, we could scrape a Counter based on user create api end point. We are trying to compare results from Rest api vs. What is stored in DB?
And lastly, I see most of the documentation is focused on Application performance metrics. Is there any documentation available related to Business KPI's, etc?
Thanks!