To import data from an external database into the One Identity Manager database
-
Start the Launchpad and log in to the One Identity Manager database.
- On the Configuration page, select Configure a data import. This starts the Data Import program.
- On the Data Import start page, click Next.
- On the Select the database connection page, check the One Identity Manager database connection data and change it if necessary.
- (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.
- On the Select data source page, select the Import from database import method.
- On the Select external database page, specify the connection data to the external database.
- On the Select source data page, formulate the query to determine the data records from the external database.
-
Configure the import.
- 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.
- On the Specify hierarchy page, specify the data hierarchy for the import.
- On the Handling options for data sets page, specify options for handling the data.
- On the Connection variables page, define variables that are set on import.
- On the Saving the import definition page, save the import definition file and the import script.
- On the Saving the import definition page, start the import.
- On the last page of the Data Import, quit the program or start another import.
Detailed information about this topic
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
- In the Connection type section, select the provider of the external database.
- In the Connection data section, enter the connection data to the external database.
- Select the ... button and enter the connection data.
- (Optional) To encrypt the connection data, click .
- To check the connection data, click Test.
- 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.
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
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.
Creating an import configuration includes the following steps:
- Assigning the data to target tables and columns in the One Identity Manager database.
- Specifying the data hierarchy for the import.
- Specifying options for handling the data.
- Defining variables that are set on import.
Detailed information about this topic