Migrate users from Crowd to Active Directory or other LDAP server?

[Dennis Benzinger SAP]

How can I migrate users from an internal Crowd directory into Active Directory or another LDAP server?

Is it possible to create an LDIF export of an internal Crowd directory?

[Tam Nguyen · Accepted solution]

You can make LDIF file by using sql query, it's easier than using API. The following code used for Jira, you can do the same thing with Crowd database ( cwd_user table)

select 'dn: cn=' || username || ',ou=users,dc=erx' || chr(13) ||
       'objectClass: person' || chr(13) ||
       'objectClass: top' || chr(13) ||
       'email: ' || (select propertyvalue from propertystring ps inner join propertyentry pe on ps.id = pe.id where pe.entity_id = ub.id and entity_name = 'OSUser' and property_key = 'email') || chr(13) ||
       'uid: ' || username || chr(13) ||
       'cn: ' || username || chr(13) ||
       'structuralObjectClass: person' || chr(13) ||
       'givenName: ' || (select propertyvalue from propertystring ps inner join propertyentry pe on ps.id = pe.id where pe.entity_id = ub.id and entity_name = 'OSUser' and property_key = 'fullName')  || chr(13) || chr(13)
from userbase ub;

[Vallatharasu Vallatharasu]

Hi

We would like to move the crowd groups to AD.

is it possible?

Thanks

Arasu

[Dennis Benzinger SAP]

As this is a new question, you shouldn't add it as an answer to my question, but rather as a new question.

[John Cheng]

I'm guessing you could use the API to query each account and then output it in LDIF format. I guess then your question would now be, if there is an existing solution to this that is known to work, so you don't have to do it yourself.

[Dennis Benzinger SAP]

Yes, doing it yourself is always an option. I hoped for an existing solution. Thanks anyways!