Categories

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.
©2019 A--9.com