MicroStrategy ONE

Configure the MicroStrategy Connector

The MicroStrategy connector allows you to fetch data from reports or cubes that reside on other MicroStrategy projects or environments.

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

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

  • Web
  • Workstation
  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 dashboard.
  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.