Chat now with support
Chat with Support

Identity Manager 9.0 LTS - 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

Displaying transport history

The export date, the export description, database revision and the name of the export file in the source database transport history are recorded when a transport package is created with the Database Transporter.

When you import a transport package with the Database Transporter, the import date and description, the database version, and the transport package name are recorded in the transport history of the target database.

To display transport history

  • Start the Designer and select the Help > Transport history menu item.

Creating transport packages with the Database Transporter

You create transport packages to exchange customer-specific changes between the development, test, and productive system databases.

To create a transport package

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

  2. In the Change & Extend view, select the Transport custom modifications entry and click Start.

    This starts the Database Transporter program.

  3. Select Create a transport file on the start page.

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

  5. Enter the information about the transport file on the Define file name page.

    1. Enter the name of the transport file and change the output directory as required.

    2. (Optional) To create a log file for the export, set the Create a log file for data export option.

      The log file is saved in the output directory of the transport file.

  6. Enter a description of the transport data on the Show and define transport parameters page.

  7. Select the export criteria for the transport on the Define transport data page.

    NOTE: You can combine multiple export criteria.

    Table 37: Export criteria
    Export criterion Description

    Run SQL statements before data import

    You can integrate SQL statements in the custom configuration package, which are to be run before a data import.

    For more information, see Integrating SQL statements in transport packages.

    Transport of favorite objects

    In an initial selection, all modified processes, scripts, reports, and mail templates for a specific timeframe are offered.

    For more information, see Exporting favorite objects.

    Transport by change label

    Transport the changes to objects or object attributes that are summarized in a change label.

    For more information, see Exporting change labels.

    Transport by change information

    Limit the transportation data by user, timeframe, and database tables.

    For more information, see Exporting changes based on change information.

    Transport schema extensions

    Transport custom schema extensions, such as tables, columns, database procedures, functions, triggers, views, and indexes.

    For more information, see Transporting schema extensions.

    Transporting selected objects and their dependencies

    Select single objects and their dependencies for transport.

    For more information, see Exporting selected objects and dependencies.

    Transport system configuration

    Transport the entire system configuration.

    For more information, see Exporting the entire system configuration and Tips for importing the system configuration.

    Transport the system configuration as delta transport

    Find the differences in the configuration and create a delta transport.

    For more information, see Exporting system configurations as delta transports and Tips for importing the system configuration.

    Transport system files

    Transport single files.

    For more information, see Exporting system files.

    Create cumulative transport

    You can group together several custom configuration packages into one cumulative transport package.

    For more information, see Creating cumulative transports.

    Transport synchronization projects

    Select the synchronization project for transporting.

    For more information, see the One Identity Manager Target System Synchronization Reference Guide.

    Run SQL statements after the data import

    You can integrate SQL statements in the custom configuration package, which are to be run after a data import.

    For more information, see Integrating SQL statements in transport packages.

    Use a transport template for selection

    Select a transport template for the transport. The export criteria are determined from the transport template.

    For more information, see Creating and using transport templates.

  8. To start the export, click Next.

    This create the transport package. The program determines the data to export and displays the progress of the export in the dialog box. The export procedure can take some time.

  9. On the last page, the name and storage path for the transport package are displayed. You can open the directory path using the link.

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

Related topics

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 the Transport favorite objects 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 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
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating