Configuring Single Sign-On to MicroStrategy Without LDAP

You can configure single sign-on to MicroStrategy without LDAP by first mapping users with their corresponding MicroStrategy IDs.

The configuration process is as follows:

1. Gather MicroStrategy user information and add to MicroStrategy Identity:
• Manually:
1. Obtain MicroStrategy user IDs manually
2. Adding Users Manually
• Import from a CSV file:
  1. Export MicroStrategy user information to a CSV file
  2. Adding Users from a CSV File
2. Register MicroStrategy products with MicroStrategy Identity
3. Configure MicroStrategy Identity in MicroStrategy Web and Mobile
4. Log into MicroStrategy with MicroStrategy Identity

Gather MicroStrategy User Information

Obtain MicroStrategy User IDs Manually

1. Launch MicroStrategy Developer and log in as a user with administrative privileges.

   If you are running MicroStrategy Developer on Windows for the first time, run it as an administrator.

   Right‑click the program icon and select Run as Administrator.

   This is necessary in order to properly set the Windows registry keys. For more information, see KB43491.

2. Expand MicroStrategy Analytics Modules > Administration > User Manager and click Everyone.
3. Right-click the user whom you want to be able to use MicroStrategy Identity to log in as and select Properties.
4. Under the General tab, copy the string listed for the ID value. For example: 0123456789ABCDEF0123456789ABCDEF
5. Repeat steps 3 and 4 for each user you want to import into MicroStrategy Identity.

When adding users into the Identity Network, either through manual entry or by importing a CSV file, ensure the MicroStrategy user ID is in the Username column. This is the value that MicroStrategy Web or Mobile will request from Identity during the single sign-on login process.

Export MicroStrategy User Information to a CSV File

1. On the machine where you downloaded and extracted the MicroStrategy installation files, navigate to Extracted_Path\Installations\Utilities, where Extracted_Path is the location where you downloaded and extracted the installation files; for example, D:\Downloads\MicroStrategy. The folder contains a compressed file called exporter.zip.
2. Extract the contents of exporter.zip to a folder; for example, exporter.
3. Open a Command Prompt window, and navigate to the folder where you extracted the contents of exporter.zip. For example, D:\Downloads\MicroStrategy\Installations\Utilities\exporter.

4. Type the following command:

   java -jar exporter.jar servername port username password default_title

   Where the variables in italics are as follows:

   servername: The server name of the machine where Intelligence Server is installed.

   port: The port number for the Intelligence Server. By default, the port number is 0.

   username: Your MicroStrategy username.

   password: Your MicroStrategy password.

   default_title: (Optional) The title that is displayed on your users' MicroStrategy Badge badges.

5. Press Enter. In the exporter folder, a new file is created, called exportedUsers.csv.
6. Open exportedUsers.csv in Microsoft Excel^®, and ensure the following, without which users may not be added to your Identity Network:
• All users have a first and last name.
• All users have an email address.

• No other columns for a user are empty.

  If any of the above information is missing, you must manually enter the information for the user, and save the file.

7. Save the file to the computer that you use to access MicroStrategy Identity Manager.