Chat now with support
Chat with Support

Identity Manager 8.2 - 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

Integrating SQL statements in transport packages

You can integrate SQL statements in the custom configuration package. The SQL statements are run before or after a data import. For example, after a schema extension has been transported a SQL statement may be required for filling initial data in the new columns.

NOTE: To create transport packages with SQL statements, users need the Enables integration of SQL statements in a transport file (Transport_SQL) program function.

To run SQL statements within a transport package

  1. In the Database Transporter, on the Define transport data page, select the export criteria for running SQL expressions. The following export criteria are available:

    • Run SQL statements before data import

    • Run SQL statements after the data import

  2. Create the SQL statement using the Edit button. Differentiate between SQL statements for system data transport and user data transport.

    1. Enter the SQL statement directly.

      - OR -

      Use the button to load a .sql file that contains the statements.

    2. Use the button to save to a file.

Related topics

Exporting favorite objects

Use this transport method to select the modified processes, scripts, reports, and mail templates from a specific timeframe.

To transport favorite objects

  1. In the Database Transporter, on the Define transport data page, select the Transport of favorite objects export criteria.

  2. Click Select to select the single objects for the transport.

    1. In the Object modified in last ... days input field, enter the timeframe for the object selection.

      All objects with a change date and user in the selected timeframe are displayed.

      TIP: To include other processes, scripts, reports, or mail templates in the transport package, use the Load all entry.

    2. Select the object you want and use to add it to the transport package.

      TIP: Use Shift + select or Ctrl + select to select multiple objects in the selection dialog.

      The Objects to transport pane lists all selected objects and their dependencies.

Related topics

Exporting change labels

Several changes to objects or objects properties are grouped together under a change label and can be swapped between source database and target database in this way. When a custom configuration package is imported with change labels, new data records are added to the target database and existing data records are updated. In addition, objects marked for deletion in the change label are deleted from the target database.

NOTE: There are no change labels available after initial schema installation.

To transport by change label

  1. In the Database Transporter, on the Define transport data page, select the Transport by change information export criteria.

  2. Select the change label from the menu.

  3. (Optional) To display the contents of a change label, click Display.

    Objects and changes are displayed, which belong to the change label.

    NOTE: If a change label still contains references to objects that no longer exist in the database, remove the assignment using the Repair button.

  4. (Optional) For additional settings for change label transport, click Options and specify the following options.

    Table 38: Additional transport settings
    Setting Description

    Close change label after export

    The change label is completed and locked after transport. No more changes can be booked to this change label.

    Copy dependent objects to the transport package

    Objects that are dependent on the selected object and do not have a change label are also copied to the transport.

    Also display closed change labels

    Change labels that are already closed are also offered for selection.

Related topics

Exporting changes based on change information

Use transport by change information to limit transportation data by user, time period and database tables.

To transport by change information

  1. In the Database Transporter, on the Define transport data page, select the Transport by change information export criteria.

  2. Specify which changes you want to transport.

    Table 39: User list
    Entry Description

    me

    Only the changes by the logged-in user are added.

    all users

    Changes are added from all users.

    selected users

    Changes are added from selected users.

    TIP: The User area displays the system users. The ... button beside the input field allows you to select other users. Use Shift + select or Ctrl + select to select multiple users in the selection dialog.

  3. Use the date filter to export changes for the selected user(s) from a specified date. The entries today, yesterday, day before yesterday, this week and last database migration and time period are available.

  4. You can limit transportation data even further by selecting database tables.
  5. Table 40: Table selection
    Entry Description

    Entire system

    Changes are added from all tables.

    System data

    Changes are added from the tables of the system data part.

    User data

    Changes are added from the tables of the user data part.

    Selected tables

    Changes are added from specific tables.

    TIP: To display objects that match the specified export criteria, click Display. In this overview, you can exclude individual objects from the transport To do this, disable the corresponding objects.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating