Start Today

← Documentation

OpenLegacy Hub Integration

OpenLegacy Hub Integration

OL DataIQ integrates with OpenLegacy Hub to expose database queries and tables as APIs and data-movement projects.

Configuration

Hub connectivity is server configuration — gateway URL, per-service backend URLs, and API key. It is not entered in the browser. If Hub actions are disabled, ask your administrator to verify the deployment variables.

When Hub is not configured, OL DataIQ shows an information dialog with registration options.

Available actions (Query Console)

ActionPurpose
Create API…Turn a SELECT query into a Hub query asset
Create CRUD…Create SELECT/INSERT/UPDATE/DELETE assets for one table — see [[product:ol-dataiq/create-hub-crud-assets|Create Hub CRUD Assets]]
Export Dataset → Create Hub ETLETL flow from source query to target connection
Export Dataset → Create Hub Db PollerPoll source DB for changes (Oracle, SQL Server, DB2, DB400)

When creating APIs, you can convert WHERE literals to ? placeholders. OL DataIQ warns if the query contains hardcoded filter values.

See child topics for step-by-step guides.

Create Hub APIs, CRUD assets, ETL flows, and DB Poller projects from query results.

Read more