Identity Manager 8.0 - Configuration Guide

Importing Data from a Database

To import data from an external database 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 from database" for this.
4. Specify the connection data to the external database.
5. Formulate the source data query.
6. 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.
7. Save the import definition file and the import script.
8. Start the import.
9. End the program or start another import.

Detailed information about this topic

• Selecting an External Database
• Source Data Query
• Assigning Target Tables and Columns
• Specifying the Hierarchy
• Options for Handling Records
• Specifying Connection Variables
• Importing Data
• Using Import Definition Files

Selecting an External Database

To set up a connection with an external database

1. Select the external database provider in the section "Connection type".

   A list of the various database providers available is shown.

   Supported Data Providers
   Odbc Data Provider
   OleDb Data Provider
   OracleClient Data Provider
   SQLClient Data Provider
   dotConnector for Oracle
   Microsoft SQL Server Compact Data Provider

   When you use another database provider, select it using the ... button next to the input field. Use the button to remove a provider entry.

2. Enter the connection data for the external database in the section "Connection data". Select ... to to this and enter the connection data. Use the button to encrypt the connection data.

   Refer to the documentation of the database provider implemented, for the connection parameters.

3. Click Check to test the database connection.

   If the database can be successfully connected, you can continue.

4. 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.

Source Data Query

Formulate the source data query either by selecting the table and columns or with an SQL statement.

Selecting Table and Columns

Select the table and columns with contents to transfer.

• Table

  Select the table from the menu.

• Columns

  Enter the column name directly into the input field or open a dialog window to select the column with the ... button.

• WHERE clause

  Use a condition to limit the data to import. Format the condition as a valid where clause for a database query.

• Order by

  The sort order is required if the data records have to be transferred in a defined sequence, for example, as in hierarchical structures. Format the sort order as a valid order by statement for a database query.

SQL statement

Formulate the data set selection as database query in SQL syntax.

Import Configuration

An import configuration includes the following steps:

1. Assigning the data to target tables and columns in the One Identity Manager database.
2. Specifying the data hierarchy for the import.
3. Specifying options for handling the data.
4. Defining variables that are set on import.

Detailed information about this topic

• Assigning Target Tables and Columns
• Specifying the Hierarchy
• Options for Handling Records
• Specifying Connection Variables