Strategy ONE
Best Practices for Importing Data from a Database
Consider the following best practices for importing data from a database into Strategy Workstation:
- If you connect to data source by creating DSNs using the Microsoft ODBC Data Source Administrator, create system DSNs so that Strategy interfaces recognize them. DSNs are used to establish communication between Strategy Workstation 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 (_).