Strategy ONE
Import Data from Strategy Community Data Connectors
Strategy Community Data Connectors allow you to import data from different data sources into your Strategy One platform. These connectors are shipped out-of-the-box.
To use Community Data connectors with Strategy Web, your administrator must perform the steps in Strategy Community Data Connectors.
Starting in MicroStrategy ONE Update 12, the following Community Data connectors were added to the new data import experience:
- Use Adobe Analysis Workspace to Import Data
- Use the SharePoint Files Connector
- Use the data.world Connector
- Use the Fitbit Connector
- Use the SurveyMonkey Connector
- Use the Alchemer Connector
- Use the Jira Connector
- Use the Elasticsearch Connector
- Use the Solr Connector
- Use the TapClicks Connector
Starting in MicroStrategy 2021 Update 8, the new data import experience also includes OneDrive and Box Community Data connectors.
Strategy Community Data Connectors allow you to import data from different data sources into your Strategy One platform. These connectors are shipped out-of-the-box.
Limitations
The Strategy 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 Strategy connector supports standard and LDAP authentication.
Import Support
Reports
| Report Type | Supported by Strategy Connector? |
|---|---|
|
Freeform SQL |
No |
|
Graph |
Yes |
|
Grid |
Yes |
|
Grid Graph |
Yes |
|
Intelligent Cube |
Yes |
|
MDX Cube |
Yes |
|
SQL |
No |
Datasets
| Type | Supported by Strategy 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 Strategy connector.
Other
| Type | Supported by Strategy 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 |