MicroStrategy Desktop

This section provides you with information on how to connect MicroStrategy Desktop to your Exasol database and how to connect from MicroStrategy Intelligence server to Exasol.

For addition information on MicroStrategy, refer to the MicroStrategy Learning Center.

Prerequisite

You need to have the following:

  • Exasol ODBC driver installed. You can download the driver from the Exasol downloads section.
  • Exasol database must be running.

Connect MicroStrategy Desktop to Exasol

Follow the steps below to establish a connection to an existing Exasol database:

  1. Open MicroStrategy Desktop and click New Dossier on the left panel.
  2. On the dossier window, click on New Data to add data to the dossier.
  3. From the list of data sources, search for EXASolution and select it.
  4. The Select Import Options window is displayed. Click on Select tables option if you want to import specific tables from your Exasol instance.
  5. The Import from Table window is displayed. If you have no data sources defined, then click on the plus icon next to DATA SOURCES.
  6. Do one of the following on the Data Source window:
    1. Select DSN-less Data Sources followed by filling out the appropriate information as seen in the screenshot below:
      • Make sure the database and version field is set to EXASolution.
      • Enter the host name along with the port number.
      • Enter the user name and password.
      • Enter a name for the data source.

    2. Select DSN Data Sources followed by filling out the appropriate information as seen in the screenshot below:
      • Make sure to select a previously created and tested DSN.
      • Make sure the version field is set to EXASolution.
      • Enter the user name and password.
      • Enter a name for the data source.

      The data source name will be displayed under DATA SOURCES in the Import from Table window.

      Note: If there is nothing listed in the DSN drop-down menu, then make sure you have created and tested a System DSN on your Windows operating system using the ODBC Data Source Administrator.

  7. Next, click on the data source name and select the schema you want to use followed by the tables.
  8. Click Finish when you are done.
  9. On the Data Access Mode window, you can choose to either Connect Live or Import as In-memory Dataset. We recommend you to select Connect Live.

You can now create dashboards using MicroStrategy Desktop.

 

Additional Information