Identity Manager 8.0 - Configuration Guide

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 menu item Help | Transport history.

Importing Data

Data Import has a program called "One Identity Manager" which provides a simple solution for importing data from other systems. The program supports importing from 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

   Two methods are supplied, "Import CSV file" and "Import from database".

3. Configure the import
4. Create an import definition
5. Create an import script
6. Start the import

Detailed information about this topic

• Importing Data from CSV Files
• Importing Data from a Database
• Import Configuration
• Using Import Definition Files
• Importing Data

Importing Data from CSV Files

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

• The data is separated by a delimiter.
• The data records are separated by a new line.
• Data that contains a new line is marked with a text qualifier.
• The data in the import files is already sorted accordingly to resolve object dependencies in larger CSV imports.

  NOTE You can use the Data Import sort options for CSV imports with small data sets.

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

1. Start the Data Import and log in to the program.
2. Load the import definition file, if available.

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

3. Select the import method "Import CSV files".
4. Load the import file and enter any additional data.
5. Specify how the file is structured.
6. Specify how the row structure is set up.
7. Specify a condition for the rows to import.
8. Configure the import.
   1. Assign the data to target tables and columns in the One Identity Manager database.
   2. Specify the key columns.
   3. Specify the data hierarchy for the import.
   4. Specify options for handling the data.
   5. Define the variables to be set during the import.
9. Save the import definition file and the import script.
10. Start the import.
11. End the program or start another import.

Detailed information about this topic

• Loading Import Files
• Specifying the File Structure
• Specifying a Line Condition
• Assigning Target Tables and Columns
• Specifying the Hierarchy
• Options for Handling Records
• Specifying Connection Variables
• Importing Data
• Using Import Definition Files

Loading Import Files

Enter the following data to load an import file:

• Import file

  Enter the path for the file that contains the import data. Use the ... button next to text box to browse for the file and open it.

• File encoding

  CSV file character encoding. 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

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

• Time zones

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