Version 2021

Configure the MicroStrategy Connector

The MicroStrategy connector allows you to fetch data from reports or cubes that reside on other MicroStrategy projects or environments. If you are using MicroStrategy 10.11 or earlier, see MicroStrategy Dataset Connector 10.11 or Earlier.

To use the connector, you must first perform the following steps to configure the connector.

  1. Set the Community Connectors Application URL
  2. Modify the whitelist.txt File
  3. Confirm the Connector URL
  4. Enable CORS Setting or add allowed origins

Set the Community Connectors Application URL

Administrator privileges are required.

  1. In MicroStrategy Web, click the username drop-down and select Preferences.

  2. Under Preferences Level, click Project Defaults.
  3. Enter your MicroStrategy Community Data Connectors application URL in Link to Community Connectors.

    The URL format: https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/

    • The HOST_NAME is the host name of the machine you have the Community Connectors application installed on.
    • The PORT_NUMBER is the port number that your web server listens to. Use only if required.


  4. Click Apply.

Modify the whitelist.txt File

  1. Navigate to your Community Connector server and open the whitelist.txt file.

    This is usually in Tomcat, in the file path [Tomcat]\webapps\CommunityConnectors\WEB-INF\whitelist.txt.

  2. Add a new line and enter your MicroStrategy Web server hostname.

  3. If the connector is deployed with cluster mode, you must add the MicroStrategy Web server hostname to the whitelist.txt file for each connector.

    If your Web server is deployed with cluster mode, then use the web load balancer's hostname in the whitelist.txt file.

Confirm the Connector URL

  1. Open MicroStrategy Web.
  2. Click Create > Add External Data.
  3. Locate the MicroStrategy Connector.

  4. Hover over the connector and click Edit Connector.

  5. Ensure your Connector URL has /mstr-native/ appended to the end. If it does not, add it to your URL.

    https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/mstr-native/

  6. Click Save.
  1. Open MicroStrategy Workstation.
  2. Create a new dossier.
  3. Go to Add Data > New Data.
  4. Locate the MicroStrategy Connector.

  5. Hover over the connector and click Edit Connector.

  6. Ensure your Connector URL has /mstr-native/ appended to the end. If it does not, add it to your URL.

    https://[HOST_NAME]:[PORT_NUMBER]/CommunityConnectors/mstr-native/

  7. Click Save.

You can now use the MicroStrategy Connector. For steps, see How to Use the MicroStrategy Connector.

Enable CORS Settings

To allow the embedding MicroStrategy content in an existing or separate web server, ensure Cross-Origin Resource Sharing (CORS) settings are enabled in your cloud environment.

You need a MicroStrategy Library Server using the HTTPS protocol.

Chrome Web Browser version 80 and above introduces new changes which may impact embedding. For more information, see KB484005: Chrome v80 Cookie Behavior and the Impact on MicroStrategy Deployments.

  1. From the cloud environment's welcome email, click Access MicroStrategy Platform.
  2. Under More Resources, hover over MicroStrategy Library and click Configure.
  3. On the Library Admin page, select Library Server from the menu bar.
  4. Under Security Settings, select All.
  5. Click Save.
  6. Restart the Library application.

Add Allowed Origins

Alternatively, you can add individual hosts to the Allowed Origins field of the Library Server to verify that stability is preserved and improved when CORS is enabled.

  1. From the cloud environment's welcome email, click Access MicroStrategy Platform.
  2. Under More Resources, hover over MicroStrategy Library and click Configure.
  3. On the Library Admin page, select Library Server from the menu bar.
  4. Under Security Settings, specify origins by input of URLs.
  5. Click Save.
  6. Restart the Library application.