Oracle® Identity Manager Connector Guide for Database User Management Release 9.0.4 Part Number E10154-01 |
|
|
View PDF |
After you deploy the connector, you must configure it to meet your requirements. This chapter discusses the following connector configuration procedures:
Note:
These sections provide both conceptual and procedural information about configuring the connector. It is recommended that you read the conceptual information before you perform the procedures.As mentioned earlier in this guide, reconciliation involves duplicating in Oracle Identity Manager additions of and modifications to user accounts on the target system. This section discusses the following topics related to configuring reconciliation:
By default, all target system records that are added or modified after the last reconciliation run are reconciled during the current reconciliation run. You can customize this process by specifying the subset of added or modified target system records that must be reconciled. You do this by creating a filter for the reconciliation module.
Creating a filter involves specifying a value for the Login Name
scheduled task attribute. This value is used in the query SELECT criteria to reconcile target system records for which the value of the Login Name
field matches the value of the Login Name
scheduled task attribute.
For example, if you specify jdoe
as the value of the Login Name
scheduled task attribute, then all new or updated target system records for which the login name is jdoe
are reconciled.
While deploying the connector, follow the instructions in the "Configuring the Reconciliation Scheduled Tasks" section to specify values for the Login Name
scheduled task attribute.
During a reconciliation run, all changes in the target system records are reconciled into Oracle Identity Manager. Depending on the number of records to be reconciled, this process may require a large amount of time. In addition, if the connection breaks during reconciliation, then the process would take longer to complete.
For a trial reconciliation run, you can specify the number of records to be reconciled by using the Record Size
user reconciliation scheduled task attribute. The numeric value that you assign to this attribute represents the number of records that must be reconciled. The default value of the Record Size
attribute is All
, which signifies that all records are to be reconciled.
You can use this feature to perform a trial reconciliation run.
You specify a value for the Record Size
attribute by following the instructions described in the "Configuring the Reconciliation Scheduled Tasks" section.
While configuring the connector, the target system can be designated as a trusted source or a target resource. If you designate the target system as a trusted source, then both newly created and modified user accounts are reconciled in Oracle Identity Manager. If you designate the target system as a target resource, then only modified user accounts are reconciled in Oracle Identity Manager.
Note:
You can skip this section if you do not want to designate the target system as a trusted source for reconciliation.Configuring trusted source reconciliation involves the following steps:
Note:
You can skip this section if you do not want to designate the target system as a trusted source for reconciliation.Import the XML file for trusted source reconciliation, xelluserDbAcess Trusted.xml
, by using the Deployment Manager. This section describes the procedure to import the XML file.
Note:
Only one target system can be designated as a trusted source. If you import thexelluserDbAcess Trusted.xml
file while you have another trusted source configured, then both connector reconciliations would stop working.Specify values for the attributes of the Database Reconciliation Task - Trusted
scheduled task. This procedure is described later in this guide.
To configure trusted source reconciliation:
Open the Oracle Identity Manager Administrative and User Console.
Click the Deployment Management link on the left navigation bar.
Click the Import link under Deployment Management. A dialog box for locating files is displayed.
Locate and open the xelluserDbAcess Trusted.xml
file, which is in the OIM_home
/xellerate/XLIntegrations/DatabaseAccess/xml
directory. Details of this XML file are shown on the File Preview page.
Click Add File. The Substitutions page is displayed.
Click Next. The Confirmation page is displayed.
Click Import.
In the message that is displayed, click Import to confirm that you want to import the XML file and then click OK.
When you perform the procedure described in the "Step 5: Importing the Connector XML Files" section, the scheduled tasks for lookup fields, trusted source user, and nontrusted user reconciliations are automatically created in Oracle Identity Manager. To configure these scheduled tasks:
Open the Oracle Identity Manager Design Console.
Expand the Xellerate Administration folder.
Select Task Scheduler.
Click Find. The details of the predefined scheduled task are displayed.
Enter a number in the Max Retries field. This number represents the number of times Oracle Identity Manager must attempt to complete the task before assigning the ERROR
status to the task.
Ensure that the Disabled and Stop Execution check boxes are not selected.
In the Start region, double-click the Start Time field. From the date-time editor that is displayed, select the date and time at which you want the task to run.
In the Interval region, set the following schedule parameters:
To set the task to run on a recurring basis, select the Daily, Weekly, Recurring Intervals, Monthly, or Yearly option.
If you select the Recurring Intervals option, then you must also specify the time interval at which you want the task to run on a recurring basis.
To set the task to run only once, select the Once option.
Depending on whether you want to implement trusted or nontrusted soured reconciliation, you must specify values for the attributes of one of the following scheduled tasks:
Database Reconciliation Task - Trusted
(Scheduled task for trusted source reconciliation)
Database Reconciliation Task - Non Trusted
(Scheduled task for nontrusted source reconciliation)
The following table describes the attributes of both scheduled tasks.
Note:
Attribute values are predefined in the connector XML file that you import. Specify values only for those attributes that you want to change.
Values (either default or user-defined) must be assigned to all the attributes. If even a single attribute value were left empty, then reconciliation would not be performed.
Attribute | Description | Sample Value |
---|---|---|
Server |
Name of the IT resource | Oracle |
isTrusted |
Specifies whether or not reconciliation is to be carried out in trusted mode | For trusted source reconciliation, set the value of this attribute to Yes .
For nontrusted source reconciliation, set the value of this attribute to |
Target System Login Recon - Resource Object name |
Name of the target system parent resource object | Database Access (Login) |
Target System User Recon - Resource Object name |
Name of the target system child resource object | Database Access (User) |
Trusted Source Recon - Resource Object name |
Name of the trusted source resource object | For trusted source reconciliation:
For nontrusted source reconciliation:
|
DB2DBName |
For IBM DB2 UDB, Microsoft SQL Server, and Sybase, specify the name of the target database from where data is to be reconciled.
For Oracle Database, do not specify any value for this attribute. |
TESTDB |
Login Name |
This is a filter attribute.
Use this attribute to specify the login name of the user whose records you want to reconcile. If you do not want to use then specify See Also: The "Partial Reconciliation" section |
Jdoe |
Record Size |
Specifies the number of records to be reconciled
The value can be any integer greater than zero. |
The default value of this attribute is All. |
See Also:
Oracle Identity Manager Design Console Guide for information about adding and removing task attributesClick Save. The scheduled task is created. The INACTIVE
status is displayed in the Status field, because the task is not currently running. The task is run at the date and time that you set in Step 7.
If you are using Oracle Identity Manager release 9.0.1, then you must perform the following procedure to enable reconciliation:
See Also:
Oracle Identity Manager Design Console GuideOpen the Process Definition form for the Database Access (Login)
User. This form is in the Process Management folder.
Click the Reconciliation Field Mappings tab.
For each field that is of the IT resource type:
Double-click the field to open the Edit Reconciliation Field Mapping window for that field.
Deselect Key Field for Reconciliation Matching.
Repeat Steps 1 through 3 for the Database Access (User)
user.
As mentioned earlier in this guide, provisioning involves creating or modifying a user's account information on the target system through Oracle Identity Manager. Refer to the "Supported Functionality" section for a listing of the provisioning functions that are available with this connector.
Note:
You must perform this procedure if you want to use the provisioning features of the connector.Adapters are used to implement provisioning functions. The following adapters are imported into Oracle Identity Manager when you import the connector XML file:
See Also:
The "Supported Functionality" section for a listing of the provisioning functions that are available with this connectorDB Revoke Role
DB Modify Password
DB Modify Login
DB Enable login
DB Disable login
DB Delete Login
DB Create Login
DB Add TableSpace
DB Add Schema
DB Add Role
DB Delete TableSpace
DB Prepopulate UserLogin
DB Update Group
DB EnableSybaseUser
DB DisableSybaseUser
DB Delete User
DB Create User
DB Prepopulate UserLogin
You must compile these adapters before they can be used in provisioning operations.
To compile adapters by using the Adapter Manager form:
Open the Adapter Manager form.
To compile all the adapters that you import into the current database, select Compile All.
To compile multiple (but not all) adapters, select the adapters you want to compile. Then, select Compile Selected.
Note:
Click Compile Previously Failed to recompile only those adapters that were not compiled successfully. Such adapters do not have anOK
compilation status.Click Start. Oracle Identity Manager compiles the selected adapters.
If Oracle Identity Manager is installed in a clustered environment, then copy the compiled adapters from the OIM_home
/xellerate/Adapter
directory to the same directory on each of the other nodes of the cluster. If required, overwrite the adapter files on the other nodes.
If you want to compile one adapter at a time, then use the Adapter Factory form.
See Also:
Oracle Identity Manager Tools Reference Guide for information about using the Adapter Factory and Adapter Manager formsTo view detailed information about an adapter:
Highlight the adapter in the Adapter Manager form.
Double-click the row header of the adapter, or right-click the adapter.
Select Launch Adapter from the shortcut menu that is displayed. Details of the adapter are displayed.
Note:
The instructions given in this section are not part of the deployment procedure.If you want to enable the option for changing the default language assigned to provisioned user accounts, then:
See Also:
Oracle Identity Manager Design Console GuideNote:
Perform this procedure only if you want to configure the connector for multiple installations of the target system.You may want to configure the connector for multiple installations of the target system. The following example illustrates this requirement:
The Tokyo, London, and New York offices of Acme Multinational Inc. have their own installations of the target system. The company has recently installed Oracle Identity Manager, and they want to configure Oracle Identity Manager to link all the installations of the target system.
To meet the requirement posed by such a scenario, you must configure the connector for multiple installations of the target system.
To configure the connector for multiple installations of the target system:
See Also:
Oracle Identity Manager Design Console Guide for detailed instructions on performing each step of this procedureCreate and configure one IT resource for each target system installation.
The IT Resources form is in the Resource Management folder. An IT resource is created when you import the connector XML file. You can use this IT resource as the template for creating the remaining IT resources, of the same IT resource type.
Configure reconciliation for each target system installation. Refer to the "Configuring Reconciliation" section for instructions. Note that you only need to modify the attributes that are used to specify the IT resource and to specify whether or not the target system installation is to be set up as a trusted source.
If required, modify the fields to be reconciled for the Xellerate User resource object.
When you use the Administrative and User Console to perform provisioning, you can specify the IT resource corresponding to the target system installation to which you want to provision the user.