Fedora directory users - Jul 2007 - FDS / HR synchronization

Hi
Where should I start to read/look for if I''d like to achieve that user
data in FDS (username and passwd for domain logon, email address, group
membership (based on some employee data) ...) is synchronized with data
of our HR application, which stores data in SQL (Oracle)? HR application
and database are outsourced, FDS is at our company.

For example, when a new employee comes and his data in entered in HR
application, generated username, password, email address ... should be
somehow synchronized to FDS.
And, when some employee leave our company, his account in FDS becomes
inactive.

One way is to export date from SQL to CSV, use csv2ldif and import this
LDIF to FDS. This can be done manually (or maybe even automated in some
strange way).
Is there a more elegant way?

Thanks
Robert Ludvik

Robert Ludvik wrote:
> Hi
> Where should I start to read/look for if I''d like to achieve that
user
> data in FDS (username and passwd for domain logon, email address, group
> membership (based on some employee data) ...) is synchronized with data
> of our HR application, which stores data in SQL (Oracle)? HR application
> and database are outsourced, FDS is at our company.
>
> For example, when a new employee comes and his data in entered in HR
> application, generated username, password, email address ... should be
> somehow synchronized to FDS.
> And, when some employee leave our company, his account in FDS becomes
> inactive.
>
> One way is to export date from SQL to CSV, use csv2ldif and import this
> LDIF to FDS. This can be done manually (or maybe even automated in some
> strange way).
> Is there a more elegant way?
>   
I''m not sure, but here is a collection of perl-ldap scripts written by 
the Mozilla PerLDAP author at Netscape, which was used to sync up the 
LDAP data from PeopleSoft.  These are very old but might be useful if 
you are a perl hacker.  
ftp://ftp.mozilla.org/pub/mozilla.org/directory/tools
> Thanks
> Robert Ludvik
>
> --
> Fedora-directory-users mailing list
> Fedora-directory-users@redhat.com
> https://www.redhat.com/mailman/listinfo/fedora-directory-users
>