Document toolboxDocument toolbox

(12.04.120) How to Set Up a Data Source in the IGEL UMS Administrator

Owned by Harald Saller
Jul 23, 2024
3 min read

Menu path: UMS Administrator > Datasource

The following article details how to configure the IGEL Universal Management Suite (UMS) data source.

The IGEL UMS supports the following data source types:

  • Embedded DB (installed via the IGEL UMS)

  • Microsoft SQL Server

  • Oracle

  • PostgreSQL

  • Apache Derby

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.

For information on the external database systems, see also Connecting External Database Systems.

Default path to the UMS Administrator:

Linux: /opt/IGEL/RemoteManager/RMAdmin.sh
Windows: C:\Program Files\IGEL\RemoteManager\rmadmin\RMAdmin.exe

The IGEL UMS Administrator application can only be started on the UMS Server.



How to Add the Database Connection in the IGEL UMS Administrator

To set up a data source, proceed as follows:

  1. Go to UMS Administrator > Datasource and click Add to add a first data source or an additional one.



    A dialog window New Datasource will open.

     

  2. Select the DB type, and enter the Host, and the Port, as well as the User that is set up on the DBMS. For SQL Server Cluster and Oracle RAC, specify the Instance.

Provided that a data source has not been enabled, these settings can still be changed by selecting Edit. The active data source is protected against changes to its configuration. By selecting Change Password, you can set a new password for the database user. This is also possible when a data source is active.

 

  1. Click on Test to test the connection to the database.
    This is also possible when a data source is inactive.

  2. If required, activate the data source. See Activating a Data Source.