MicroStrategy ONE

Import Data from a Database by Selecting Tables

Starting in MicroStrategy ONE Update 12, you can use the improved data import experience to import data from a database by selecting tables.

This new data import experience feature was introduced in MicroStrategy 2021 Update 7.

You can import data from a database by selecting tables to retrieve data from the source. Importing data from a database requires a connection to a data source. You must create the connection before you begin importing.

  1. Create a dashboard or open an existing one.

  2. Choose Add Data > New Data.

    You can add data to an existing dataset by clicking More next to the dataset in the Datasets panel, choosing Edit Dataset, and clicking Add a new table.

  3. All available data source connections are listed in the Data Catalog. Select or search a data source connection and click it. Then choose or search the namespaces you want to connect. Multiple namespaces can be connected at the same time. You can disconnect the data source connection or change the connected namespace.

  4. Expand a namespace to view all the tables within it. Expand a table to view all the columns within it. To search for a table, type its name in the Search box. The tables are filtered as you type.

  5. Double-click or drag-and-drop tables to add them to the import. You can add tables from multiple data sources. The imported tables are then organized and grouped by their respective data sources in the table canvas. You can also drag-and-drop tables over the imported table to replace a previously imported table. If you want to add tables by typing a query, see Import Data from a Database by Typing a Query.

  6. If necessary, click Prepare Data to preview or modify your data.

  7. Save your data import:

    1. If you are on the Preview Data page, click Finish

    2. If you are on the New Dataset page, click Save.

  8. Click Connect Live to connect to a live database or Import as an In-memory dataset to import data directly into your dashboard. Connecting live is useful if you are working with a large amount of data, when importing it all into the dashboard may not be feasible. Importing data directly into your dashboard leads to a faster interaction with the data, but uses more RAM.