Integrating Applications Manager backend Microsoft SQL database with Power BI Desktop
Overview
This KB provides step-by-step instructions to connect Power BI Desktop to your Applications Manager's Microsoft SQL backend database, enabling you to create custom reports and dashboards using Applications Manager's performance metrics and monitoring data.
Prerequisites
- Power BI Desktop installed on a computer with access to the Applications Manager SQL backend database
- Applications Manager backend Database connection credentials (SQL Server name, database name, username, password) with atleast Read access permissions to the Applications Manager database tables
Steps to Connect Applications Manager SQL Backend to Power BI
- Launch Power BI Desktop on your computer and select the data source as SQL Server
- In the SQL Server database wizard, provide the SQL Server information (Applications Manager SQL database information can be found from: Applications Manager GUI → Settings → Support → Database Backend Details table).
- Select DirectQuery if you want to query live data with real-time dashboard updates
- Expand Advanced options and set Command timeout to 1 minute.
- In the SQL statement field, provide SQL query to fetch required data (Ex: Query to count the number of Critical alerts - SELECT COUNT(*) AS Critical_Alert FROM Alert WHERE GROUPNAME='AppManager' AND SEVERITY=1 ) and Click OK.
PowerBI - Applications Manager SQL Server database details
- Provide the Username and Password required for connecting to the backend SQL Server and Click Connect.
SQL Credentials
- Once successfully connected, you should be able to view the Query result. Please proceed to Load the data and build Visuals as per requirement.
PowerBI Dashboard
Need Help?
If you require any help in preparing the SQL queries to fetch your required data, contact us at appmanager-support@manageengine.com
Related Resources
New to ADSelfService Plus?
Related Articles
Enabling Kerberos Authentication for Applications Manager's MS SQL Backend Database
Follow the steps given below to enable Kerberos authentication for the MS SQL backend database: 1. Stop the Applications Manager service. Open the Applications Manager Home directory in the command prompt and run the commands below one by one. For ...Issues while installing or starting Applications Manager with Microsoft SQL Server backend database
Problem: Unable to install or start Applications Manager using Microsoft SQL Server database as backend. Solution: Follow the below troubleshooting steps to resolve the issue: 1. On the Microsoft SQL server host, go to Start -> All Programs -> ...Maintenance of Applications Manager backend database
Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...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, ...Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables. pg_dump: WARNING: out of shared ...