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.

If your database has an ODBC driver, AQT will be able to connect to it and most of AQT's functionality will be available. Your PC will have an ODBC driver for some databases. For others, you will need to install the ODBC driver or database client. Some useful links are listed here: querytool.com/links.html

In addition, the system-table query feature of Advanced Query Tool has been configured for the following databases:

• Oracle v7, v8, 9i, 10g, 11g, 12c, 18c, 19c, 21c
• DB2 for LUW v2, v5, v6, v7, v8, v9, v10, v11
• DB2 for z/OS v4, v5, v6, v7, v8, v9, v10, v11, v12, v13
• DB2 for i
• Sybase SQL Anywhere
• Sybase IQ
• Sybase Adaptive Server Enterprise v11, v12, v15, v16
• Informix
• Microsoft SQL Server v6.5, v7, 2000, 2005, 2008, 2012, 2014, 2016, 2017
• Microsoft Azure
• MySQL v3, v4, v5, v8
• Pervasive.SQL v8
• SQLBase
• PostgreSQL
• Firebird / Interbase
• MaxDB / SAPDB
• Netezza
• HP Nonstop SQL/MX and SQL/MP
• Progress
• Redbrick
• Exasolution
• Teradata
• SQLite v3
• Ingres
• MariaDB

The system-table query feature can be easily be added for 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. AQT can also sometimes open an mdb file that fails to open successfully in MS Access.
• 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. This is described in the section Connecting to Text and CSV Files.

• Excel Files. AQT can open an Excel file. This provides a way of viewing Excel files, even if you don't have MS Excel installed on your machine. See the section Connecting to Excel for more on this.