Supported Databases

OL DataIQ includes support for PostgreSQL, MySQL, IBM DB2, IBM AS/400 (DB400), Oracle, Microsoft SQL Server, IMS DB, and generic JDBC connections.

Common JDBC URL patterns

Database	Example URL
PostgreSQL	jdbc:postgresql://host:5432/database
MySQL	jdbc:mysql://host:3306/database
DB2	jdbc:db2://host:50000/database
AS/400	jdbc:as400://host/database
Oracle	jdbc:oracle:thin:@host:1521:SID
SQL Server	jdbc:sqlserver://host:1433;databaseName=database
IMS DB	jdbc:ims://mainframe:5555/database

Generic JDBC

For another database, place its driver JAR in ~/.dataiq/jars/, select Generic JDBC, provide the driver class name, and restart OL DataIQ. Some drivers, including DB2 drivers, may also require license JARs in the same directory.