MicroStrategy for Qlik Sense

This connector allows you to import datasets from cubes and reports in MicroStrategy projects into Qlik Sense. You can import datasets with up to two million rows and 10+ columns.

All users attempting to the QlikView connector in MicroStrategy 2019 Update 2 must be assigned the Use Application Qlik privilege, directly or as part of a User Group or Security Role. This privilege can be found in the Client-Application-Qlik privilege group.

You must enable CORS (Cross-Origin Resource Sharing) settings on the Library server to use the connector.

Install the Connector

1. Download and extract the connector zip file. Rename the connector folder to QsMstrDatasetConnector.
2. From File Explorer, go to C: > Program Files > Common Files and create a new folder labeled Qlik.
3. Create a new folder labeled Custom Data inside the Qlik folder from step 2.
4. Place the extracted connector folder inside the new Custom Data folder.

Use the Connector

1. Open a new Qlik Sense app and click Data load editor from the navigation menu.

   

2. Click Create new connection > MicroStrategy Dataset Connector from the Data connections window.

   

3. Enter your API Server URL and environment credentials. Then click Next.

   Your REST API URL is your environment URL with /MicroStrategyLibrary/ added at the end.

   

4. Select the project and dataset you want to import.

   

5. Click Next.
6. Select the objects and filters you want to import.

   This feature is only available for cubes. If you choose to import a report, you will be asked to proceed to the Data Preview tab.

   

7. Click Next. You will be shown a preview of the first 50 rows of data.
8. Click Submit.

9. Click Load data to execute the connection script.

   

   Once the import is successful, you can begin using the selected MicroStrategy datasets in Qlik Sense.

You can update the dataset at any time by selecting the Load data button again to edit and re-run your connection script.