POWER BI Integration
Inorder to connect with Power BI to servicedesk plus, please follow the steps given below
1. Download Power BI and install it
2. Open the application and choose getData option
3. From the given options, choose the appropriate database MSSQL or ODBC (for postgres)
MSSQL
1. For MSSQL, give the sql server database details and click ok
2. Now give the credentials by choosing the appropriate domain (Windows, Database or Microsoft account credentials according to the customer's environment)
3. If the Database is not encrypted, then the following pop up appears and it is safe to give ok for the same.
4. If the connection is successful, then the navigator page will be shown from which the tables can be chosen.
POSTGRES
For Postgres, please download and install ODBC driver from https://www.postgresql.org/ftp/odbc/versions/msi/ (Please match the machine OS and architecture to download it). You can check the ODBC driver by opening the ODBC datasource administrator and navigating to System DSN as shown in the picture given below.
1. In Power BI, choose ODBC option from the getData dialogue.
2. Choose "NONE" in the Data Source Name and choose the advanced options. In the connection string, provide the driver,server,port and database name in the following format
EG: Driver=PostgreSQL ANSI(x64);server=127.0.0.1;port=65432;Database=servicedesk;
Be sure that Servicedesk Plus is running in the localhost. If it is running in some other machine, then check the IP address of the machine and use it in the server parameter.
In case remote access is required please refer : https://pitstop.manageengine.com/portal/en/kb/articles/postgres-remote-read-only-access
In case remote access is required please refer : https://pitstop.manageengine.com/portal/en/kb/articles/postgres-remote-read-only-access
3. On clicking OK, the Navigator page will open with the tables listed from the connected Database.
New to ADSelfService Plus?
Related Articles
Slack Integration
This is a sample python script that is used to post request details from ServiceDesk Plus into Slack.Slack is a cloud-based team collaboration tool that allows team members to communicate without the use of emails or group SMS. Use Case: Lets assume ...Azure DevOps Integration
Feature: Azure DevOps Integration <--> ServiceDeskPlus (Plugin Model) --> Create a new work-item in Azure DevOps when a request is created in SDP --> Update SDP request status when a Azure DevOps work-item status is updated --> Updating Comments ...Creating Integration Key
For builds after 11300, Steps to create Integration Key: Goto Admin > Integrations > Integration Key > New Please use an integration key with admin privilege, as there wont be any role related permission issues. Click Generate link under the ...Microsoft SCCM Integration for ServiceDesk Plus and AssetExplorer
Microsoft System Center Configuration Manager (SCCM) integration helps you fetch workstation details from SCCM and add them to ServiceDesk Plus or AssetExplorer. How does it work? The SCCM integration tool connects directly to the SCCM SQL ...Opmanager Integration - Create downtime schedule in Opmanager from a change request in ServiceDesk Plus.
This script will invoke the OPManger API to set downtime of assets using the schedule time and the assets / business views chosen in a change request on ServiceDesk Plus. Execution steps: 1. Download and copy the script and xml file into the ...