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
- 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.
- Right-click a project and select Project Configuration.
- Expand Database instances > SQL Data warehouses.
- Select the check box for the database instance.
- 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.