MicroStrategy ONE
MicroStrategy Community Data Connectors
MicroStrategy Community Data Connectors allow you to import data from different data sources into your MicroStrategy platform. The SharePoint File, SurveyMonkey, Alchemer, OneDrive, and Box connectors are commonly used connectors and can be used once the parameters are set. To utilize other connectors, deploy the individual connectors through the Community Connectors application in MicroStrategy Data Import Wizard.
Once the Community Connectors application is installed, administrators can setup MicroStrategy Web to configure and deploy any Community connector with few easy steps.
To use Community Data connectors with MicroStrategy Web, perform the following steps:
- Deploy Community Connectors War File
- Set the Community Connectors Application URL
- Configure Commonly Used Connectors
- Deploy Connectors to MicroStrategy Web
Once the administrator has configured and deployed the Community Connectors, users can learn how to use the connectors. For more information, see MicroStrategy Community Data Connectors in the MicroStrategy Web Help.
Limitations
The MicroStrategy connector creates a cube from a snapshot of data from the original data source, such as a cube or report. It references the original data source it was created from. When you move the connector cube across environments or projects using the package manager, the underlying data source remains unchanged. The main purpose of the connector is to create refreshable snapshots of data. It is not intended to be used as a migration tool.
Supported Authentication Types
The MicroStrategy connector supports standard and LDAP authentication.
Import Support
Reports
Report Type | Supported by MicroStrategy Connector? |
---|---|
Freeform SQL |
No |
Graph |
Yes |
Grid |
Yes |
Grid Graph |
Yes |
Intelligent Cube |
Yes |
MDX Cube |
Yes |
SQL |
No |
Datasets
Type | Supported by MicroStrategy Connector? |
---|---|
Dashboard Compound Grid |
No |
Dashboard Custom Visualizations |
No |
Dashboard Free-form Layout |
No |
Dashboard Out-of-the-box Visualizations |
No |
Intelligent Cube Live Connect |
Yes |
Intelligent Cube MTDI |
Yes |
Intelligent Cube OLAP |
Yes |
Documents
Documents are not supported by the MicroStrategy connector.
Other
Type | Supported by MicroStrategy Connector? |
---|---|
All attribute forms format types |
Yes Note: When you import geo attributes (longitude and latitude), they will not be properly set after import but can be set in the Prepare Data window |
All metric types | Partial |
Consolidations |
Yes |
Custom groups |
No |
Derived elements |
Yes |
Edit previously imported data | Yes |
Page-by reports (All pages) | No |
Page-by reports (First page) |
Yes |
Prepare data before import (attributes, metrics, attribute elements) |
No You can only select which attributes and metrics to import, sorting is supported |
Preview data before import |
Yes |
Prompted reports with and without default answers |
No |
Reports with system and nested prompts |
No |
Reports with view filters/reports, derived metrics |
No |
Select attribute forms to import |
No |
Select how attribute form names should be imported (For example, form name only) | No |
Select totals and subtotals to not import | No |
Totals and subtoals |
No |