IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Microsoft PowerShell Qlik Sense Desktop »
Elastic Docs ›Elasticsearch Guide [6.6] ›SQL Access ›SQL Client Applications

MicroStrategy Desktop

edit

MicroStrategy Desktop

edit

This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.

You can use the Elasticsearch ODBC driver to access Elasticsearch data from MicroStrategy Desktop.

Prerequisites

edit

Data loading

edit

To use the Elasticsearch SQL ODBC Driver to load data into MicroStrategy Desktop perform the following steps in sequence.

  1. Create a New Dossier

    Once the application is launched, you’ll first need to create a New Dossier:

    apps microstrat newdossier

  2. New Data

    To import into the New Dossier just opened, press on the New Data button in the DATASETS column:

    apps microstrat newdata

  3. Access data from Tables

    This opens a new window that allows to choose the source to load data from. Click on the Databases icon:

    apps microstrat databases

  4. New Data Source

    In the newly opened Import from Table - Select window, click on the + button to the right of DATA SOURCES item:

    apps microstrat newds

  5. Data Source

    In the Data Source window, tick the radio button for DSN Data Sources. In the DSN drop-down box, choose the name of the DSN that you have previously configured. For the Version, chose Generic DBMS.

    Input a user name and password in the provided fields. Note that the application requires them irrespective of the fact that they might already be part of the previously configured DSN and the new input will take precedence over those.

    Finally, give a name to the application-specific data source you’re just configuring:

    apps microstrat dsn

  6. Select Import Options

    Choosing an import methodology follows. You can pick any of the options; we’ll exemplify the Select Tables option:

    apps microstrat tables

  7. Import from Table - Select

    The data source you’ve named two steps before is now listed in the DATA SOURCES column. Clicking on its name triggers the application to query the Elasticsearch instance configured in the DSN and list the tables available within:

    apps microstrat loadtable

  8. Data Access Mode

    Choose a table to load data from and press the Finish button. When doing so, the application offers to choose a loading methdology. You can choose whichever, we’ll exemplify the Connect Live way:

    apps microstrat live

  9. Visualize the data

    From the DATASETS column you can choose what table columns (or index fields) to visualize:

    apps microstrat visualize

« Microsoft PowerShell Qlik Sense Desktop »