If you use other databases or data sources, refer to the database-specific documentation for information on required settings. Standard settings are supported by MicroStrategy for most relational databases.
A Microsoft Excel file can be used as a data source in MicroStrategy. The information below explains how to prepare an Excel file for use with MicroStrategy and how to connect to the Excel file.
This data can be used as part of a MicroStrategy project in various ways. For example, you can integrate the Excel data in your project using tools such as Architect, as described in the Project Design Help. You can also use Freeform SQL and Query Builder to access your Excel data, as described in the Advanced Reporting Help.
To use an Excel file as a data source, you must create and store the data in the Excel file so that it can be recognized in MicroStrategy as a set of tables that contain valid data. Follow the below instructions to create a table with valid data in an Excel file:
To use an Excel file as a data source, you can create a data source name (DSN) for the Excel file. This DSN can be used by a database instance in MicroStrategy to connect to the Excel file. For information on creating a database instance, see Creating a database instance.
As an alternative, you can use Data Import to quickly include Excel data in your MicroStrategy project. Steps to use Data Import to import data and begin your analysis is included in the MicroStrategy Web Help.
A text file can be used as a data source in MicroStrategy. You can use Data Import to quickly include data from text files in your MicroStrategy project. Steps to use Data Import to import data and begin your analysis is included in the MicroStrategy Web Help.