Re: [389-users] Sync from RDBMS to LDAP

[Fong, Trevor]

*Bump*

Surely we can't be the only ones who want to this?

Trev

From: Fong, Trevor
Sent: April-22-14 3:33 PM
To: '[e-mail]'
Subject: Sync from RDBMS to LDAP

Hi Everyone,

We are in the process of migrating from an old OpenLDAP service to 389-DS.
We currently synchronise users and attributes from an Oracle DB to OpenLDAP service using an aging set of custom scripts and DB triggers.
We would like to do something similar for 389-DS but using a commercial-off-the-shelf solution.
I was wondering what the good people on this list use or would recommend?

Thanks in advance,
Trev

---------------------------------------------------------
Trevor Fong - Senior Programmer Analyst
Identity and Access Management Group
University of British Columbia - Information Technology
6356 Agricultural Road, Vancouver, BC, V6T 1Z2, Canada
Ph: [phone]

Sync from RDBMS to LDAP

[Clowser, Jeff]

If you want a commercial solution, take a look at the Unbound ID Synchronization server.  Depending on how complex your needs are, that may work.

This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them.

________________________________
From: [e-mail] [mailto:[e-mail]] On Behalf Of Paul Robert Marino
Sent: Tuesday, April 29, 2014 8:55 AM
To: General discussion list for the 389 Directory server project.
Subject: Re: [389-users] Sync from RDBMS to LDAP

Sorry that kind of thing is always a custom scripting job.

-- Sent from my HP Pre3

________________________________
On Apr 28, 2014 13:27, Fong, Trevor  wrote:

*Bump*
Surely we can't be the only ones who want to this?
Trev
From: Fong, Trevor
Sent: April-22-14 3:33 PM
To: '[e-mail]'
Subject: Sync from RDBMS to LDAP
Hi Everyone,
We are in the process of migrating from an old OpenLDAP service to 389-DS.
We currently synchronise users and attributes from an Oracle DB to OpenLDAP service using an aging set of custom scripts and DB triggers.
We would like to do something similar for 389-DS but using a commercial-off-the-shelf solution.
I was wondering what the good people on this list use or would recommend?
Thanks in advance,
Trev
---------------------------------------------------------
Trevor Fong - Senior Programmer Analyst
Identity and Access Management Group
University of British Columbia - Information Technology
6356 Agricultural Road, Vancouver, BC, V6T 1Z2, Canada
Ph: [phone]

Sync from RDBMS to LDAP

[Fong, Trevor]

Thanks a lot for the lead, Jeff - I'll check it out.
For the thread - there's also Ldap Sync Connector from lsc-project.org, which is open source, but commercial support is preferred.

Other suggestions welcome!
Trev

From: [e-mail] [mailto:[e-mail]] On Behalf Of Clowser, Jeff
Sent: April-29-14 7:02 AM
To: 'General discussion list for the 389 Directory server project.'
Subject: Re: [389-users] Sync from RDBMS to LDAP

If you want a commercial solution, take a look at the Unbound ID Synchronization server.  Depending on how complex your needs are, that may work.

This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them.

________________________________
From: [e-mail] [mailto:[e-mail]] On Behalf Of Paul Robert Marino
Sent: Tuesday, April 29, 2014 8:55 AM
To: General discussion list for the 389 Directory server project.
Subject: Re: [389-users] Sync from RDBMS to LDAP
Sorry that kind of thing is always a custom scripting job.

-- Sent from my HP Pre3

________________________________
On Apr 28, 2014 13:27, Fong, Trevor <[e-mail]> wrote:
*Bump*

Surely we can't be the only ones who want to this?

Trev

From: Fong, Trevor
Sent: April-22-14 3:33 PM
To: '[e-mail]'
Subject: Sync from RDBMS to LDAP

Hi Everyone,

We are in the process of migrating from an old OpenLDAP service to 389-DS.
We currently synchronise users and attributes from an Oracle DB to OpenLDAP service using an aging set of custom scripts and DB triggers.
We would like to do something similar for 389-DS but using a commercial-off-the-shelf solution.
I was wondering what the good people on this list use or would recommend?

Thanks in advance,
Trev

