This article explains how the Microstrategy connector for DataGalaxy works.
This connector is available in the following modes:
| Desktop mode ✅ | SaaS Online mode ❌ |
Connector Overview
The connector allows to retrieve metadata from Documents, Reports and Cubes via the Microstrategy API. The retrieved objects and their correspondences in DataGalaxy are detailed in the following table:
| Microstrategy Object | DataGalaxy Object | Comments |
|---|---|---|
| Project | Application | The connector imports one project at a time, the user will provide its name in the connection settings. The project is imported as an application in a root application (to be named during the configuration) in the Usage module. |
| Folder | Application | Each folder shared in the Microstrategy tool is imported as an application. |
| Document / Portfolio | Dashboard | Documents and Reports are imported as children of an application object corresponding to the folder, thus preserving the tree structure defined in tool. |
| Report | Report | |
| Cube | Data Set | Each cube is imported as a dataset with attributes and measures as child fields. Links are created to associate the dataset used in a report or document. |
Step 1: Installation
- Download DataGalaxy connector from the portal (see here)
- Extract the connector archive in the directory of your choice
- Download the Microstrategy plug-in from the portal and copy it into the /lib directory of the connector
Step 2: Running the Microstrategy connector
- After starting the connector, access Software type connectors:
- If it has been correctly installed, the Microstrategy plug-in appears in the list
- The following information is requested:
| Parameter | Mandatory | Description |
API Host URL | Yes | Microstrategy API URL in the following format: http://servername:portnumber/MicroStrategyLibrary You should not use "app" in the URL because all REST APIs are located in /MicroStrategyLibrary and not in MicroStrategyLibrary/app. |
| Project Name | Yes | Microstrategy project name. During the connection test, the project name is checked. If it is not correct, an error message is displayed with the list of projects names that are accessible with current authentication parameters. |
| Root application name | Yes | Name of the "parent" application in the DataGalaxy Usage module, which will be used to store all reports, documents and cubes of the Microstrategy tool. If the application does not exist, it will be created during the import. |
| Locale ID | Yes | Choice of language to display the data in the Datagalaxy platform. The default language is English (value en_us). |
| User | Yes | |
| Password | Yes |
Technical Information
The connector uses Microstrategy API (v2): https://demo.microstrategy.com/MicroStrategyLibrary/api-docs/index.html#/
Releases
| Date | Plugin Version | DataGalaxy release | Desktop connector version (minimum) | Description |
| 28/08/2024 | 4.0.1 | v3.69.0 | 5.2.3 | Updated the logger to show more information when using verbose mode |
| 26/07/2024 | 4.0.0 | v3.62.0 | 5.0.3 | Migrated from java 11 to java 17 |