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.

Login to the OvalEdge application
In the left menu, click on the Administration module name, the sub-modules associated with the Administration are displayed.
Click on the Crawler sub-module name, the Crawler Information page is displayed.
In the Crawler Information page, click on the . The Manage Connection with Search Connector pop-up window is displayed.
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.

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

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.
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