Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Dennis Benzinger | hybris GmbH October 9, 2011

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?

3 answers

1 accepted

1 vote
Answer accepted
Tam Nguyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 9, 2012

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;

1 vote
Vallatharasu Vallatharasu April 25, 2012

Hi

We would like to move the crowd groups to AD.

is it possible?

Thanks

Arasu

Dennis Benzinger | hybris GmbH April 25, 2012

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

0 votes
John Cheng January 9, 2012

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 | hybris GmbH January 9, 2012

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events