Connecting to the Reports database

You can connect to the Reports database directly by using psql, an interactive terminal program. After you make the connection, you can use SQL statements to extract or query the data without using a business intelligence tool.
    Note:
  • You do not have to follow this procedure if you use Data Transmitters.

To verify that the Reports database is running, try to connect to it. If you get the psql command prompt, the database is running.

  • To connect to the Reports database installed by RICOH ProcessDirector:
    1. Log in to the primary computer as the system user (aiw1) and open a command line.
    2. Enter the appropriate command below for the container engine to connect to the Reports database:
      • docker exec -it rpd-reports-postgres psql -U username -d database

        or

      • podman exec -it rpd-reports-postgres psql -U username -d database

        Replace database with the name of the database that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is history.

        Replace username with the user name that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is rpdreports.

    3. If prompted, enter the password that you specified in Administration ⇒ Reports ⇒ Database Settings.

      The psql command prompt database=# is displayed. If you specified history as the name of the database in the command, the command prompt is: history=#

      You now are connected to the Reports database.

    4. To access the data, run SQL statements.
    5. To exit psql, enter: \q
  • To connect to the Reports database not installed by RICOH ProcessDirector:
    1. Log in to the server hosting the reports database and open a command line as a user with access to PostgreSQL.
    2. Change directories to the correct option for your system.
      • /usr/pgsql-version/bin/

        Where version is the installed version of PostgreSQL.

    3. Enter this command: ./psql database username

      Replace database with the name of the database that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is history.

      Replace username with the user name that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is rpdreports.

    4. If prompted, enter the password that you specified in Administration ⇒ Reports ⇒ Database Settings.

      The psql command prompt database=# is displayed. If you specified history as the name of the database in the command, the command prompt is: history=#

      You now are connected to the Reports database.

    5. To access the data, run SQL statements.
    6. To exit psql, enter: \q
  • To connect to the Reports database:
    1. Log in to the server hosting the reports database and open a command prompt as a user with access to PostgreSQL.
    2. Change directories to the correct option for your system.
      • C:\aiw\aiw1\bin\postgresql\Windows\pgsql\bin

        or

      • <RPD Install Directory>\PostgreSQL\bin\
    3. Enter this command: ./psql database username

      Replace database with the name of the database that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is history.

      Replace username with the user name that you specified in Administration ⇒ Reports ⇒ Database Settings. The default is rpdreports.

    4. If prompted, enter the password that you specified in Administration ⇒ Reports ⇒ Database Settings.

      The psql command prompt database=# is displayed. If you specified history as the name of the database in the command, the command prompt is: history=#

      You now are connected to the Reports database.

    5. To access the data, run SQL statements.
    6. To exit psql, enter: \q

Related information:

Supplied Tableau workbook
Reports database connection issues
Useful PostgreSQL commands
Parent topic: Working with data in the Reports database