Migrating from OnDemand to a Crowd installed site

You can extract your user data from a Confluence or Jira application installed site instance. Use these queries to export your users and memberships to CSV, and then import them into Crowd.

Migrate Jira Cloud or Confluence Cloud

First you'll need to migrate Jira/Confluence Cloud to your server versions:

Migrate from Confluence Cloud to Data Center

Migrating from Jira Cloud to Server applications

Exporting user data

If you are using Postgres as your database with Jira or Confluence, you can generate the required CSV files from either of those systems, with the following queries. If you are using a different database, you may need to tweak these.

To generate users.csv
// Run on JIRA/Confluence
copy (SELECT user_name AS "Username", first_name AS "First Name", last_name AS "Last Name", email_address AS "Email Address", credential AS "Password" FROM cwd_user) to '/tmp/users.csv' csv header;
To generate group_memberships.csv
// Run on JIRA/Confluence
copy (SELECT DISTINCT child_name AS "Username", parent_name AS "Groupname" FROM cwd_membership) to '/tmp/group_memberships.csv' csv header;

Make sure that CSV files are encoded in UTF-8 (Unicode) to ensure compatibility for user data containing special or accented characters.

Retrieving the backup data

The files will be generated in /tmp, or in the folder specified in the query above.

What data is backed up

The backup includes the following data:

  • User accounts
  • Groups
  • Memberships

Importing the data into Crowd

  1. Follow the instructions in Importing Users from CSV Files
  2. Connect Crowd to your applications: Adding an Application
  3. Ensure that the Crowd Directory is placed above the Internal Directory in your User Directories in all downstream applications: Configuring User Directories. This is important because you will have the same users in both directories, and the users will authenticate against the highest directory in the hierarchy.
Last modified on Mar 13, 2019

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.