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 data import and click Start.
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.