Database support

Network Olympus uses a database to store information.

The following DBMSes are supported:

  • PostgreSQL
  • Microsoft SQL Server
  • MySQL

You can configure the application's access to a database during the installation of Network Olympus.

To setup the connection to an external database, you must provide an account username and password.

PostgreSQL

Comes bundled with Network Olympus.

Suitable in most cases. Installation doesn't require any additional actions from the user.

The Network Olympus installer will prompt you to set the administrator account parameters for the installed database cluster. This data may be needed later if migrating to another database becomes necessary.

The PostgreSQL server uses TCP port 5432. Before installing, make sure that this port is not taken by any other application.

Windows Firewall rules will be created automatically.

Microsoft SQL Server

An ODBC driver is required for a successful installation. It can be downloaded from the official website.

If you plan to install Network Olympus on the same system where the SQL Server is installed, then likely you won't need to install the ODBC driver manually. It usually comes bundled with the Enterprise Edition.

The installer will need the username and password of the account that will be used for database configuration. This account must have the rights for creating the database, authenticating over the TCP connection and configuring the database schema.

MySQL

An ODBC driver is required for a successful installation. It can be downloaded from the official website.
The driver's bitness must match the application bitness.

The installer will need the username and password of the account that will be used for database configuration. This account must have the rights for creating the database, authenticating over the TCP connection (remote authentication is disabled by default) and configuring the database schema.