Import Legacy Schema

Import Legacy Schema in the top navigation is the primary way to turn CoreIQ catalog layouts into SQL tables.

Prerequisites

• At least one CoreIQ connection under System Settings → CoreIQ Connections
• A target database connection where tables will be created

Steps

1. Choose source — pick a CoreIQ connection and catalog.
2. Browse datasets — select a dataset; use Open in CoreIQ to inspect the source layout.
3. Map columns — configure record types, OCCURS handling (flatten, skip, or JSON), REDEFINES, target connection, and table name.
4. Review DDL — generate CREATE TABLE statements, review, and execute.

Saved mappings are used by Show mappings, Export batch settings…, and Trigger batch job… in the Query Console.

Hub-sourced connections

CoreIQ settings cannot be persisted on Hub-managed database connections. Use a locally managed target connection.