Integrating Applications Manager DB with Grafana
Step 1: Login to Grafana.
Step 2: Click on Settings icon -> Add data source and search for the keyword 'SQL'.
Step 3: Click on the database server type that is being used by Applications Manager. To find the backend database server used by Applications Manager, go to Settings -> Support -> Check Installation Information box (Database Type key will help us to know the database server used). For example, click on PostgreSQL in Grafana, if you are using bundled PostgreSQL for Applications Manager.
Note: By default, bundled PostgreSQL in Applications manager can be connected only from the Applications Manager installed server
Step 4: Provide the required data to configure data source. Host and Database information can be found by referring the Database Backend Details box under Settings -> Support in Applications Manager. In case of bundled PostgreSQL, use the below credentials:
User name: rouser
Password: Provide the password of rouser
Connection limits
Max Open: 10
Max idle: 2
Max lifetime: 0
PostgreSQL details
Version: 11
Min time interval: 1m
Click on Save & test button.
Step 5: Create a new dashboard using the + button.
Step 6: Click on Add a new panel.
Step 7: Choose the added database server as Data source.
Step 8: Give a name to the query.
Step 9: Click on Edit query icon, add a query to fetch data from Applications Manager DB and choose the data format type.
Step 10: Choose a visualization type to render the data.