Products / OL DataIQ
OL DataIQ
One workspace for DB2, DB2 for i, IMS DB, Oracle, SQL Server, PostgreSQL, MySQL, and MongoDB: query with AI help, copy test data, migrate VSAM and IMS into SQL, and turn queries into APIs.
OL DataIQ is a browser-based workspace for the databases enterprises actually run: DB2 on z/OS, DB2 for i, and IMS DB alongside Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, and any JDBC source. Teams connect once, then query and explore schemas in one place, copy schemas and test data between environments, migrate mainframe VSAM and IMS data into relational tables, and turn working queries into APIs and data pipelines in OL Integration.
Key capabilities
-
AI
AI Query AssistantNatural-language chat that generates and refines SQL from live schema context and can explain query or stored-procedure errors.
-
DATABASE
Import and export test data and schemaMove schemas and query result datasets between connections, export/import connection configs, and download CSV, so teams can build and refresh realistic test environments quickly.
-
BATCH
Import read metrics and tuning leversPer-run read metrics for a batch import (throughput, where the time went, page latency and cost per page as the scan advances) with Markdown and self-contained HTML reports, and the settings that move those numbers.
-
COBOL
IMS schema migration from CoreIQBrowse the CoreIQ IMS-DB catalog, turn approved COBOL segment layouts into CREATE TABLE DDL with copybook-aware column mapping, and load segment data into the target with a batch job.
-
DATABASE
MongoDB connections, explorer and consoleConnect to MongoDB alongside SQL databases, browse databases, collections, indexes and a sampled field schema, and run find, aggregate and write operations from a query console.
-
AS/400
Multi-database connectionsConnect to DB2, DB400/AS/400, MySQL, PostgreSQL, Oracle, SQL Server, IMS DB, and generic JDBC databases with persistent, testable connection management.
What it enables
OL DataIQ is a browser-based workspace for the databases enterprises actually run: DB2 on z/OS, DB2 for i, and IMS DB alongside Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, and any JDBC source. Teams connect once, then query and explore schemas in one place, copy schemas and test data between environments, migrate mainframe VSAM and IMS data into relational tables, and turn working queries into APIs and data pipelines in OL Integration.
Part of the OpenLegacy platform
Run it from one governed plane
Govern, deploy, and operate this product with the rest of the suite — managed or on-prem.