This step-by-step guide for setting up a simple, triggerless JDBC driver for Oracle eBusiness Suite foundation tables, will allow you to test drive your driver in a lab environment, without requiring access to the real thing.
Installing Oracle eBusiness Suite involves dealing with many steps and dozens of ISO files(for CDs or DVDs) and before you get to an actual lab environment, it may be useful to testdrive a driver on your test system.
The only requirement is access to an Oracle database installation. Then you can download the sql script at the bottom of this article to create the fake table and a view.
The table we will be looking at is FND_USER, under the APPLSYS schema. The FND_USER table stores application user account. Other tables may also contribute information.
Let's build a simple triggerless driver for FND_USER.
Figure 5: Select Direct and which 3rd party JDBC driver you want to use. You will need to download and copy the JDBC driver archives to your IdM server, for example /opt/Novell/eDirectory/lib/dirxml/classes for Linux and restart eDirectory.
Figure 17: After deploying/starting your driver, you should see accounts from Oracle.
After you have a basic driver up and running, you can add support for additional attributes/tables, configure the Subscriber Channel if you want a bi-directional driver.
As for password sync/reset on the Subscriber Channel(from Vault to Oracle) it is possible to leverage utilities like FNDCPASS from Oracle.
I will provide an example of enabling Password support in an upcoming article:
http://www.novell.com/communities/node/12924/oracle-ebusiness-suite-password-sync-subscriber-channel
Support
Documentation
Learning Services
Partner Programs