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
- Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Unica Discover\DataStore\ReportServer.
-
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
- Open the command prompt.
- Navigate to <Discover Install Directory>\Reporting\DatabaseInstaller.
-
Execute the following installer command based on your database: