Create a lookup for User Status:
1. Login to Design
Console.
2. Expand
Administration and double click on Lookup Definition.
3. Enter
“Lookup.DBAT.User.Status” for Code and “DBAT” for Group and then Click Save.
4. Add two new
Lookup Codes and click Save as highlighted.
Note: Creating a lookup is not a mandatory step. It is used only if you are provisioning user status to the target database table.
Note: Creating a lookup is not a mandatory step. It is used only if you are provisioning user status to the target database table.
Installing DBAT Connector:
1. Copy the
Database_App_Tables_9.1.0.5.0 directory into $ORACLE_OIM_HOME/server/ConnectorDefaultDirectory
folder
Note: replace $ORACLE_OIM_HOME with the OIM HOME
directory.
2. Login to OIM
System Administration Console.
3. Click on Manage
Connector link.
4. Click on
Install.
5. Select
DatabaseApplicationTables 9.1.0.5.0 from the Connector List and Click Load.
6. Click Continue.
7. Click Exit on
the Confirmation of Successful Connector Installation Page.
Configure Generic Technology Connector:
1. Login to OIM
System Administration Console.
2.
Click on the Generic Connector link.
3. Click on
Create.
4. Enter Name as “DBAT_USR_CONNECTOR” or any name
you want unselect Reconciliation check box and select Provisioning check box.
Select “Database Application Tables Provisioning” for both Transport
Provider and Format Provider under Provisioning and then click Continue.
5. Enter the
details of the target database, target table, Unique column, Status Column and
Status lookup as "Lookup.DBAT.User.Status" created earlier and
click next.
6. Map the OIM
attributes and Click Close.
7. Enter “DBATUSR”
for OIM – Account and click Continue.
8. Verify the
Connector information and click Save.
Run catalog sync scheduler job.
You
can create an Access Policy to provision this resource automatically. For
testing this you can manually add the DBAT_USR_CONNECTOR_GTC resource manually.
2 comments:
Hey Venkata,
Thanks for the helpful info. I know my DBAT connector has successfully provision users to the database. I want to customize the UI to make it more user friendly. I have a child form for groups and I used a lookup code for the list of groups. Instead of using a lookup UI I want to use a checkbox showing all the groups. Do you have an idea how this can be done?
I created user using dbat connector, but data is not replicate, but scheduler got created success, I searched in all logs, it showing no files remaining, but where the issue I couldn't find, please help me in this,
Post a Comment