Installing Discover Database

This procedure is applicable only if Discover was installed without a database or if you need to install an additional database, either Microsoft SQL Server or PostgreSQL. These steps apply only to on premises deployment and must be performed on the Portal Server or Reporting Server.

About this task

If PostgreSQL or Microsoft SQL Server Database is not already installed, perform the following steps to set up a new database for Discover 12.2.2:

Stopping all Discover Services

Procedure

Before starting the installation, ensure that all Discover services are fully stopped.

Adding or Updating Registry Values

Procedure

  1. Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Unica Discover\DataStore\ReportServer.
  2. Configure registry keys based on the Database Type:
    Registry Keys Microsoft SQL Server PostgreSQL
    Host Set to your hostname or IP address Set to your hostname or IP address
    DatabaseType MSSQL POSTGRES
    Port 1433 (or the SQL Server instance port if different) 5432 (default PostgreSQL port; may vary)
    SQL Mode MSSQL POSTGRES
    PostgresUser PostgreSQL superuser (usually postgres)
    PostgresPassword Password of the above user

Running the Database Installer

Procedure

  1. Open the command prompt.
  2. Navigate to <Discover Install Directory>\Reporting\DatabaseInstaller.
  3. Execute the following installer command based on your database:
    1. For PostgreSQL
      DiscoverDatabaseInstaller.exe -xPOSTGRESx -xinstallx
    2. For Microsoft SQL Server
      DiscoverDatabaseInstaller.exe -xmssqlx -xinstallx
      Note:
      • During installation, Search Server and Data Service must be running.
      • The installer will attempt to start these services automatically.
      • If Search Server does not start:
        • Kill the service executable from Task Manager.
        • Start it manually.