Configuring the Database

  1. If not already running, select File Reporter OES Config Dashboard in the Start menu.

  2. Click Configure Database.

  3. Review what is to be configured and click Next.

  4. Establish the settings required to communicate with the database.

    1. Database Properties: Displays the database name and version.

    2. Type: Select either PostgreSQL or SQL Server.

    3. Communication: Specifies the database address, port number, and name.

    4. Database Host Address: Specify the host address of the server on which the database is installed.

    5. Port: Enter the database port. The default setting is either 5432 (for PostgreSQL) or 1433 (for SQL Server).

    6. Initial Database: The default name of the File Reporter OES database.

    7. Database Service User: Specify the database account name used by File Reporter OES to manage data in the database. This account has both read and write access to the database.

    8. Set Password: Establish the password for the Database Service User.

      NOTE: Retain the user and password information as it will be required during component configuration.

    9. Database Report User: Specify the database account name used by File Reporter OES to read data in the database while reporting.

    10. Set Password: Establish the password for the Database Report User.

    11. Database Report Role: Specify the account name of the role used to manage access for Report Users.

    12. Database Administrator: Specify either the superuser name (for PostgreSQL), or the administrator name (for SQL Server).

    13. Password: Specify either the superuser password (for PostgreSQL), or the administrator password (for SQL Server).

    14. Test Credentials: Click to confirm that the entries in the Database Service Accounts region are accurate before advancing in the wizard.

  5. Complete the fields and click Next.

  6. (Optional) Click Enable CLR.

    The following page appears if you use a Microsoft SQL Server database, indicating that File Reporter OES will add custom extensions for SQL Server that help File Reporter OES with advanced reporting queries.

  7. Click Extend Schema.

  8. Review the configuration log and click Finish.

  9. (Conditional) See Installing or Updating the License for next steps.