MicroStrategy ONE
Best Practices for Importing Data from a Database
Consider the following best practices for importing data from a database into MicroStrategy Web:
- If you connect to data source by creating DSNs using the Microsoft ODBC Data Source Administrator, create system DSNs so that MicroStrategy interfaces recognize them. DSNs are used to establish communication between MicroStrategy Web and your database, for data sources that require a DSN to connect. See Create a Database Connection and How to Manage Database Connections for information.
- When importing data by entering a Freeform query, if you enter a multi-pass SQL statement, the data returned will be from the last SELECT pass that you typed in your Freeform script.
- When importing data by typing a Freeform query, ensure that the column names in your source database do not contain spaces or special characters other than underscore (_).