Process LDAP data reading LDIF files

dataservices administration
1

Dear all,

I’m facing the challenge to read/write LDIF files for processing directories information using BODI.

Because LDIF is a “multiple line record” format with multi-values, I’ve been thinking to use XML / DTD’s for processing those data but … if for converting from XML to LDAP a more-less simple XSL-T stylesheet can do the job, for reading I need a solution …

Does anyone have any idea of any “successfull” project for convertion of LDAP entries to XML Schema ?

TIA,

TRS-80.

TRS-80 :belgium: (BOB member since 2005-03-29)

2

TRS-80,

Have you considered DSML? I don’t know alot about it, but it seems to be what you are looking for.

http://www.oasis-open.org/specs/index.php#dsmlv2

  • Ernie

eepjr24 :us: (BOB member since 2005-09-16)

3

Ernie,

Thanx a lot for your answer.
I was probably surfing on the same wave.

Here is the proposal I made :

Usage of some ODBC wrapper for LDAP like DataDirect (http://media.datadirect.com/download/docs/slnk/admin/ldap.html)

Developpement of a BODI Adapter (Java and some libraries like OpenLDAP (http://www.openldap.org/jldap/))

Using of DSML (Directory Services Markup Language (http://www.oasis-open.org/specs/index.php#dsmlv2)) that provide a XML standard for working with LDAP data. It exists more than one projet providing technology for converting LDIF > DSML et DSML > LDIF. As an usable example, Graham Barr wrote a extention module for Perl that let you read / write LDIF and DSML. (http://search.cpan.org/~gbarr/perl-ldap/lib/Net/LDAP/LDIF.pod & http://search.cpan.org/~gbarr/perl-ldap/lib/Net/LDAP/DSML.pm))

TRS-80 :belgium: (BOB member since 2005-03-29)

4

Has anyone developed a custom adapter for DI to talk to LDAP?

I would like to be able to interface to Active Directory via LDAP, and, both read and write to LDAP.

Alternatively, for a platform-specific solution, if running DI job server on Windows, you could use ADSI to talk to AD. But LDAP would be better.

thanks

dnewton :us: (BOB member since 2004-01-30)

5

In addition to the commerical ODBC-for-LDAP drivers available, I did remember that if you’re all Windows/SQL Server, you can create a linked server from SQL Server to Active Directory. Then DI should be able to use that?..


EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', 
@srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject', 
@datasrc=N'adsdatasource' 

go

select * from openquery
(
ADSI,'SELECT givenname,sn,mail,ADsPath,cn
FROM ''LDAP://myLDAPserver.mycompany.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')

go

Could create a view on top of the openquery query above. I doubt you could write to it, though; only read.

dnewton :us: (BOB member since 2004-01-30)

6

I just wanted to check if there had been any other developments on this front? Any plans to implement any native Active Directory (or generic LDAP for that matter) access functionality, or should I go ahead and evaluate the third-party stuff and/or try the SQL solution?

jamonwagner :us: (BOB member since 2007-03-14)