CoreIQ Integration

CoreIQ integration lets OL DataIQ browse legacy-data catalogs, generate target-table DDL from record layouts, and persist field-to-column mappings for OL DataIQ Batch.

Primary workflow: Import Legacy Schema

Use Import Legacy Schema in the top navigation (see [[product:ol-dataiq/import-legacy-schema|Import Legacy Schema]]) to:

1. Choose a CoreIQ connection and catalog (registered under System Settings → CoreIQ Connections)
2. Browse datasets in the catalog
3. Map columns — record types, OCCURS, REDEFINES — and pick a target database connection
4. Review and execute CREATE TABLE DDL; mappings are saved automatically

Query Console shortcuts

From the Tables menu in Query Console you can also:

• Create Table(s) from CoreIQ… — wizard on the current connection
• Show mappings / Export batch settings… / Trigger batch job… — after mappings exist

Mapping-dependent actions appear only after at least one mapping has been created.

Hub-sourced connections

CoreIQ settings cannot be written back to Hub-managed connections. Use a locally managed target connection or configure CoreIQ through System Settings.