MicroStrategy

Connectivity Summary

MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. OvalEdge MicroStrategy's BI and analytics platform helps enterprises build and deploy cloud-based, hyper intelligent apps, where you can transform your business.

Connector Capabilities

The connector capabilities are shown below:

Crawling

Please see this article Crawling Data for more details on crawling.  Supported objects and data types for Crawling are:

  • Reports
  • Report Columns
  • Dossiers
  • Sheets
  • Visuals

Profiling

There is no profiling as we are not supporting profiling for report frameworks.

Lineage Building

Lineage Entities Details
Report Lineage Supported
Report Column Lineage Supported

Pre-requisites

To use the connector, the following need to be available:

  • Connection details as specified in the following section should be available.
  • Service account with read privileges.

Connection Details

To connect to the MicroStrategy database using the OvalEdge application, complete the following steps.

  1. Login to the OvalEdge application
  2. In the left menu, click on the Administration module name, the sub-modules associated with the Administration are displayed.
  3. Click on the Crawler sub-module name, the Crawler Information page is displayed.
  4. In the Crawler Information page, click on the . The Manage Connection with Search Connector pop-up window is displayed.
  5. In the Manage Connection pop-up window, select the connection type as MicroStrategy. The Manage Connection with MicroStrategy specific details pop-up window is displayed.
    microstrategy
  6. The following are the field attributes required for the connection of MicroStrategy

    Configuration

    Default/Sample value* 

    Description

    Connection Type

    Microstrategy

    Select the database type from the list 

    Connection Name

    Requires input

    Reference name for identification while crawling

    Host Name/IP Address

    Requires input

    Microstrategy IP address with port num

    Username

    Requires input

    Username for Microstrategy Server account

    Password

    Requires input

    Password for Microstrategy Server account

    Connection string

    jdbc:Microstrategy://{servername}:{portnumber}/{database}

    Microstrategy connection string

    Iserver

    -

    Iserver is the Intelligence server that is linked for MSTR.

    MetaDB URL

    Requires input

    JDBC URL for MSTR Database

    Database Name

    Requires input

    Database Name

    MetaDatabase UserName

    Requires input

    Database username

    MetaDatabase Password

    Requires input

    Database Password

    *- Requires Client-specific input
  7. Once after entering the connection details in the required fields, click on the button the entered connection details are validated the Save and Save & Configure buttons are enabled.
  8. Click on the button to establish the connection or the user can also directly click on the button to establish the connection and configure the connection settings. Here when you click on the Save & Configure button, the Connection Settings pop-up window is displayed. Where you can configure the connection settings for the selected Connector.
    Note: The Save & Configure button is displayed only for the Connectors for which the settings configuration is required.

Once connectivity is established, additional configurations for Crawling and Profiling can be specified.

Property

Details

Crawler Options

Reports

To fetch only reports(By default)

Report Columns

To fetch report column(Need to check while crawling)

Profile Settings

No Profile Options

Crawler Rules

Include Report Regex

Includes only report that match regex with the report name

Exclude Report Regex

Excludes reports that match regex with the report name


Copyright © 2019, OvalEdge LLC, Peachtree Corners GA USA