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
• Tags
  • automatic sql,
  • get data from sql,
  • get php,
  • hierarchical,
  • hierarchical query sql,
  • ldap php,
  • ldap sql,
  • ldap to sql,
  • my sql query,
  • my sql table,
  • perl php scripts,
  • perl scripts,
  • perl sql query,
  • php dns,
  • php ldap sql,
  • php my sql,
  • php perl,
  • php perl scripts,
  • php sql,
  • php sql query,
  • php statistics,
  • php upload,
  • php upload scripts,
  • query sql,
  • query sql table,
  • scripts upload,
  • sql data,
  • sql get scripts,
  • sql hierarchical,
  • sql hierarchical queries,
  • sql hierarchical query,
  • sql ldap,
  • sql queries,
  • sql queries and,
  • sql query,
  • sql query and,
  • sql query as,
  • sql query data,
  • sql query table,
  • sql scripts,
  • sql table,
  • sql using,
  • upload scripts,
  • upload scripts php,
  • upload statistics,
  • using sql,
  • web perl,
  • web trees
  • ...
• Platforms
  • Linux,
  • Sun Solaris
• Licenses
  • Freeware
• Author
  • Marcus