MicroStrategy Connection File

Creating a Connection File in Microstrategy Workstation

A MicroStrategy connection file (also know as the .mstrc) is a text file that contains all of the information needed to connect Workstation to a MicroStrategy environment.  With a .mstrc file, users can simply import the file and enter their credentials, and then they will be connected to a MicroStrategy On-Premises Environment.

Requisites
 

• MicroStrategy Workstation
• URL for your Environment
• MicroStrategy Login credentials

How to create the connection file

With the integrated option Connect to New Environment:

1. Open Workstation window.
2. Go to Environments located under Manage on the left side.

 

3. Click on the plus symbol with the label of Connect to a New Environment.

 

4. Assign a friendly environment name.
5. Provide the Environment URL and click Continue.

Note: If it is a default MicroStrategy installation of MicroStrategy Library, the Environment URL format will be the following:https://LIBRARY_SERVER_URL_or_IP:8080/MicroStrategyLibrary/
 
Continue with Step 6.


Creating a .mstrc file from an empty text file

If instead a “.mstrc” file needs to be created for an environment connection prior submission, please follow these steps.

5.1. To create a MicroStrategy Environment connection file .mstrc, please open something similar to Notepad.
Use the Notepad and use the following syntax by replacing the values according to your environment:

{
  "authenticationMode" : 1,
  "dossierServerURL" : "https://LIBRARY_SERVER_URL/MicroStrategyLibrary_EXAMPLE/"",
  "environmentName" : "ENVIRONMENT_NAME"
}

The file looks like:

Note: If it is a default MicroStrategy installation of MicroStrategy Library, the environment URL format will be the following:
https://LIBRARY_SERVER_URL_or_IP:8080/MicroStrategyLibrary/
 
5.2. Save and assign a name to the file like “My_first_connection_file.mstrc”.
 
5.3. Continue with the previous Steps 2 and 3 above.
 
5.4. Drag and drop the .mstrc file created before and click Continue.



 

6. After finishing with any of the two previous methods, type the required credentials.
7. Click on Connect.
8. Start working within Workstation.

What does the .mstrc include?

• Environment Name—a unique name for your environment
• dossierServerURL—refers to URL of the Library Web Server associated with your environment
• Authentication Mode—way to authenticate when connecting to an environment
  • Possible options are Standard or Identity products