MicroStrategy connection

Last updated: May 30, 2025
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)

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

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