Document toolboxDocument toolbox

(12.04.120) Connecting External Database Systems

Owned by Harald Saller
Jul 23, 2024
1 min read

The use of an external database system is recommended in the following cases:

  • You manage a large network of devices.
  • A dedicated database system is already in use in your company.
  • You integrate the High Availability or the Distributed UMS solution.

In other cases, the use of the embedded database is suitable. It is included in the standard UMS installation, see (12.04.120) IGEL UMS Installation under Windows or (12.04.120) IGEL UMS Installation under Linux.

For details on the supported database systems, see the "Supported Environment" section of the release notes. Details of the requirements when installing and operating the database can be found in the documentation for the particular DBMS.

  • To configure the database, use the relevant DBMS management program.
  • To configure the data source and to connect the UMS to the database, use the UMS Administrator > Datasource.

Be aware not to use special characters in your schema name or database user name!

All UMS Servers must work with the same database.

For large High Availability environments, cluster databases are recommended.

For the backup procedure for UMS installations with the external database, see (12.04.120) Creating a Backup of the IGEL UMS.

See also (12.04.120) How to Migrate a UMS Database From Embedded DB to Microsoft SQL Server.