« Redis - perl bindings for hash storage with lists and sets | Main | Prvi dan na novom poslu: sistemski knjižničar »

Integrating systems using Net::LDAP::Server and RDBMS

Let's assume that we have two systems, one which support LDAP user accounts and other system, based on relational database (Koha, in this example) which has user information which you would like to expose using LDAP for first system.

We could export all data required into institution LDAP, but that would push a lot of junk which is really required only by one application. Worse yet, some of that data is somewhat sensitive because it include serial numbers (SID) and data from RFID cards.

But, since application supports LDAP and we have Net::LDAP::Server it should be easy! And it really is.

LDAP server accessing Koha database using DBI is really converter of LDAP search query into SQL where syntax which is than appended to initial select which returns attribute values for LDAP entry which will be returned for search request.

This small example will hopefully be useful to other people who would like to integrate two systems by exposing user data via LDAP protocol. Just remember that pushing real valid usable data back to LDAP always makes more sense if that data is useful for current or future systems...

PerlMonks has node with this annoucement, so you might want to comment there if it's in interest of general perl comunity

TrackBack

TrackBack URL for this entry:
http://blog.rot13.org/mt/mt-tb.cgi/618

Listed below are links to weblogs that reference Integrating systems using Net::LDAP::Server and RDBMS:

» LDAP server application integration with virtual LDAP from Dobrica Pavlinušić's Weblog / Blog
You have your new shiny application, and LDAP server on the other side. Easy as pie. What can go wrong? you use e-mail as login, and application assumes that logins don't have domain in them and allows you embedding of whole login into DN application ... [Read More]

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About

This page contains a single entry from the blog posted on March 29, 2009 9:22 PM.

The previous post in this blog was Redis - perl bindings for hash storage with lists and sets.

The next post in this blog is Prvi dan na novom poslu: sistemski knjižničar.

Many more can be found on the main index page or by looking through the archives.

Creative Commons License
This weblog is licensed under a Creative Commons License.