User Guide

23
Data Files
Reading Data
base Files
You can read
data from any database format for which you have a database driver. In
local analysis mode, the necessary drivers must be installed on your local computer.
In distributed analysis mode (available with the server version), the drivers must be
installed o
n the remote server. For more information, see “Distributed Analysis
Mode” in Chapter 4 on p. 63.
To Read Dat
abase Files
E From the m
enus choose:
File
Open Database
New Query...
E
Select the data source.
E Depending on the data source, you may need to select the database file and/or enter a
login name, password, and other information.
E Select the table(s) and fields.
E Specify any relationships between your tables.
Optionally, you can:
 Specify any selection criteria for your data.
 Add a prompt for user input to create a parameter query.
 Save the query you have constructed before running it.
To Edit Saved Database Queries
E From the menus choose:
File
Open Database
Edit Query...
E
Select the query file (*.spq) that you want to edit.