OL DataIQ Documentation

OL DataIQ is a database console for querying, exploring schemas, importing legacy CoreIQ layouts, and connecting to OpenLegacy Hub.

Browse help by task:

• Getting Started — access, demo database, first connection
• Database Connections — create, test, import/export
• Query Console — SQL, results, AI assistant, saved queries
• Database Schema — metadata, DDL, stored procedures
• Import Legacy Schema — CoreIQ catalog to SQL tables
• Data Export and Import — connections, datasets, schema
• OpenLegacy Hub Integration — APIs, CRUD, ETL, DB Poller
• CoreIQ Integration — mappings and batch prerequisites
• OL DataIQ Batch — bulk CoreIQ imports and dashboard
• Administration and Security — timeouts, AI, auth
• Supported Databases — drivers and JDBC patterns
• Troubleshooting — common issues

• Getting Started
• Database Connections
• Query Console
• SQL Autocomplete
• Edit Results and Generate DML
• Saved Queries
• AI Query Assistant
• Query History and Result Tools
• Database Schema
• Stored Procedures
• Create, Alter, and Visualize Tables
• Data Export and Import
• OpenLegacy Hub Integration
• Create Hub ETL Flows
• Create Hub CRUD Assets
• Create Hub DB Pollers
• CoreIQ Integration
• Import Legacy Schema
• Configure CoreIQ and Create Tables
• Manage CoreIQ Mappings
• Export or Trigger CoreIQ Batch Jobs
• OL DataIQ Batch
• ODZ Packs and Service API
• Batch Upserts and Performance Tuning
• Administration and Security
• Supported Databases
• Troubleshooting