Re: Re: Fwd: Re: SQL And openldap

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

> I dun want to use the back-sql database. Do corret me if i am wrong. Heard
> that search performance will be slowed down if using the back-sql rather
> than the normal ldbm.

this depends greatly on your details - how complex are your LDAP schema and
database schema, how effective is your index set, etc.. - just as in any
RDBMS application... Some benchmarks of back-sql performance are available
somewhere in list archives - see Sam Drake's report.

>
> So, I would like to make changes in the database, so as to maintain data
> consistency and upload the data in ldif format to the LDAP server. Any
> API/interface/tool/ to allow for such conversion?

Not that I'm aware of. After all, what other tool do you need besides T-SQL
or PL/SQL or whatever server-side language your RDBMS supports?.. LDIF is
not so hard to produce, the main problem can be to write it out as a file :)

>
> Thanz a lot ,
> once again
>
> sze yee
>
> > > ----- 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 -----
> > >
> > >
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Shopping - Beat the crowds!  Do your X'mas Shopping Online!
> > http://shopping.yahoo.com.sg/
> >