Integration with Power BI
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
3. On clicking OK, the Navigator page will open with the tables listed from the connected Database.
New to ADSelfService Plus?
Related Articles
Jira Integration
Jira Integration JIRA Integrates with ServiceDesk Plus MSP using "Request Custom Menu". Sample Implementation is already done and bundled with our application. You need to change field names as per your requirement in JIRA.xml. So When a ticket is ...CTI Integration internal configuration for testing
Example format for CTI Integration testing ...WhatsApp Integration via Twilio (Notification only)
WhatsApp Integration via Twilio You can now integrate ServiceDesk Plus MSP with WhatsApp to trigger WhatsApp notifications to ServiceDesk Plus MSP technicians/users on the latest events that happen in the application. This can be done through Twilio ...ADMP integration Issues with SDP MSP
Please check the below if you get any errors while doing integration 1) ADMP application must be accessible from the browser of SDP application server. Similarly, SDP application must be accessible from the browser of ADMP application server. This is ...ZOHO assist integration FAQ's
1) ZOHO Assist not working or unable to send emails or exception throws while initiating the session - Users who purchased ZOHO Assist needs to sign up to the https://assist.zoho.com/ with the registered user Email to make the integration work. - ...