1) Login to sysadm console -> Select Generic Connector
2) Select Create
3) Before selecting Transport provider and Format provider, place Database Connector(Database_App_Tables_9.1.0.5.0) in
Middleware_Home\Oracle_IDM1\server\ConnectorDefaultDirectory folder and install it using Manage Connector. After DB connector installation you can find option "Database Application Tables Provisioning"
4) Before proceeding to Step 5 need to create user and Table in database. Below image shows queries for creation of table, insertion into table, (skip), Creating user in database, grating privileges to user, commit. (first create user and grant privileges followed by table creation and insertion)
5) Provide DB details as shown below
6) Verify and click Close.
7) Verify all the values and click Save
8) Select Get Lock (This is not compulsory step)
9) Create Sandbox and activate it.
10) Create Application Instance.
11) Provide details as shown below. ( Need to create IT Resource with DB details and Form)
12) Publish Sandbox
13) Go to Scheduler
14) Run "Catalog Synchronization Job"
15) Verify that it runs Successfully.
Go to Identity Console and Provision User to DB. (refer
http://www.iamidm.com/2012/09/oim-11g-r2-lab-1-provisioning-user-to-ad.html from
Step 12 in Step 18 instead of Network account Select
Database Accounts)
Verify DB if user got created or not.
Thanks !!!