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

Grousing DBF Files With OpenLDAP (back-sql, back-perl, etc...)

First off, I have a wondefully functional collection of OpenLDAP 2.0.x servers 
performing innumerable tasks on my network:  PAM, NSS, Samba, DNS/bind, ILS, 
Apache authentication, Squid authentication, shared address books, Horde 
preference store, and probably a couple of things I don't remember.  All this 
with the back-ldbm; works flawlessly and performance is excellent.

Thanks to all the OpenLDAP team.

But now I've had unique and nasty problem thrown on my plate.

We have a CRM system which runs on Win32 that stores contact information 
in .DBF files (Yea, I know - Ick!).  These are Dbase IV type files and I can 
read them on a Win32 box via the ODBC drivers that come with M$-Office.

The actual datafiles reside on a RedHat Linux Samba server,  shared to the 
client workstations.  There is also an NT4 box that runs a process unattended 
that utilizes this data.

What I need to do is somehow present the data from these files (name, address, 
phone, fax, e-mail) via LDAP to mail clients.

These files change ALOT and I'd love to avoid doing a periodic-sync/dump thing.

I've looked all over for a DBF ODBC driver for Linux so I could try and use 
back-sql, but haven't turned anything up.  Also don't know if DBF is actually 
SQL-ish enough to work with back-sql (no views, stored procedures, etc...)

But I have seen that there is a Perl back end floating about, and there are 
lots of DBI modules for dBase.

So I'm curious if anyone has attempted anything like this before,  and how 
difficult they think this would be.