Database Connections

Use the Connections page to create and manage the databases available in OL DataIQ.

Add a connection

1. Select Add Connection.
2. Enter a descriptive connection name.
3. Select the database type.
4. Enter the JDBC URL, username, password, and optional default schema.
5. Confirm the driver class name; OL DataIQ populates it based on the selected type.
6. Select Test Connection, then select Create.

Organize connections

• Switch between card and list view with the controls in the upper-right.
• Search by name, database type, or description. JDBC URL, username, and schema are stored encrypted and cannot be searched.
• Star frequently used connections to keep them at the top.
• Use Test, Edit, Clone, Delete, or open a connection directly in Query Console.

Import and export

Select multiple connections to export them as JSON, or import a previously exported JSON file. Duplicate connection names are skipped during import.

Security: Connection exports can include passwords. Store exported files securely and do not share them through untrusted channels.