Automatic version control is integrated into One Identity Manager, ensuring that One Identity Manager components are always consistent with each other and with the database. If program extensions that change the structure are implemented - for example, table extensions - the database needs to be updated.
You need to update the database if hotfixes and service packs are available for the version of One Identity Manager you are currently running or for complete version updates. In addition, customer-specific changes must be transferred from a development database into the test database and into the production system database.
|
IMPORTANT: Test changes in a test system before you load a transport package in a productive system. |
You can customize the One Identity Manager schema by loading so-called transport packages. One Identity Manager recognizes the following types of transport packages that can be copied to the database depending on requirements.
Table 27: Transport package
Migration package |
Migration packages are provided by for the initial database schema installation, for service pack and complete version updates. A migration package contains all the necessary tables, data types, database procedures, and the default One Identity Manager configuration. |
Configuration Wizard |
Hotfix package |
Hotfix packages are provided to load individual corrections to the default configuration such as templates, scripts, processes, or files into the database.
NOTE: If a hotfix package only contains changed files, load these files into the database using the Software Loader file. |
Database Transporter
Software Loader |
Custom configuration package |
A custom configuration package is used to exchange customer specific changes between the development, test, and productive system database. This transport package is created by the customer and loaded into the database. |
Database Transporter |
NOTE: If, in additional to a hotfix package, there are additional customized configuration settings to be installed in a One Identity Manager database, create a custom configuration package and use the Database Transporter to import it into the target database. There is no support for merging a hotfix package with a custom configuration package into one transport package.
Related topics
IMPORTANT: Test your changes in a test system before you load a migration package in a productive system. Use a copy of the production database for testing.
NOTE: Always start the Configuration Wizard on an administrative workstation!
To update a database
- Start the Configuration Wizard.
- On the Configuration Wizard home page, select the Update database option and click Next.
- On the Select database page, select the database and installation directory.
-
Select the database connection in the Select a database connection pane. Select a user who at least has administrative permissions for the One Identity Manager database.
-
In the Installation source pane, select the directory with the installation files.
-
Configuration modules and version information are shown on the Product description page.
- Select the module you want to update.
- Confirm that you have an up-to-date backup of database.
- Confirm that the database consistency checks were executed.
- Set Add other modules to select other modules.
-
Select the additional module on the Select configuration modules page.
NOTE: This page is only shown if you set Add more modules.
NOTE: If you add more modules, your custom administrative users obtain the permissions for this module.
-
Other users with existing connections to the database are displayed on the Active sessions page.
- Disconnect the connections on order to start database processing.
-
On the Create a new login for administrators page, decide which SQL server login to use for administrative users.
NOTE: This page is only shown when updating a One Identity Manager database with version 7.0.x, 7.1.x or 8.0.x to version 8.1.4.
If you want to switch to granular permissions when you update from 8.1.x at a later date, contact support. To access the Support Portal, go to https://support.oneidentity.com/identity-manager/.
You have the following options:
-
Create new SQL Server logins for the database: Select this option if you want to set up a new administrative login on the SQL Server. Other SQL Server logins with permissions for system configuration and for end users are created after the database has been migrated.
Enter the login name, password, and password confirmation for the new SQL Server login.
-
Use the current SQL Server login for the database: If you select this option, no other SQL server logins are created for the database. In this case, you cannot work with granular permissions concepts at SQL level. The user you specified is used to connect to the database.
-
On the Database check page, errors are displayed that prevent the database from being processed. Correct the errors before you continue updating.
-
The installation steps are shown on the Processing database page. Installation and configuration of the database are automatically carried out by the .
TIP: Set Advanced to obtain detailed information about processing steps and the migration log.
- You must log in as an administrative user to compile the system.
- Enter a user name and password for the administrative system user.
- Click Log in.
- Once processing is complete, click Next.
-
On the Create SQL server logins page, enter the login name, the password, and password confirmation for the SQL Server logins for configuration users and end users.
NOTE: This page is only shown when updating a One Identity Manager database with version 7.0, 7.1 or 8.0 to version 8.1.4.
-
You can configure the vendor notification on the page, Configure vendor notification.
NOTE: This page is only shown of you have not yet enabled vendor notifications.
If vendor notification is enabled, One Identity Manager generates a list of system settings once a month and sends it to One Identity. This list does not contain any personal data. The list will be reviewed by our customer support team, who will look for material changes in a proactive effort to identify potential issues before they materialize on your system. The lists may be used by our R&D staff for analysis, diagnosis, and replication for testing purposes. We will keep and refer to this information for as long as your company remains on support for this product.
-
To use the function, set Enable vendor notification and enter your company's contact email address in Email address for contact.
The email address is used as the sender address for notifying vendors.
- Set Disable vendor notification if you do not want to use this functionality.
- On the last page of the Configuration Wizard, click Finish.
Related topics
The One Identity Manager database is updated automatically by the Configuration Wizard. This procedure may take some time depending on the amount of data and system performance.
The Configuration Wizard performs the following steps:
- Updating the One Identity Manager schema.
Before the schema installation, the Configuration Wizard checks the database. Error messages are displayed in a separate window. The errors must be corrected manually. The schema update cannot be started until these are resolved.
All the tables, data types, and database procedures that are required are loaded into the database by the schema update. When a transport package is imported into a One Identity Manager database, the following operations are carried out.
Table 28: Operations when importing a migration package
Insert |
If the object is not found in the target database, a new object is generated with the key values. |
Refresh |
If the object is found in the target database, the object is updated. |
Delete |
Objects that are no longer needed are deleted. |
During a schema update, calculation tasks are queued in the database. These are processed by the DBQueue Processor.
For a schema update with the Configuration Wizard, the migration date and the migration status are recorded in the transport history of the database.
- Compiling the system.
Scripts, templates, and processes are declared in the database. The System user authentication module with the specified system user is used for compilation.
- Uploading files for automatic software update.
In order to distribute One Identity Manager files using the automatic software updating mechanism, the files are loaded into the One Identity Manager database.
-
Migration of synchronization projects.
A process that migrates all existing synchronization project is queued in the Job queue. This updates the One Identity Manager schema and applies automatic patches.
Related topics