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)
| Action | Purpose |
|---|---|
| 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 ETL | ETL flow from source query to target connection |
| Export Dataset → Create Hub Db Poller | Poll 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.