Microstrategy Workstation

MicroStrategy Workstation makes it easy to build compelling visualizations and interactive dossiers in a matter of minutes and then easily share those dossiers with others.

Supported Versions

Microstrategy Workstation 2021 Update 9 and later.

Supported Authentication Methods

• Use a Dremio username and password.
• Use a Dremio username and a personal access token (PAT) that you obtained from Dremio.

Prerequisites

• Install the latest version of Dremio's legacy JDBC driver:
  1. Download the driver.
  2. Move the .jar file to one of these locations:
     • On Windows: C:\Program Files (x86)\Common Files\MicroStrategy\JDBC
     • On Linux: /opt/mstr/MicroStrategy/install/JDBC
• If you want to authenticate your connection to Dremio by using a PAT, see Creating a PAT for the steps to obtain one.
• In Microstrategy Workstation, select Help > Enable New Data Import Experience.

Creating an Environment-level Integration with Dremio

You can create an integration with Dremio that can be used in more than one dossier.

1. In Microstrategy Workstation, connect to the environment that you plan to use.
2. Under Administration on the left side of the screen, click the + sign to the right of Data Sources.
3. In the Data Source Types dialog, click Dremio.
4. In the Add Data Source - Dremio dialog, follow these steps:
   1. In the Name field, specify a name for the integration.
   2. (Optional) In the Description field, describe the integration.
   3. In the Database Version field, ensure that Dremio is selected.
   4. In the Default Database Connection field, either select an existing connection to a Dremio cluster, or select Add New Database Connection.
5. If you selected Add New Database Connection, follow these steps in the Create New Database Connection dialog:
   1. In the Name field, specify a name for the connection.
   2. In the Basic section, follow these steps:
      1. In the Host Name field, specify the IP address or hostname of the coordinator node of the Dremio cluster that you want to use this connection with.
      2. In the Port Number field, specify the port number to use. The default port number is 31010.
      3. In the Authentication Mode field, ensure that Standard is selected.
      4. In the Default Database Login field, either select an existing set of authentication credentials for the Dremio Cluster, or click Add New Database Login to add a new set.
      5. If you clicked Add New Database Login in the previous step, specify the name to associate with the credentials, and then follow either of these steps:
         • Specify the username and password of the Dremio account to use.
         • Specify the username of the Dremio account to use and a PAT, which you can paste into the Password field.
   3. (Optional) In the Advanced section, set additional properties for Microstrategy Workstation to use when connecting to Dremio. See Optional Advanced JDBC Driver Properties for a list of the properties that you can use.
   4. (Optional) In the Security section, toggle on the Use TLS Encryption switch if the Dremio cluster is configured to encrypt communication between it and JDBC clients. For the steps to set up encryption, see Encryption for JDBC Clients and Power BI Clients That Use the Legacy ODBC Driver.
   5. (Optional) In the Properties section, specify non-default values for various properties of the connection.
   6. Click Save.
6. In the Add Data Source - Dremio dialog, follow these steps:
   1. (Optional) Click Test to find out whether Microstrategy Workstation can connect to the Dremio cluster by using the database connection. If the test fails, ensure that the connection is configured correctly.
   2. Click Save.

You can now select this database connection when you create dossiers.