Chat now with support
Chat with Support

Identity Manager 8.1.4 - Operational Guide

About this guide Simulating data changes in the Manager Scheduling operations activation times Re-applying templates Exporting data with 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 Data Import Importing and exporting individual files for the software update Command line programs

Displaying contents of a transport package

To display the contents of 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. This starts the Database Transporter program.
  3. Select Show transport file.
  4. Select the transport package file browser and click Open.
  5. Click Next on the Select transport file page.
  6. The contents of the transport file are displayed on the Show transport file page.
    • To display the sequence in which the objects are imported:
      1. Click + to select an entry in the transport file and select Sort in import order from the context menu.
      2. Click OK and enter the connection credentials for the database. This step is only required when you established the first in the order.

        The order in which the entry's objects are imported into the database is found.

      3. Repeat this step for all other entries for which you want to determine the import order.

    • To display the objects required for an import in the target environment, select the entry for the .xml file and select Show required objects from the context menu.

      Objects that are dependent on another object that is not part of the transport package are highlighted.

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

TIP: You can start the import of the transport package from display mode. On the Show transport file page, click the name of the transport package and use the Import context menu.

Related topics

Importing data with Data Import

With the Data Import program, the One Identity Manager offers a simple means of importing data from other systems. The program supports importing from .csv files and importing directly from other database systems. You can import data immediately. You also have the option to import data from customized processes using the import scripts that are created. The import definition is saved so that you can use it for future data imports.

The steps in the program are as follows:

  1. Load export definitions
  2. Select the import method
  3. Configure the import
  4. Create an import definition
  5. Create an import script
  6. Start the import

NOTE:

  • For regular data imports into One Identity Manager, you can also use the ScriptComponent process component.
  • The DataImporterCMD.exe program provides support for imports from the command line.
Detailed information about this topic

Importing data from a CSV file

Prerequisites

The data structure of the import file needs to fulfill the following requirements:

  • The data is separated by a delimiter or fixed column widths are used.
  • The data records are separated by a new line.
  • Data that contains a new line is marked with a text qualifier.
  • For more extensive CSV imports, the data in the import file is sorted in advance to resolve the object dependencies.

    NOTE: For imports with small amounts of data, use the sorting options of the Data Import.

To import data from CSV files into the One Identity Manager database

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

  2. On the Configuration page, select the Configure a data import option. This starts the Data Import program.
  3. On the Data Import start page, click Next.
  4. On the Select the database connection page, check the One Identity Manager database connection data and change it if necessary.
  5. (optional) On the Loading an import definition file page, load the import definition file, if available.

    NOTE: Leave this field empty if you want to create a new import definition.

  6. On the Select data source page, select the Import CSV file method.

  7. On the Load import file page, load the import file and enter additional data about the import file.

  8. On the File structure page, specify how the file is structured.
  9. On the Defining the line structure page, specify the structure of the lines.
  10. (Optional) On the Line condition page, specify a condition for importing lines.
  11. Configure the import.
    1. On the Match target tables and columns page, assign the data for target tables and target columns of the One Identity Manager database and specify the key columns.
    2. On the Specify hierarchy page, specify the data hierarchy for the import.
    3. On the Handling options for data sets page, specify options for handling the data.
    4. On the Connection variables page, define variables that are set on import.
  12. On the Saving the import definition page, save the import definition file and the import script.
  13. On the Saving the import definition page, start the import.
  14. On the last page of the Data Import, quit the program or start another import.
Detailed information about this topic

Loading the CSV file

On the Load import file page in Data Import, enter the following data about the import file.

Table 47: Import file settings

Property

Description

Import file

Path to the .csv file containing the data to be imported. You can use the ... button beside the input field to navigate to and open the file.

File encoding

Encoding of the .csv file. Encoding of the character set is determined from the character set on your workstation when the import file is loaded. Change the setting if the file was created with another character set.

File culture

Language used to create the file. The language is required in order to read local character formats correctly, for example, dates.

Time zones

If date and time information is imported, select the time zone of the data. The time zone is required for converting the data to UTC.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating