Connect to Databases, Excel Files, and Text Files

With Freeform SQL and Query Builder, you can access multiple data sources in the same project and use MicroStrategy reporting features to analyze your data. Freeform SQL and Query Builder also enable you to access Excel and text files as data sources.

For information on using the Freeform SQL Editor to report on third-party web services, see Reporting on Third-Party Web Services with XQuery.

Before you can analyze data from databases, Excel files, or text files with Freeform SQL and Query Builder, you must connect to your desired data source. The sections listed below describe the steps required to connect Freeform SQL and Query Builder to your desired data source:

• Connect to Databases
• Connect to Excel Files
• Connect to Text Files