Chat now with support
Chat with Support

Identity Manager 8.0 - Configuration Guide

One Identity Manager Software Architecture Working with the Designer Customizing the One Identity Manager Default Configuration Checking Data Consistency Compiling a One Identity Manager Database Working with Change Labels Basic System Configuration Data
One Identity Manager Authentication Module Database Connection Data Configuration Parameters for System Configuration Setting up the Mail Notification System Enabling More Languages for Displaying and Maintaining Data Displaying Country Information Setting Up and Configuring Schedules Password Policies in One Identity Manager Reloading Changes Dynamically TimeTrace Databases Machine Roles and Server Functions Files for Software Update Operating Systems in Use System Configuration Reports Using Predefined Database Queries Managing Custom Database Objects within a Database
The One Identity Manager Data Model Granting One Identity Manager Schema Permissions Working with the User Interface
Object definitions for the User Interface User Interface Navigation Forms for the User Interface Statistics in the One Identity Manager Extending the Launchpad Task Definitions for the User Interface Applications for Configuring the User Interface Icons and Images for Configuring the User Interface Language Dependent Data Representation
Process Orchestration in One Identity Manager
Declaring the Job Server One Identity Manager Service Configuration Handling Processes in the One Identity Manager
Tracking Changes with Process Monitoring Conditional Compilation using Preprocessor Conditions One Identity Manager Scripts Maintaining Mail Templates Reports in the One Identity Manager Custom schema extensions Transporting One Identity Manager Schema Customizations Importing Data Web Service Integration SOAP Web Service One Identity Manager as SPML Provisioning Service Provider Searching for Errors in the One Identity Manager Processing DBQueue Tasks One Identity Manager Configuration Files

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

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
Related Documents