MicroStrategy #

MicroStrategy is optimized for cloud and on-premises deployments. It provides modern analytics on an open, comprehensive enterprise platform, and allows users to overlay actionable enterprise data on popular business applications to help users make smarter, faster decisions.

MicroStrategy’s SQL Engine pushes down metric calculations and querying logic to the cluster. You can connect to Starburst Galaxy, Starburst Enterprise platform (SEP), and Trino. This allows users to combine the scalability and processing power of Starburst clusters with the reporting features of MicroStrategy.

Requirements #

You must meet the following requirements to connect to MicroStrategy’s Starburst data gateway.

MicroStrategy

• MicroStrategy Workstation 11.3.7 or newer, or MicroStrategy Cloud.
• Credentials of a user with write access.

Starburst/Trino

• Starburst Galaxy.
• Starburst Enterprise 354-e STS or newer.
• Trino 351 or newer.

Connection #

You can find instructions for connecting to MicroStrategy Workstation and MicroStrategy Cloud (sometimes referred to as MicroStrategy Web) in the MicroStrategy documentation.

When connecting to MicroStrategy:

• You must specify a catalog and a schema during the initial configuration so MicroStrategy has a location to write temporary tables to in support of its interactions with Starburst Galaxy, Starburst Enterprise, and Trino. The user’s access is not limited to the catalog and schema specified during the initial configuration.
• Ensure that the catalog and schema specified during the initial configuration support write ability.