Download page How to Set Up a Data Source in the IGEL UMS Administrator.
How to Set Up a Data Source in the IGEL UMS Administrator
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
- 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:
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:
- 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.
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.
If you deploy MS SQL Server Always On Availability Groups, use SQL Server as a DB type and specify under Host the domain name of the Always On Availability Group listener.
As of UMS 6.10.110, you can define additional parameters to be added to the JDBC URL via JDBC Parameter. Currently, only the following parameter is supported:
- Microsoft SQL Server:
sendStringParametersAsUnicode (Default value:
This parameter can be modified to improve the query performance in some cases. See the Microsoft article setSendStringParametersAsUnicode Method (SQLServerDataSource).
- Microsoft SQL Server:
- Click on Test to test the connection to the database.
This is also possible when a data source is inactive.
- If required, activate the data source. See Activating a Data Source.