Configuring user monitoring for your RDBMS

Before you start, the RDBMS that you plan to use for user monitoring data must be installed and tested on a server at your site.

If you have already configured User Monitoring and wish to preserve previously captured data, you must export all your data before migrating to another RDBMS. See the information about exporting of User Monitoring data in the Infor Security Services Configuration Guide.

  1. From the main ssoconfig menu, select "Manage Database."
  2. From the sub-menu that appears, select "Configure the Database."
  3. From the next sub-menu, select your "Database Type" from the list:

    At the time of this document's publication, the options are:

    • Oracle 11g or 12c

    • Enterprise DB Postgres Plus Advanced Server 9.4

    • Microsoft SQL Server 2008 or 2012: Select this option for any version of Microsoft SQL Server, including 2014.

  4. At the prompt "Would you like to specify the credentials to use to connect to the database (yes, no)?"

    Specify Yes. You will be prompted to provide credentials in a later step.

  5. At the prompt, "Please Enter Provider Type from the List," select "Specify a User Name and Password."
  6. At the next prompts, specify the following information for the user monitoring database you created in a previous procedure:

    • Database user/role

    • Database password

    • Database name

    • Database host. Supported formats are IP Address and FQDN.

    • Database port (if you are not using the default). If you are using the default port (for Oracle: 1521, for Microsoft SQL Server: 1433, for Enterprise DB Postgres: 5432), you can press Enter to accept it. If you are using a different port, type the port number and then press Enter.

    • Database schema

    A message appears that the database configuration was successful appears.

  7. Exit the ssoconfig utility using the option for Exit.