Thread: Import LDAP data to a Postgres database

Hi, my question is this: it is possible to query, using SQL, an LDAP server and put these data to a table of a Postgres database (under linux) ???
Thanks to all.

---

Concerti trailer e video divertenti! MSN Video

On 12/6/07, Marco Curtolo <marcoecommerce@hotmail.it> wrote:
>  Hi, my question is this: it is possible to query, using SQL, an LDAP server
> and put these data to a table of a Postgres database (under linux) ???
I don't know of any LDAP server implementations that can
be queried via SQL, and getting LDAP tree data into any
RDBMS can be done, but it won't be trivial once you get
to tree objects that have more than one value per attribute,
i.e. you'll have to map those attributes into separate tables.




> Thanks to all.
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

On Thu, Dec 06, 2007 at 09:42:19AM +0100, Marco Curtolo wrote:
>
> Hi, my question is this: it is possible to query, using SQL, an LDAP server and put these data to a table of a
Postgresdatabase (under linux) ??? 

Depending on exactly what you nede to do, check out dblink-ldap
(http://pgfoundry.org/projects/dblink-ldap/)

//Magnus

Marco Curtolo write:
> Hi, my question is this: it is possible to query, using SQL,
> an LDAP server and put these data to a table of a Postgres
> database (under linux) ???

Yes, by writing a function in C that uses the LDAP API.

Yours,
Laurenz Albe

marcoecommerce@hotmail.it (Marco Curtolo) writes:
> Hi, my question is this: it is possible to query, using SQL, an LDAP
> server and put these data to a table of a Postgres database (under
> linux) ???

Unfortunately, the LDAP model is more or less a "network model," which
doesn't fit terribly elegantly onto SQL.

You can in fact use PostgreSQL as the backend for OpenLDAP; there's a
HOWTO on this:

  <http://www.samse.fr/GPL/ldap_pg/HOWTO/>

There are also ways of exporting SQL data via LDAP; see here:

  <http://www.openldap.org/faq/data/cache/378.html>
--
select 'cbbrowne' || '@' || 'linuxdatabases.info';
http://www3.sympatico.ca/cbbrowne/sap.html
Microsoft Outlook: Deploying Viruses Has Never Been This Easy!