Supported Database Connection Types

QIE leverages the Java Database Connectivity (JDBC) framework for establishing connections to external databases. QIE can connect to any database management system (DBMS) for which a JDBC type 2 driver exists. JDBC type 2 drivers exist for almost all major DBMS systems. QIE ships with the following pre-installed JDBC drivers:

JDBC Driver	Driver Classname	Connection URL
MariaDB	org.mariadb.jdbc.Driver	jdbc:mariadb://<host>:3306/<schema>
Microsoft SQL Server	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://<host>:1433;databaseName=<schema>
PostgreSQL	org.postgresql.Driver	jdbc:postgresql://<host>:5432/<schema>

MSSQL named instances

To connect to a SQL Server named instance instead of a default instance, put both the server name and instance name in the Host field separated by a backslash, for example localhost\namedInstance. The Connection URL becomes jdbc:sqlserver://hostname\instancename:1433;databaseName=<schema>. If the connection fails with the port included, use the Manually set the connection URL option to drop the port so the JDBC driver discovers the instance's actual port: jdbc:sqlserver://hostname\instancename;databaseName=<schema>.

In addition to the pre-installed JDBC drivers, The QIE Database Connections page is pre-configured to work with the following commonly-used JDBC drivers:

JDBC Driver	Driver Classname	Connection URL
H2	org.h2.Driver	jdbc:h2:<path to folder and name of H2 database >
MySQL	com.mysql.jdbc.Driver	jdbc:mysql://<host>:3306/<schema>
Oracle	oracle.jdbc.driver.OracleDriver	jdbc:oracle:thin:@<host>:1521:<schema>

Instructions for adding the above commonly used JDBC drivers as well as any other JDBC type 2 drivers can be found on the Database Connections page under the Connection Information Section or by selecting Help -> How to Add JDBC Drivers to QIE from the main menu.