Chat now with support
Chat with Support

Identity Manager 8.2.1 - Operational Guide

About this guide Simulating data changes in the Manager Scheduling operations activation times Re-applying templates Exporting data with the Manager Analyzing data and data changes Analyzing process monitoring in the Manager Schedules in One Identity Manager Mail templates in One Identity Manager Password policies in One Identity Manager Working with change labels Checking data consistency Compiling a One Identity Manager database Transporting custom changes Importing data with the Data Import Importing and exporting individual files for the software update Creating a One Identity Manager database for test or development from a database backup Initializing DBQueue Processor the after extending the server hardware Command line programs

Exporting files from a One Identity Manager database

To export files from a One Identity Manager database

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. In the Change & Extend view, select the Import files for software update entry and click Start.

    This starts the Software Loader program.

  3. On the home page, select Export from database.

  4. On the Connect to database page, check the One Identity Manager database connection data and change if necessary.

  5. Specify which data to export on the Select files page.

    1. Specify the destination directory to export the file to.

      The Files tab displays the exported files with their status and file size.

      Table 50: Meaning of the status
      State Meaning

      Unknown file

      The file is not yet exported from the database to the given directory.

      Version OK

      The file version matches the version in the database.

      Version modified

      The file version has changed with respect to the version in the database.

    2. Mark the files to export.

      • To export all the file of a machine role, select the machine role on the Machine role tab.

      • To select single files, select the files on the Files tab.

        TIP:

        • Click a column in the table header to order the display by the selected column.

        • Use Shift + select or Ctrl + select to select multiple files.

  6. The marked files are export to the given directory. This may take some time depending on the number of files selected. The export steps are displayed on the page Uploading files. Any export errors are displayed. After exporting is complete, click Next.

  7. To end the program, click Finish on the last page.

Related topics

Creating a One Identity Manager database for test or development from a database backup

NOTE: Additional steps are required if you work with granular permissions concepts at SQL level. In this case, contact support. To access the Support Portal, go to https://support.oneidentity.com/identity-manager/.

To create a test or development database from a database backup from another system

  1. Create a new database on the database server in the reference environment.

  2. Create a database backup of the original database.

  3. Restore the backup to the reference database.

  4. Restore permissions for the database user on the database server.

  5. Compile the database with the Database Compiler.

    Use the Database Compiler to customize connection data for the database and compile all the scripts and processes in the database.

    1. Start the Launchpad and log in to the One Identity Manager database.

    2. In the Change & Extend pane, select the Compile database item.

      This starts the Database Compiler.

    3. On the Database Compiler start page, click Next.

    4. On the Connect to database page, enter the connection data for the One Identity Manager database.

    5. This verifies the database ID. If, during the verification, it transpires that the database ID is incorrect, you will be prompted to create a new ID. Confirm this prompt with OK. The database ID is changed.

    6. On the Database connection information insufficient page, check the database connection data and change if necessary.

      • Test the connection parameters (ConnectionString)

        Change the entry using the [...] button beside the input field. Select your database connection data.

      • Test the full customer name.

    7. This test the database connection. Confirm the prompt with OK.

    8. Enter the valid connection data for the One Identity Manager database.

    9. On the Connect to database page, enter the connection data for the One Identity Manager database.

    10. The components to be compiled are displayed on the Compilation settings page. To start compiling, click Next.

      This starts the compilation process. The process may take some time.

    11. The results of the compilation process are shown on the Compilation page. Click Next after compilation is complete.

    12. Click Finish on the last page to end the program.

  6. In the Designer, adjust the database staging level of the database.

    1. In the Designer, select the Base Data > General > Databases category.

    2. Select the database and change the value of the Staging level property to Test environment or Development system.

    3. Select the Database > Save to database and click Save.

  7. Customize the synchronization project's connection data in the Synchronization Editor.

Initializing DBQueue Processor the after extending the server hardware

After extending the server hardware for the SQL Server, the DBQueue Processor must be initialized again.

To initialize the DBQueue Processor manually

  1. Wait until all DBQueue Processor tasks have completed. You can do this using the Job Queue Info.

  2. Start a suitable program for running SQL queries and perform the following steps one by one.

    IMPORTANT: Select a user that you use for migrating the database to run the SQL queries.

  3. Check whether other database sessions are active.

    select *

    from sys.sysprocesses p

    where dbid = DB_ID()

    and spid <> @@SPID

    If there are still sessions active, they must be closed first.

  4. Stop all DBQueue Processor components.

    exec QBM_PWatchDogPrepare 1

    go

    exec QBM_PDBQueuePrepare 1

    go

  5. Initializing the DBQueue Processor.

    exec QBM_PDBQueuePrepare 0,1

    go

    exec QBM_PWatchDogPrepare

    go

For more information about using the DBQueue Processor, see the One Identity Manager Configuration Guide.

Command line programs

You can use various command line programs for the automation of One Identity Manager implementations.

Detailed information about this topic
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating