Re: Fwd: Re: SQL And openldap

["Dmitry Kovalev" <mitya@seismic.ru>]

Well, it looks more like point (1) after all ;)
That's because if you set up OpenLDAP server with back-sql on your SQL
Server database, LDAP will automatically reflect database changes with no
uploads, because it simply uses the same data...
However, it is much better to make changes through LDAP, because:
1) back-sql will still reflect them into RDBMS, so legacy apps will see them
ok
2) you still can use LDAP replication service, in contrast to the case when
you make changes using SQL directly (in that case they appear in LDAP server
with back-sql, but don't appear in replication log, because they don't go
through LDAP operations)

If you cannot/don't want to use OpenLDAP with back-sql - you can write a
trigger or sheduled application which could export your data in LDIF format,
then load it into separate LDAP server...

WBW, Dmitry

----- Original Message -----
From: "sze4041" <sze4041@singnet.com.sg>
To: "Openldap Discussion group" <openldap-software@OpenLDAP.org>
Sent: Friday, December 14, 2001 5:32 PM
Subject: Fwd: Fwd: Re: SQL And openldap


> My point is more of point (2).
> What I intend to do is to make my changes to a database ,
> say running on the SQL server.
>
> The data will then be stored in SQL Server and will be
> uploaded to the ldap server.
>
> Any pointer is there any tools around to do that ?
>
> Thanz
>
> sze yee
>
>
> > > I did not quite catch your point, but I can
> > imagine
> > > several different things
> > > you could mean:
> > >
> > > 1) a way to have your data in mySQL, accessible
> > also
> > > as LDAP tree, so that
> > > when you modify your data using SQL, they are
> > seen
> > > through LDAP, and/or
> > > vice versa. you can do this with OpenLDAP, using
> > > back-sql
> > >
> > > 2) a way to access/change your LDAP database using
> > > SQL, not native LDAP. I
> > > remember of some software called Enlist or smth.
> > > alike, which provides ODBC
> > > access to LDAP data sources...
> > >
> > > WBW, Dmitry
> > >
> > > ----- Original Message -----
> > > From: "Lye" <sze4041@singnet.com.sg>
> > > To: <openldap-software@OpenLDAP.org>
> > > Sent: Thursday, December 13, 2001 3:45 PM
> > > Subject: SQL And openldap
> > >
> > >
> > > > Hi, all
> > > >
> > > > i wonder if there is any tools/codes/interface
> > > that can allow me to send
> > > > updates to an openldap server via a database,
> > say
> > > running mySQL.
> > > >
> > > > thanz
> > > >
> > > > sze yee
> > > >
> > >
> > >
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Shopping - Beat the crowds!  Do your X'mas
> > Shopping Online!
> > http://shopping.yahoo.com.sg/
> >
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Beat the crowds!  Do your X'mas Shopping
> Online!
> http://shopping.yahoo.com.sg/
>
> ----- End forwarded message -----