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

Importing data from an external database

To import data from an external database 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 Configure a data import. 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 from database import method.
  7. On the Select external database page, specify the connection data to the external database.
  8. On the Select source data page, formulate the query to determine the data records from the external database.

  9. 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.
  10. On the Saving the import definition page, save the import definition file and the import script.
  11. On the Saving the import definition page, start the import.
  12. On the last page of the Data Import, quit the program or start another import.
Detailed information about this topic

Selecting an external database

In the Data Import on the Select external database, specify the connection information. Refer to the documentation of the database provider implemented, for the connection parameters.

To set up a connection with an external database

  1. In the Connection type section, select the provider of the external database.

    • A list of the various database providers available is shown.

      Supported database 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.
  2. In the Connection data section, enter the connection data to the external database.
    1. Select the ... button and enter the connection data.
    2. (Optional) To encrypt the connection data, click .
    3. To check the connection data, click Test.
  3. If date and time information is imported, select the time zone of the data in the Other settings section. The time zone is required for converting the data to UTC.

Determining the source data

Formulate the query determine the data records from the external database in the Data Import on the Select source data page.

To determine the data from the external database

  • To select the table and columns from the external database directly, activate the Select source table and columns option and enter the following information.

    Table 50: Settings for selecting the table and columns

    Property

    Description

    Table

    Tables whose content is imported.

    Columns

    Columns whose content is imported.

    Enter the column relations directly in the input field or use the ... button to open a dialog window to select the columns.

    WHERE clause

    Condition to further limit the data to be imported.

    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.

  • To determine the data records with a SQL query, enable the SQL statement option and formulate the database query in SQL syntax.

Configuring an import

Creating 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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating