To Read Database Files

1. From the menus choose:

   File > Import Data > Database > New Query...

   (Or choose Edit Query to work on a saved query)

2. Select the data source.
3. If necessary (depending on the data source), select the database file and/or enter a login name, password, and other information.
4. Select the table(s) and fields. For OLE DB data sources (available only on Windows operating systems), you can only select one table.
5. Specify any relationships between your tables.
6. Optionally:

• Specify any selection criteria for your data.
• Add a prompt for user input to create a parameter query.
• Save your constructed query before running it.

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 on the remote server.

To add data sources in distributed analysis mode, see your system administrator.

Connection Pooling

If you access the same database source multiple times in the same session or job, you can improve performance with connection pooling.

1. In the last step of the wizard, paste the command syntax into a syntax window.
2. At the end of the quoted CONNECT string, add Pooling=true.