DBAT CONNECTOR INSTALLATION AND SETUP

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.

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.