Connect to Analytics Plus database

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

                      • 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 ...
                      • 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 ...
                      • 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 ...
                      • Unable to integrate ServiceDesk Plus with Analytics Plus after applying SSL

                        Note: This problem occurs only with self signed certificates in Analytics Plus. Issue: [10:23:16:526]|[09-05-2016]|[SYSERR]|[INFO]|[68]|: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: ...
                      • 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 ...