How to connect to Analytics Plus database
This article will help you with the steps to connect to Analytics Plus database(Postgres)
Note: Analytics Plus is bundled with Postgres and it cannot be changed to any other database due to reliability and chart rendering.
Steps for Windows:
1. Open command prompt and execute the below command
<AnalyticsPlus home>\pgsql\bin>psql.exe -U postgres -p <port number> -h 127.0.0.1
eg:
C:\ManageEngine\AnalyticsPlus\pgsql\bin>psql.exe -U postgres -p 33366 -h 127.0.0.1
Note: The default port number is 33366
2. Enter the password
Note: You can find the password for the database in the following location <Analytics Plus home>\conf\database_params.conf
3. Now, connect to zreportsdbbyexecutingthefollowing command \c zreportsdb
Steps for Linux:
1. In the terminal, execute the following command
<Analytics Plus home>./psql -U postgres -p 33366
2. You will be prompted to enter the password. Please find the password under <Analytics Plus home>\conf\database_params.conf
3. Now type \c zreportsdb to connect to the database
New to ADSelfService Plus?
Related Articles
Analytics Plus Inventory
Aim: To have the detailed list of all the Reports, Databases created in Analytics Open Local & Cloud Databases and fill the entries password = Postgres and if any error occurs stating something like "check the DB connection" change the Port to ...Unable to Connect to the Postgres SQL Database from Command Prompt
Issue : Unable to Connect to the Postgres SQL Database from Command Prompt Error : Analysis : IPv6 local connections are commented in <AnalyticsPlus home>\pgsql\data\pg_hba.conf file Solution : Open the file using notepad or wordpad as administrator ...Move Analytics Plus from one Server/folder
Go to Start --> Services.msc and stop the ManageEngine Analytics Plus service. Take a backup of the entire <Analytics Plus_Home> directory and then move it to the new server. On the new server, navigate to (similar path) <Analytics Plus_Home>\bin ...Steps to enable Google Analytics Connector
1. Stop the Analytics Plus services. 2. Modify the entry under <Analytics Plus home>/reports/conf/app.properties show.create.google.analytics.view=true Note: If the above property is missing, add them. By default the value will be set to 'false' 3. ...Remove the configuration of Analytics Plus from Servicedesk Plus
Under Servicedesk Plus - Advanced Analytics section, Integration UI allows us to re-configure the host, port and username only after performing 'Remove' action. However, if you uninstall or change the host of Analytics Plus application, you can not ...