Re: Share data between Oracle RDBM and Oracle Internet Directory (LDAP)

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0412030656.4be725b6_at_posting.google.com...
> Zixiong WANG <zxwang_at_sysium.com> wrote in message
> news:<41af6f20$0$26091$636a15ce_at_news.free.fr>...
>>
>> Is it possible to store data in tables then query these data both by SQL
>> and by LDAP (via Oracle Internet Directory) ?
>>
>> Oracle Internet Directory (OID) uses Oracle RDBM as data backend, but
>> how directory entries are stored as tables ?
>>
>> Are these tables OID specific and can't be modified or extended ?
>>
>> Or in the opposite direction : if I'v conventional raltional tables, can
>> I query them through OID using LDAP ? and how ?
>
> It's not possible to query Oracle table data using LDAP unless the
> data is stored by following Oracle's LDAP format, e.g. by using OID
> tools. How the directory entries are stored can be deduced by looking
> at tables in the ODS schema, and by tracing SQLs when you run LDAP
> commands on OS. These tables are OID specific. Modifying them would be
> equivalent to modifying Oracle data dictionary. Your last question is
> the same as the first one.
>
> Here's an example of the SQL run by Oracle when I run this OS command:
> C:\>ldapsearch -p <myOIDport> -h <myserver> -D "cn=orcladmin" -w
> <mypassword> -b "orclReferenceName=iasdb,cn=IAS Infrastructure
> Databases,cn=IAS,cn=Products,cn=oraclecontext" "orclresourcename=ODS"
> orclpasswordattribute
>
> And the SQLs are fairly complex. (I pulled out of v$sql; you can set
> sql_trace=true to do the same.) They basically select attrval FROM
> ds_attrstore WHERE entryid IN ( SELECT entryid FROM ct_dn WHERE
> rdn='orclreferencename=iasdb' AND ... The other SQL is SELECT entryid
> FROM ct_dn WHERE entryid in ( (SELECT entryid FROM ct_orclResourceName
> WHERE at1.attrvalue...
>
> If you know LDAP internals in general, it's worth the time and effort
> to study OID this way.
>
> Yong Huang

An alternative solution might be to use the OID plug-in framework; in that way you could intercept
certain ldap operations and retrieve values from your own tables. See the OID Application Developers Guide

hth
rob van lopik Received on Fri Dec 03 2004 - 09:23:28 CST