Database types that AQT accesses

Advanced Query Tool can access any database that can be set up as an ODBC data source. This covers most databases on the market.

For all ODBC databases most of AQT's functionality is available. In addition, the system-table query feature of Advanced Query Tool has been configured for the following databases:

• Oracle v7, v8, 9i, 10g
• DB2/UDB v2, v5, v6, v7, v8, v9
• DB2/390 v4, v5, v6, v7, v8, v9
• DB2/400
• Sybase SQL Anywhere
• Sybase IQ
• Sybase Adaptive Server Enterprise v11, v12, v15
• Informix
• Microsoft SQL Server v6.5, v7, 2000, 2005
• MySQL v3, v4, v5
• Pervasive.SQL v8
• SQLBase
• PostgreSQL
• Firebird / Interbase
• MaxDB / SAPDB
• Netezza
• HP Nonstop SQL/MX
• Progress
• Redbrick

The system-table query feature can be easily be added to other databases in the future by Cardett (this is controlled by config files so can be done with minimal code changes).

Database Types and Config Files contains more about the config files.

Other databases that AQT has been used extensively against are:

• MS Access. This can be useful if you've been given an mdb but don't have MS Access on your machine. Or if there is some problem with your mdb and Access is having trouble opening it.
• CSV Files (*) (eg. files with "comma-separated variables"). Once an ODBC driver has been set up for CSV files, AQT provides a very simple and easy way to see the content of CSVs and run reports against them. In our experience, using AQT to do this is a lot faster than importing the CSVs into Excel and reporting from there.

  To access CSV files, you must first set up an ODBC "Text Datasource" pointing to the directory containing the CSV files.