Establish Connectivity to MicroStrategy
This article describes the process of creating plugin Data Source to connect to MicroStrategy. This Data Source will allow data from existing MicroStrategy objects to be used in building elements using Metric Insights tools.
- You must have network connectivity access from Metric Insights to your MicroStrategy Intelligence server (default port 34952). If there is no access, then you can use a lighter version of this plugin connector by setting a plugin parameter to bypass ('Use only Task API'). See below.
1. Access Admin > Data Sources
At the bottom of the screen click [+ New Data Source].
The Select the Type of New Data Source pop-up opens.
2. Select "Other" Data Source Type and choose "Microstrategy" from the drop-down list
Move to the Next step.
3. Provide the Required Microstrategy Parameters
- Data Source Name: defaults to a unique name, but may be modified to a descriptive name of your own.
- Endpoint: The URL to MicroStrategy Task API. This is the API Metric Insights uses for accessing MicroStrategy. For .NET the url is typically https://<mstr host>/MicroStrategy/asp/TaskAdmin.aspx. For Java, this is https://<mstr host>/servlet/taskAdmin. As confirmation, you can access this URL via your web browser.
- Project: the MicroStrategy project
- Username / Password: This is the username and password you use to access the Task API Endpoint (Java Web API).
Optionally, to enable secure connection to WEB API using a certificate:
- specify proper SSL port value of MicroStrategy Intelligence server in a port field (default configuration is 39321).
add a configuration parameter to file /opt/mi/datacollector/plugins/mstr.conf :
- Test Connection (this will also Save your data)
4. Define the values for Optional Parameters (if needed)
The plugin uses two API methods for pulling data and images from MicroStrategy. The MicroStrategy Task API, and the MicroStrategy Java Web API. The reason for this is each API only returns a subset of what is needed by Metric Insights.
|Number on a screen||Field Name||Description|
Current View Media
||Values: 1 = Standard (default), 16 = LDAP Authentication, 4 = Database Authentication, 8 = Guest, 2 = Windows Authentication, 64 = Trusted Authentication, 128 = Integrated Authentication.
Report Image as Grid
||MicroStrategy renders Reports as Grid or Chart. Default is ‘Grid'.
||The list of object types to use
|4||Port||Port used for accessing the MicroStrategy Intelligence Server via the MicroStrategy Java Web API. Default port is 34952. If using a different port then specify here. If not specified here, then the MicroStrategy API uses the default port value (34952).
||The starting (root) folder for your Project. All MicroStrategy documents and reports under this folder will be available.
||For Task API if the server name is different than the host name in the Task API Endpoint.
Task API Password / Task API Username
||Specify the Task API username/password here if the credentials for accessing the Task API differ from accessing the Java Web API (saved in Username and Password above).
WebService Password / WebService User
||If there is a separate Web Service User to access the Task Admin login page, then supply the credentials here.
5. Advanced Configurations
External Reports fetch method: This setting influences options available in the Microstrategy Reports List tab:
- automatically: just click Refresh list and all Reports are going to be fetched by the system
- manually: Reports may be added one-by-one or via CSV file
- Optionally, specify the maximum number of concurrent Threads per Trigger execution to be used in background processing when the system updates Metrics and Reports for this Data Source. If you do not specify any value for this setting, batch data collection processing will be single-threaded.
6. Other Settings
- You can create elements or Datasets directly from the respective tabs
- Click Permissions to assign them to Groups or Power Users