Integrating Applications Manager DB with Grafana

Integrating Applications Manager DB with Grafana

Grafana is an open-source data visualization tool that collects data across multiple software platforms and retrieves them altogether in a single dashboard. It provides advanced analytics by connecting to various data sources in different platforms, collects data and visualizes them in the form of charts, graphs, alerts, etc., providing better visibility and transparency.

By integrating Applications Manager DB with Grafana, you can visualize the data stored in the backend database of Applications Manager and obtain advanced analytics. Follow the steps given below to integrate Applications Manager backend DB:

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.

Step 11: Click on Save button on the top right corner menu, provide a name to dashboard and save it.

Upon completing the above steps, you will be able to visualize the Applications Manager backend DB performance in Grafana dashboard.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Discrepancy with Oracle DB Tablespace information shown in Applications Manager

                      By default, Oracle DB Tablespace statistics is calculated along with its auto-extensible size in Applications Manager. If you want to calculate Tablespace statistics without considering the Auto Extend option, navigate to Settings -> Performance ...
                    • Integrating PagerDuty with Applications Manager using Webhook

                      Using Webhook, you can now integrate PagerDuty with Applications Manager and receive real-time alerts on incidents right into your PagerDuty instance.  Step 1: Configuring PagerDuty Open the required PagerDuty instance to which Applications Manager ...
                    • Installing Applications Manager in AWS

                      Applications Manager can be installed in EC2 instances in both Windows and Linux platforms.  Applications Manager comes with bundled PostgreSQL. Installing Applications Manager in EC2 for Windows Go to EC2 console and launch an "Windows" instance ...
                    • Integrating Telegram with Applications Manager using Webhook

                      Telegram is a cloud-based instant messaging, video telephony and VoIP service with end-to-end encryption. Users can send messages and exchange photos, videos, stickers, audio and files of any type in Telegram. Using Webhook, you can now integrate ...
                    • Installing Applications Manager in Microsoft Azure

                      Applications manager can be installed in Azure Virtual Machines in both Windows and Linux platforms.  Applications Manager comes with bundled PostgreSQL. Installing Applications Manager in VM for Windows Go to Virtual Machines and create a "Windows" ...