Features

Multiple DBMS Support PDF Print E-mail

The one product – QiD – works with all the following databases:

Primary Commercial

  • DB2
  • Oracle
  • SQL Server
  • Teradata

Secondary Commercial

  • MS-Access
  • MS-Excel
  • Text files

Primary Open Source

  • MySQL
  • PostgreSQL
  • Firebird

Other Databases

The following databases are not yet supported by QiD but are candidates for future support:

  • Informix
  • SAS
  • Sybase
  • Tandem Nonstop SQL

Contact This e-mail address is being protected from spambots, you need JavaScript enabled to view it to discuss adding support for the DBMS that you require.

Connections

Connections can be made via ODBC or ADO. All the features of QiD work equally across all supported databases, except in a small number of cases where a database does not itself provide some facility.

The queries in a given project operate on the specified project database connection by default. QiD also allows queries to be issued against different database connections – even different DBMSs – in the one project or job. Run some queries on Oracle, switch to DB2, export the results to Access, switch to Access and produce the final results.