To import data from an external database into the One Identity Manager database
NOTE: Leave this field empty if you want to create a new import definition.
To set up a connection with an external database
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.
Refer to the documentation of the database provider implemented, for the connection parameters.
If the database can be successfully connected, you can continue.
Formulate the source data query either by selecting the table and columns or with an SQL statement.
Select the table and columns with contents to transfer.
Select the table from the menu.
Enter the column name directly into the input field or open a dialog window to select the column with the ... button.
Use a condition to limit the data to import. Format the condition as a valid where clause for a database query.
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.
Formulate the data set selection as database query in SQL syntax.
An import configuration includes the following steps: