Configuring a PostgreSQL report services deployment

Follow these instructions if you're creating a new report services deployment using PostgreSQL or reconfiguring an existing PostgreSQL report services deployment.

To configure report services with a PostgreSQL database:

  1. If you need to start the Centrify Report Services configuration wizard, go to the Start menu > All Programs > Centrify Infrastructure Services 2020 > Report Services, and choose Configuration Wizard.

    If you’re continuing from the Centrify Management Services installer, the installer started the configuration wizard for you.

  2. On the Welcome screen, click Next to continue.

  3. If you have already set up report services, the Reconfiguring Report Services screen displays. Select Reconfigure and click Next to continue.
  4. On the Database Type screen, select PostgreSQL and click Next to continue.
  5. On the PostgreSQL screen, specify to create a new PostgreSQL installation or use an existing one.

    Because PostgreSQL doesn't have instances the way other databases do, Centrify recommends that you use an existing PostgreSQL database, if you already have one set up.

    For existing PostgreSQL installations, go to Step 8. Otherwise, for new installations, continue to Step 6.

  6. To install a new PostgreSQL server, specify the PostgreSQL installer file location. You must specify a PostgreSQL installer version 11 or later. You can find the installer file in Common\PostgreSQL.

    Click Next to continue.

  7. Specify the location of the PostgreSQL ODBC driver installer file. Centrify includes this file with the report services installer in Common\PostgreSQL.

    If you already have the official PostgreSQL ODBC drivers installed, this screen doesn't display.

    Click Next to continue.

  8. Specify the PostgreSQL database settings:

    • ODBC Driver: For the PostgreSQL version that comes with report services, keep the default setting of PostgreSQL Unicode. This field can't be changed for new installations.
    • Server: If you're using an existing PostgreSQL server, enter the server name. For example, localhost or servername.acme.com.
    • Port: If you don't enter a port number, report services uses the default port 5432.
    • Database: This is the database name. The name can be up to 63 characters long, and the name cannot begin with an underscore (_) or dollar sign ($), and the instance name cannot contain any of the following special characters: a blank space, backslash (\), comma (,), colon (:), semi-colon (;), single quotation mark ('), ampersand (&), hyphen (-), number sign (#), or at sign (@).
    • Database User: This is your PostgreSQL administrator user. If you're using an existing PostgreSQL installation, the user must have the Create Database permission.
    • Password: This is the password for your PostgreSQL administrator user. If you're using an existing PostgreSQL installation, this is the password for the user with the Create Database permission.
    • Confirm Password: If you're creating a new installation, enter your password again to ensure the password is correct.
    • Additional Parameters: Enter as needed. If you need to enter multiple characters, separate them with a colon (:).

      Note:   The Configuration wizard verifies these settings after you've continued through all the configuration screens. Also, if you haven't installed the PostgreSQL ODBC driver, the Configuration wizard cannot verify these database settings.

  9. If you selected domain-based reporting:
    1. In the Monitored Domain(s) screen, you can review and edit the list of domains that will be included for reporting. Add or remove domains as desired.

      For each domain, the configuration wizard lists the domain name and the domain controller name.

    2. Click Next to continue.

  10. If you selected zone-based reporting and you use hierarchical zones:

    1. If you want data from all zones, select Monitor all hierarchical zones from forest(s). You can add or edit forests by clicking Edit and then adding or removing forests.
    2. Or, if you want to report data from specific zones, select Monitor only specific hierarchical zones.
    3. Click Edit.

      The Specify Forest for zone selection dialog box opens.

    4. Enter the forest name where the desired zones are and click OK.

      The Edit Monitored Hierarchical Zones dialog box opens.

    5. Enter the hierarchical zones by name, or expand the list of zones to locate the desired zones manually.
    6. If desired, specify to select the parent or child zones automatically.
    7. Select the zone by putting a checkmark in the box next to the zone name.
    8. When you’re done specifying which hierarchical zones to monitor, click OK to close the dialog box and return to the Configuration wizard.

      Each zone that you’ve selected is listed in the Hierarchical Zones screen.

    9. Click Next to continue.

  11. If you selected zone-based reporting and you use classic zones:

    1. If you want data from all zones, select Monitor all classic zones from forest(s). You can add or edit forests by clicking Edit and then adding or removing forests.
    2. Or, if you want to report data from specific zones, select Monitor only specific classic zones.
    3. Click Edit.

      The Specify Forest for zone selection dialog box opens.

    4. Enter the forest name where the desired zones are and click OK.

      The Edit Monitored Classic Zones dialog box opens.

    5. Select the classic zones to include in your reports. Select the zone by putting a checkmark in the box next to the zone name.

      You can filter the list of zones by entering a portion of the name and clicking Filter.

    6. When you’re done specifying which classic zones to monitor, click OK to close the dialog box and return to the wizard. Click Next to continue.

  12. For zone-based reporting, you can also specify which domain controller(s) that the report service connects to.

    If you don’t specify which domain controller(s) to use, report services will use the default domain controller.

    1. Click Add.

      The Add Domain Controller dialog box opens.

    2. Enter the domain name and then select the domain controller from the list.
    3. Click OK to return to the Configuration wizard.

      The domain controllers that you selected are listed in the wizard screen.

    4. Click Next to continue.

  13. In the Synchronization schedule screen, specify how often you want the reporting service to pull data from Active Directory.

    You can specify that the service synchronizes weekly, daily, every certain number of days, or every certain number of hours. The limit is 32,767 days or weeks.

    Click Next to continue.

  14. Configure the user account that runs the service:

    1. In the Report Services options screen, specify the user account that will be used to run the service that synchronizes data from Active Directory and the reporting database.

      You can select a network service account, a managed service account, or another user account in Active Directory.

      You must specify a user account that has the required permissions. The configuration wizard verifies that the user has the correct level of access.

    2. Click Next to continue.
    3. The configuration wizard verifies that the specified user account has the required permission. An error displays if the permissions are inadequate.
    4. If the permission verification is successful, click Close to close the Verify permission window.

  15. Review and complete the installation:

    1. In the Summary screen, review the installation details. If the installation settings are correct, click Next to continue.

      If you’re installing a new database, it may take a few minutes.

    2. (Optional) In the completion screen, if the installation is successful, you can select the option to synchronize Active Directory data with the report database immediately. Depending on the Active Directory configuration and domain size, this operation can take awhile to complete.

      Or, alternatively, you can run the synchronization at a more convenient time, using the Report Services Control Panel.

    3. Click Finish to close the configuration wizard.

      If the configuration was not successful, the configuration wizard provides some notes as to why the configuration failed. The notes may or may not include knowledge base articles that are available at the Centrify Technical Support web site.

Note:   Centrify Report Services does not include a reporting solution for use with PostgreSQL.