Connect BI Tools >
Connect from MicroStrategy Desktop

Connect from MicroStrategy Desktop¶

You can use MicroStrategy Desktop to analyze a MongoDB database through the MongoDB Connector for BI.

New in version 2.2.

Procedure¶

This tutorial is for version MicroStrategy Desktop version 10.11.

Windows
macOS

Prerequisites

Create a 64-bit system Data Source Name (DSN).
Install the MongoDB ODBC driver for Windows.
Make sure you have a running mongosqld instance. For instructions on starting and running mongosqld, see Launch BI Connector.

1

Start MicroStrategy.¶

Start the MicroStrategy Desktop application by double-clicking on the application icon.

2

3

Add new data.¶

Click the New Data button in the Datasets panel.
Click the Databases icon in the Data Sources window.
Select Select Tables from the popup window and click Next.

4

Add a data source.¶

Click the plus icon next to the Data Sources text in the upper left corner of the window.
Select the DSN Data Sources radio button.
Select your DSN from the DSN dropdown menu.
Select MongoDB BI Connector from the Version dropdown menu.
Enter your mongosqld username and password.

Note

If you are running mongosqld without authentication enabled, you still need to enter something in the username and password fields. Any string will do.
Give the data source a name.
Click OK.
Click on your newly created data source in the Data Sources panel. Your MongoDB databases should appear in the center panel.
Select the database you’d like to work with. The database’s collections should appear.
Drag the collections you’d like to work with to the right side panel.
Click the Finish button.

5

Build the visualization which suits your needs.¶

See the MicroStrategy documentation for more information about data visualizations.

6

Select a Data Access mode.¶

Select a data access mode that is appropriate for your situation.

Prerequisites

Download the MongoDB Authentication Plugin for JDBC. Save the .jar file in a folder called jdbc.
Download the MySQL Connector/J plugin. Save the .jar file in your jdbc folder.
Make sure you have a running mongosqld instance. For instructions on starting and running mongosqld, see Launch BI Connector.

Important

Use the 5.x version of Connector/J. The 8.x version is not compatible.

1

Start MicroStrategy.¶

Start the MicroStrategy Desktop application by double-clicking on the application icon.

2

Select New Dossier from the File menu to create a new dossier.¶

3

Add new data.¶

Click the New Data button in the Datasets panel.
Click the Databases icon in the Data Sources window.
Select Select Tables from the popup window and click Next.

4

Add a data source.¶

Click the plus icon next to the Data Sources text in the upper left corner of the window.
Check the checkbox marked “Show databases whose certified drivers were not found”.
Select MySQL from the Databases dropdown menu.
Click the Add driver link and navigate to the jdbc folder where your .jar files are stored. Select the MySQL .jar file.
Enter your mongosqld host name and port number.
Click the Show connection string link.
Check the checkbox marked “Edit connection string”.

Use the following connection string. Replace the placeholder values with the correct values.

copy

JDBC;DRIVER={com.mysql.jdbc.Driver};URL={jdbc:mysql://<hostname>:<port number>?useSSL=false&authenticationPlugins=org.mongodb.mongosql.auth.plugin.MongoSqlAuthenticationPlugin};MSTR_JDBC_JAR_FOLDER=<path-to-jar-files>;

Enter your mongosqld username and password.

Note

If you are running mongosqld without authentication enabled, you still need to enter something in the username and password fields. Any string will do.
Give the data source a name.
Click OK.
Click on your newly created data source in the Data Sources panel. Your MongoDB databases should appear in the center panel.
Select the database you’d like to work with. The database’s collections should appear.
Drag the collections you’d like to work with to the right side panel.
Click the Finish button.

6

Select a Data Access mode.¶

Select a data access mode that is appropriate for your situation.

7

Build the visualization which suits your needs.¶

See the MicroStrategy documentation for more information about data visualizations.