[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Mapping multiple object classes to one SQL table

To: openldap-software@openldap.org
Subject: Re: Mapping multiple object classes to one SQL table
From: Adam Tauno Williams <adamtaunowilliams@gmail.com>
Date: Tue, 29 May 2007 07:15:44 -0400
In-reply-to: <000901c7a18c$57099e50$0300a8c0@nboscan>
References: <000901c7a18c$57099e50$0300a8c0@nboscan>

> I'm trying to create a SQL data and metadata that manages employees that
> have inetOrgPerson, shadowAccount, posixAccount and sambaSamAccount. I have
> an LDAP_PERSON table with the columns for the attributes on those object
> classes. How do I populate the ldap_oc_mapping table?

This is entirely dependent on you data and database-of-choice.  Views
tend to be very useful for this;  check out
http://docs.opengroupware.org/Members/whitemice/OGo-Back-SQL/ogo-back-sql-create.sql for an example of how to use fancy SQL to automatically map a complex schema.

-- 
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org

References:
- Mapping multiple object classes to one SQL table
  - From: Néstor Boscán <nestor.boscan@tcsapp.com.ve>

Prev by Date: Re: referential integrity (patch included)
Next by Date: Re: ldap_sasl_interactive_bind_s
Index(es):
- Chronological
- Thread