MicroStrategy ONE

Connect to Starburst

Starburst, based on open source Trino, is a very performant SQL-based MPP query engine that stands out for many reasons:

  • Provides data consumers with a single point of secure access to all their data

  • Supports 40+ data sources that you can query interactively

  • Adopted by enterprises due to its superb performance in querying diverse data sources

Connect in MicroStrategy

  • Web
  • Workstation
  • Workstation Local Mode

  1. In MicroStrategy Web, click Create > Add External Data.

  2. Find and select the Starburst connector from the data source list.

  3. Select an import option and click Next.

  4. Next to Data Sources, click New Data Source to add a new connection.

  5. In the Connections dialog, complete the required fields.

  6. Copy the generated truststore file to your local machine. You must provide an absolute path to the truststore file.

  7. Click Save.

  8. Connect to the saved Starburst data source and select the tables you want to import.

  9. Prepare the data or click Finish. You can now use the saved cube to build dashboards.

Connect a Data Source

  1. In the Navigation pane, click , next to Datasets

  2. Choose an Environment, Project, and Data Import Cube.

  3. Find and select the Starburst connector from the data source list.

  4. Select an import option and click Next.

  5. Next to Data Sources, click New Data Source to add a new connection.

  6. In the Connections dialog, complete the required fields. Use the JDBC URL and token information retrieved in the Generate a New Token section above.

  7. Click Save.

  8. Connect to the saved Databricks data source and select the tables you want to import.

  9. Prepare the data or click Finish. You can now use the saved cube to build dashboards.

Create a Data Source

  1. Connect to an environment.

  2. In the Navigation pane, click , next to Data Sources.

  3. Find and select the Starburst connector from the data source list.

  4. Create a new Starburst connection.

  5. Complete the required fields.

  6. Upload the truststore certification and enable TLS encryption, if necessary.

  7. Save the data source. Use this data source in MicroStrategy Web or Workstation to create datasets and dashboards.

  1. In the Navigation pane, click , next to dashboards.

  2. In the Datasets panel, click New Data.

  3. Find and select the Starburst connector from the data source list.

  4. Select an import option and click Next.

  5. Next to Data Sources, click New Data Source to add a new connection.

  6. Complete the required fields.

  7. Copy the generated truststore file to your local machine. You must provide an absolute path to the truststore file.

  8. Click Save.

  9. Connect to the saved Starburst data source and select the tables you want to import.

  10. Prepare the data or click Finish. You can now use the saved cube to build dashboards.