Configure CoreIQ and Create Tables

Open Tables → Create Table(s) from CoreIQ.

Configure the connection

CoreIQ settings are stored per OL DataIQ connection: base URL, host name, catalog, dataset server name, username, and password. Select Save & continue to persist settings before picking entries. OL DataIQ authenticates as needed and retries once after an expired token.

Create tables from entries

1. Search and select CoreIQ catalog entries.
2. Review every available layout variant.
3. Edit target column names, types, lengths, precision, nullability, keys, and defaults.
4. Choose an action for repeating OCCURS fields: flatten, skip, or JSON.
5. Optionally swap an alternate REDEFINES layout.
6. Select Create DDL and review the generated statements before execution.

On successful DDL execution, OL DataIQ persists field-to-column mappings. Entries without a record layout are blocked while other selected entries can proceed.

Renamed fields retain their source mapping; deleted fields have no mapping; user-added columns appear in DDL but not in mapping metadata.