MicroStrategy connection

To access your data in MicroStrategy, create a connection asset for it.

MicroStrategy is a reporting and data analytics platform.

Supported versions

MicroStrategy 11.3.6 (2021 Update 6)

Create a connection to MicroStrategy

To create the connection asset, you need the following connection details:

  • MicroStrategy Library URL address: The URL used to access the MicroStrategy Library. For example, http://microstrategy.server.com:8080/MicroStrategyLibrary.
  • Username: The username used to connect to the MicroStrategy server. This user must have administrator privileges.
  • Password: The password associated with the specified username.
  • SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Other properties

  • Extracted projects: A list of projects to extract. To identify the names of projects to extract, specify regular expressions and separate them by semicolons. To extract all projects, leave the field empty. Example value: Sales.*;Human Resources Project.
  • Excluded projects: A list of projects to exclude from extraction. To identify the names of the projects to exclude from extraction, specify regular expressions and separate them by semicolons. Example value: Sales.*;Human Resources Project.

Choose the method for creating a connection based on where you are in the platform

In a project
Click Assets > New asset > Prepare data > Connect to a data source. See Adding a connection to a project.

In a catalog
Click Add to catalog > Connection. See Adding a connection asset to a catalog.

In the Platform assets catalog
Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use the MicroStrategy connection in the following workspaces and tools:

Projects

Metadata import (discovery) and metadata import (lineage) (IBM Knowledge Catalog) Advanced metadata import must be enabled. For lineage imports, a MANTA Automated Data Lineage license key must be installed. See Installed features and license requirements and Enabling lineage import.

Catalogs

  • Platform assets catalog
  • Other catalogs (IBM Knowledge Catalog)

Restrictions

  • You can connect only to the on-premises MicroStrategy servers.
  • You can use this connection only for source data. You cannot write to data or export data with this connection.

Learn more

MicroStrategy documentation

Parent topic: Supported connections