Updated: 05/02/2006

LDAP to SQL

Whilst working on the automatic production of web statistics - came across the following problem: &"How do I get relational data from an Hierarchical structure?&" It didn''t take long to realize - I''d have to use PHP to talk to LDAP, pull off records && upload into a series of tables, using the cn as primary key. Which then could be queried relationally. Pulling off large, queries and repeatedly transcending LDAP trees is pretty slow - so I built my LDAP to SQL engine, by flattening dns into table names. Then used PHP scripts to query && produce daily snap shots. This is the Perl port of the PHP version.

• Categories
  • CGI and Perl →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Sun Solaris
• Licenses
  • Freeware
• Author
  • Marcus