MicroStrategy ONE

Configure a Proxy

Follow the procedures below to configure a proxy:

Configure a Proxy in Intelligence Server for Windows

  1. Find the configuration file.

    After you install the Intelligence Server, the default configuration file, proxy.json, is installed automatically. This file is located at:

    Windows C:\Program Files (x86)\Common Files\MicroStrategy

    Linux <InstallPath>/install
    For example: /opt/mstr/MicroStrategy/install

    The steps for Workstation are similar to configuring the Intelligence Server, except that the proxy.json file is located at C:\Program Files\MicroStrategy\Workstation.

  2. Open proxy.json in a text editor and configure it. The following is the default configuration:

    Copy
    {
        "ENABLE_FLAG": "FALSE",
        "USE_PROXY_PAC": "FALSE",
        "PAC_URL": "",
        "USE_PROXY_STATIC": "FALSE",
        "PROXY_HOST": "",
        "PROXY_PORT": "",
        "PROXY_AUTHENTICATION": "FALSE",
        "USER_NAME": "",
        "PASSWORD": ""
    }

    You want to access data through the following authenticated proxy:

    • Host: 10.0.0.1
    • Port: 8080
    • Username: mstr
    • Password: 123456

    If the username or password contains special characters such as " or \, use escape characters for them. For example, if your proxy username is domain\user, the setting must be "USER_NAME": "domain\\user" in proxy.json.

    Configure proxy.json as follows:

    Copy
    {
        "ENABLE_FLAG": "TRUE",
        "USE_PROXY_PAC": "FALSE",
        "PAC_URL": "",
        "USE_PROXY_STATIC": "TRUE",
        "PROXY_HOST": "10.0.0.1",
        "PROXY_PORT": "8080",
        "PROXY_AUTHENTICATION": "TRUE",
        "USER_NAME": "mstr",
        "PASSWORD": "123456"
    }

    If the proxy server is not authenticated, set PROXY_AUTHENTICATION to FALSE. Configure it like this:

    Copy
    {
        "ENABLE_FLAG": "TRUE",
        "USE_PROXY_PAC": "FALSE",
        "PAC_URL": "",
        "USE_PROXY_STATIC": "TRUE",
        "PROXY_HOST": "10.0.0.1",
        "PROXY_PORT": "8080",
        "PROXY_AUTHENTICATION": "FALSE",
        "USER_NAME": "",
        "PASSWORD": ""
    }

    If you use a PAC file to configure your proxy, the PAC file location is C:/Config. Configure your proxy.json as follows:

    Copy
    {
        "ENABLE_FLAG": "TRUE",
        "USE_PROXY_PAC": "TRUE",
        "PAC_URL": "c:/config/example.pac",
        "USE_PROXY_STATIC": "FALSE",
        "PROXY_HOST": "",
        "PROXY_PORT": "",
        "PROXY_AUTHENTICATION": "",
        "USER_NAME": "",
        "PASSWORD": ""
    }

    You must configure the proxy correctly for it to take effect. Data access issues occur if the format is correct, but the proxy server is inaccessible.

  3. Restart the Intelligence Server.
  4. Verify your data.

    If you verify data from a URL, you can import data from a source that was previously inaccessible.

Configuration Field Descriptions

Item Description
ENABLE_FLAG Enable or disable the proxy. If the flag is false, the proxy does not take effect, regardless of the values in other fields.
USE_PROXY_PAC Set USE_PROXY_PAC or USE_PROXY_STATIC to TRUE to turn on the PAC mode or static mode.
PAC_URL Specify the path of the PAC file. Both local and online files are supported, such as Z:/BIN/X64/demo.pac or http://test/demo.pac.
USE_PROXY_STATIC If this flag is set to TRUE, PROXY_HOST and PROXY_PORT are set as the static proxy server.
PROXY_HOST The static proxy host name or IP address
PROXY_PORT The static proxy host port (numbers only)
PROXY_AUTHENTICATION Static proxy authentication flag. If this flag is true, use the specified USER_NAME and PASSWORD to access the static proxy server. This is supported only in static mode, PAC mode is currently not supported.
USER_NAME User name to access the static proxy server
PASSWORD Password to access the static proxy server

The ENABLE_FLAG is set to FALSE by default. This means any proxy configured in this file takes effect when you configure the system proxy. If you want to use proxy, turn on the proxy feature by setting ENABLE_FLAG to TRUE.

  1. You should always restart the Intelligence Server after changing the proxy configuration or the PAC file.

  2. To verify that the proxy is taking effect, retrieve a proxy log by enabling the RESTWrapper Info log in the MicroStrategy Diagnostics and Performance Logging Tool.

Configure a Proxy at the OS Level to Allow Data Import from oAuth 2.0 Data Sources

To allow data import from oAuth 2.0 data sources such as Facebook, Google, and X, MicroStrategy Intelligence Server must be able to connect to the Internet to retrieve the requested data.

If the Intelligence Server can only connect with the Internet through a proxy server, the proxy must be set at the OS level. Without configuring the proxy, the data import fails and the DSSerrors log contains entries, similar to the following since the host cannot be resolved:

Copy
[HOST:PMSTRA1360][SERVER:CastorServer][PID:2352][THR:7728][WSAuth][Error] Error in curl_easy_perform; Reason=Could not resolve host: graph.facebook.com

Windows (Available in MicroStrategy 10.4 and Newer)

The Intelligence Server reads the system proxy settings for the Intelligence Server service user.

  1. For non-SYSTEM Windows accounts, make sure the user account used to start the Intelligence Server service has the proxy set under Windows Control Panel > Internet Options > Connections > LAN settings.

  2. If Intelligence Server is started by the “SYSTEM” user, you must set the proxy manually through the Windows registry:

    Copy
    HKEY_USERS\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Internet Settings\
    ProxyEnable (REG_DWORD) 0x00000001
    ProxyServer (REG_SZ) <proxy server>:<port>

    S-1-5-18 is the registry value for SYSTEM account.

Linux (Available in MicroStrategy 10.3 and Newer)

  1. Set both http_proxy and https_proxy through Linux environmental variables.

    For single users:

    Copy
    export http_proxy=<proxy server>:<port>
    export https_proxy=<proxy server>:<port>

    For all users to edit /etc/profile and add:

    Copy
    # set proxy
    http_proxy=<proxy server>:<port>
    https_proxy=<proxy server>:<port>
    export http_proxy
    export https_proxy
  2. Restart Intelligence Server for the changes to take effect.

Priorities

There are two levels of proxy settings in MicroStrategy.

  • The higher priority level is the server-level configuration, which is configured in proxy.json.
  • The lower priority level is the system configuration, which is an environment variable in Linux or MacOS, and internet properties in Windows.

Limitations

  • The proxy setting is global. MicroStrategy uses the same proxy, even if a different user logs in.

  • For oAuth 2.0 data sources:

    • PAC file proxy configuration is not supported.

    • Only un-authenticated proxy is supported.

  • For Community Data Connectors, such as Jira, Sharepoint, etc, only PAC file proxy is supported. See Network Proxy Support for Connectors for detailed configurations.

Related Topics

KB305678: How to set a proxy for data import from oAuth data sources using MicroStrategy Intelligence Server