RE: LDAP implementation

>Hello All,
>We have a large suite of applications which
>accesses oracle database for all the data
>manipulation. Last week, one of our customers
>changed the requirements and asked us to make all
>our apps directly access the LDAP server
>(Non-Oracle v3 compliant) and obviously they want
>this task completed in a month. Is there a easy way
>to replicate data back and forth between LDAP
>server and Oracle database so we can still
>manipulate the data without modifying the
>applications.
>
>Thanks
>Rakesh
>

Rakesh,

   I have done this for a customer. What we do is that we use Oracle tables which are 'snapshots' of the LDAP data. This has been implemented using PL/SQL tables which are filled with the suitable data using the DBMS_LDAP package (calling the LDAP server), and the object option to map pseudo-views over those in-memory tables. The tables are refreshed every 20 mn (cron job) by simple queries over those pseudo views. The applications could indeed call the pseudo-views directly, but then if the LDAP server were down (God forbid) nothing would work.  The bulk of the job was writing a generator for all the SQL and PL/SQL required. One month is a bit short, IMHO.

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).