Panel | |
---|---|
|
...
Universal Data Mover Gateway can use a database space of an existing database or you can install a database specifically for the Controller.
We recommend an initial size of 100MB.
Database Permissions
In order to install Universal Data Mover Gateway, the database user configured for the UDMG Server will require DDL (Data Definition Language) permission in the database during the install and during the migration steps for release upgrade.
...
Database Management Systems
The following database management systems are supported:
PostgreSQL | 12, 13, 14, 15 |
---|---|
MySQL | 8.0.x |
Oracle | 19c, 21c |
Microsoft SQL Server | 2019, 2022 |
...
Once the database user is ready, the database parameters can be setup in UDMG Server configuration. The database content is initialized on the first execution and further maintained during release upgrades (see the "Upgrading UDMG Server" in the Linux and Windows installation guides)
PostgreSQL
Note | ||
---|---|---|
| ||
PostgreSQL versions 12, 13, 14 and 15 are supported. |
PostgreSQL for Linux
Create a blank database on the server. An already existing database can be used, but this is not recommended.
Add a user that will be used as the owner of the related tables but also to authenticate with the server.
In order to install or perform upgrades, this database user will require DDL (Data Definition Language) permission in the database during the installation or upgrade.
Once the installation or upgrade has been completed successfully, the configured database user requires only DML (Data Manipulation Language) permissions.
...
Install a PostgreSQL database server.
Once the installation is complete, initialize the PostgreSQL database.
Enable and start the PostgreSQL Server:
Panel |
---|
|
- Create a user for UDMG Server
...
- Finally change the
pg_hba.conf
, to allow database connection with password. For example, for a system where the database server is on the same host as the UDMG server, by changing this line from:
Panel |
---|
|
to:
Panel |
---|
|
The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.
...
For example, for a system where the database server is on the same host as the UDMG server, by changing this line from:
Panel |
---|
|
to:
Panel |
---|
|
For a system where the database server is on the same subnet as the UDMG server, change it to:
Panel |
---|
|
The exact configuration depends on the OS and database version, on the preferred security settings, and on the system architecture.
The location of the pg_hba.conf
can be returned by PostgreSQL Console (psql):
Panel |
---|
|
The current password encryption method can be returned by PostgreSQL Console (psql):
Panel |
---|
|
MySQL
Note | ||
---|---|---|
| ||
MySQL versions 8.0.x are supported. |
MySQL for Linux
Step 1 | Download MySQL installation instructions. | ||
---|---|---|---|
Step 2 | Download the installation package from the official MySQL site.
| ||
Step 3 | Install MySQL as per the instructions.
| ||
Step 4 | Create a blank database on the server. An already existing database can be used, but this is not recommended.
| ||
Step 5 | Add a user that will be used as the owner of the tables but also to authenticate with the server.
|
MySQL for Windows
Step 1 | Download MySQL installation instructions. | ||
---|---|---|---|
Step 2 | Download the installation package from the official MySQL site.
| ||
Step 3 | Install MySQL as per the instructions. | ||
Step 4 | Create a blank database on the server. An already existing database can be used, but this is not recommended.
| ||
Step 5 | Add a user that will be used as the owner of the tables but also to authenticate with the server.
|
...
Step 1 | Download and install Oracle Database Server software as per the Oracle documentation. | ||
---|---|---|---|
Step 2 | Create the UDMG database. You can use any legal name, but we recommend the name udmg. | ||
Step 3 | Create the user that will be used as the owner of the tables but also to authenticate with the server.
Make a note of the user and password to be used later when installing the UDMG Server. | ||
Step 4 | Download and install Oracle Client on the node where UDMG Server will be installed. Detailed installation procedure can be found on the Oracle documentation:
As an example, the installation on a RHEL Linux system would be
|
...
Microsoft SQL Server
Note | ||
---|---|---|
| ||
Microsoft SQL Server versions 2019, and 2022 are supported. |
Step 1 | Download and install MS SQL Server as per the Microsoft documentation. | ||
---|---|---|---|
Step 2 | Create the UDMG database and the application user. You can use any legal name, but we recommend the names udmg and udmg_user.
| ||
Step 3 | Configure the application user with the needed privileges for maintaining the database objects.
| ||
Step 4 | Make a note of the userid and password to be used later when installing the UDMG Server. |
...