MicroStrategy ONE

Connect to Databases

The process of connecting Freeform SQL or Query Builder to a database involves the following general steps:

To Configure a Database Instance

  1. In MicroStrategy Developer, create a database instance for the data source that the Freeform SQL or Query Builder report will run against.

    You must create a database instance before defining a Freeform SQL or Query Builder report. For more information on creating a database instance, see the Installation and Configuration Help.

  2. Right-click a project and select Project Configuration.
  3. Expand Database instances > SQL Data warehouses.
  4. Select the check box for the database instance.
  5. Click OK.

For details on how to create a Freeform SQL report to access a database, see Access and Analyze Multiple Data Sources with Freeform SQL.

For details on how to create a Query Builder report to access a database, see Access and Analyze Multiple Data Sources with Query Builder.