Re: [GENERAL] Import LDAP data to a Postgres database

[Chris Browne]

[EMAIL PROTECTED] (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:

  

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

  
-- 
select 'cbbrowne' || '@' || 'linuxdatabases.info';
http://www3.sympatico.ca/cbbrowne/sap.html
Microsoft Outlook: Deploying Viruses Has Never Been This Easy!

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Import LDAP data to a Postgres database

[Albe Laurenz]

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

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Import LDAP data to a Postgres database

[Magnus Hagander]

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 Postgres database (under linux) ???

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

//Magnus


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Import LDAP data to a Postgres database

[Andrej Ricnik-Bay]

On 12/6/07, Marco Curtolo <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] Import LDAP data to a Postgres database

[Marco Curtolo]

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.

_
Scarica GRATIS 30 emoticon per Messenger!
http://www.emoticons-livemessenger.com/pages/msnit/index.htm