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