The following JDBC database drivers are included with iWay DQC Manager. You can add other drivers in the DB Drivers preferences.
To connect to one of these database types, right-click the Databases node in the DQC Explorer, and click New > Database Connection. Clicking a driver name from the drop-down list populates the URL string field with a template for connecting to the specified database type.
After the database connection has been made, the database is shown in the Databases node in the DQC Explorer. Clicking the table names shows metadata for each table in the Properties panel.
To view the results of an SQL query on a table, right-click a table and click Open in SQL editor. A default query is shown, listing all table entries (grouped in batches if the number of rows is large). To change the query, edit the query text and click the Execute button. To retrieve more results from the query, click Next batch or Read rest (to show all results).
| iWay Software |