---------------------------------------------------------
Trevor Fong - Senior Programmer Analyst
Identity and Access Management Group
University of British Columbia - Information Technology
6356 Agricultural Road, Vancouver, BC, V6T 1Z2, Canada
Ph: [phone]

Sync from RDBMS to LDAP

[Robin Garner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 30/04/14 01:00, Fong, Trevor wrote:
> Thanks a lot for the lead, Jeff – I’ll check it out.
>
> For the thread – there’s also Ldap Sync Connector from
> lsc-project.org, which is open source, but commercial support is
> preferred.

We use lsc for a variety of data synchronization tasks, including DBMS
- -> LDAP, LDAP -> LDAP and LDAP -> DBMS.  I recommend it highly.
> Other suggestions welcome!
>
> Trev
>
> *From:*[e-mail] 
> [mailto:[e-mail]] *On Behalf Of 
> *Clowser, Jeff *Sent:* April-29-14 7:02 AM *To:* 'General
> discussion list for the 389 Directory server project.' *Subject:*
> Re: [389-users] Sync from RDBMS to LDAP
>
> If you want a commercial solution, take a look at the Unbound ID 
> Synchronization server.  Depending on how complex your needs are,
> that may work.
>
> This e-mail and its attachments are confidential and solely for
> the intended addressee(s). Do not share or use them without Fannie
> Mae’s approval. If received in error, contact the sender and delete
> them.
>
> *From:*[e-mail] 
>  
> [mailto:[e-mail]] *On Behalf Of
> *Paul Robert Marino *Sent:* Tuesday, April 29, 2014 8:55 AM *To:*
> General discussion list for the 389 Directory server project. 
> *Subject:* Re: [389-users] Sync from RDBMS to LDAP
>
> Sorry that kind of thing is always a custom scripting job.
>
> -- Sent from my HP Pre3
>
> On Apr 28, 2014 13:27, Fong, Trevor <[e-mail] 
> > wrote:
>
> **Bump**
>
> Surely we can’t be the only ones who want to this?
>
> Trev
>
> *From:*Fong, Trevor *Sent:* April-22-14 3:33 PM *To:*
> '[e-mail]' *Subject:* Sync from RDBMS to
> LDAP
>
> Hi Everyone,
>
> We are in the process of migrating from an old OpenLDAP service to
> 389-DS.
>
> We currently synchronise users and attributes from an Oracle DB to 
> OpenLDAP service using an aging set of custom scripts and DB
> triggers.
>
> We would like to do something similar for 389-DS but using a 
> commercial-off-the-shelf solution.
>
> I was wondering what the good people on this list use or would
> recommend?
>
> Thanks in advance,
>
> Trev
>
> --------------------------------------------------------- Trevor
> Fong – Senior Programmer Analyst
>
> Identity and Access Management Group University of British Columbia
> – Information Technology 6356 Agricultural Road, Vancouver, BC, V6T
> 1Z2, Canada Ph: [phone]
>
> -- 389 users mailing list [e-mail] 
> https://admin.fedoraproject.org/mailman/listinfo/389-users

- -- 
Dr Robin Garner
Technology Services
Southern Cross University
P: [phone]   M: [phone]
http://cs.anu.edu.au/people/robin.garner/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQEcBAEBAgAGBQJTY0tVAAoJEHm9xBvoMhvaCs8IAICoiIxynIbwt2m9GUXnkGPH
> pw6MDwI7lwci49Oh/MNv3K5D0p61fpBJcm77sBDSPtnHO/VwvpFsWF/R+mAoF90N
> saGyGey+AxT36JFOIjWpy3vX/ZO4Vqr21Nq2lxnglwZkekTn0kRG84pt7pg0to/D
> 7Ic0s0zuS7OcN6+uOLJ7IcqNB3+JhLSFlWaxuie6OrhPsOBj3ZxSx2+RFSrOfOz7
> YZqP13QzucuzsTmHGla2cWvUSMlQ2IqHZsE7zHV6QFweg4pwbEGSHpSNujTas29a
> pqwjDPJ9P9vsUBNZXl76ahXOvvyJFX4BvXhMWAyA/gcV3WIuiqg9s2+TpHUZAFo=
> =3WBJ
> -----END PGP SIGNATURE-----