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 Features
-
AI
AI Query AssistantAsk for a query in plain language. The assistant writes SQL from the live schema, and you can ask it why a query or a stored procedure failed.
-
DATABASE
Import and export test data and schemaCopy table structures and query results from one connection to another, share connection definitions as JSON, and download results as CSV.
-
BATCH
Import read metrics and tuning leversSee why a batch import was slow: throughput, where the time went, page latency, and how page cost changes as the scan advances, plus the settings that move those numbers.
-
COBOL
IMS schema migration from CoreIQBrowse the CoreIQ IMS-DB catalog, turn an approved COBOL segment layout into CREATE TABLE statements, and load the segment into those tables with a batch job.
-
DATABASE
MongoDB connections, explorer and consoleConnect to MongoDB beside your SQL databases. Browse databases, collections, indexes, and a sampled field list, and run find, aggregate, and write operations from a console.
-
AS/400
Multi-database connectionsKeep DB2, DB400, MySQL, PostgreSQL, Oracle, SQL Server, IMS DB, and generic JDBC connections in one catalog. Test them, star them, and import or export the set.
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.