Legacy Data Synchronization
Enable near-real-time or scheduled replication without custom CDC/polling frameworks on the host—combining CoreIQ CDC, Z Gateway hosting, and DataIQ Hub poller/ETL/migration.
Challenges
- Keeping VSAM and modern SQL or event planes aligned requires custom scanners, extract jobs, and host CDC frameworks.
- Schema mapping from VSAM copybooks to SQL tables is tracked in spreadsheets that drift from live layouts.
- Write paths to the host are either fully open or blocked, with no gated RACF-authenticated control.
Benefits
- Stream VSAM insert, update, and delete changes as structured Kafka or webhook events decoded with approved catalog layouts.
- Poll Oracle, SQL Server, DB2, and DB400 and run Hub ETL between connections without custom polling frameworks.
- Generate VSAM-to-SQL DDL with field-to-column lineage and load records through repeatable Spring Batch jobs.
Keep legacy and modern data planes aligned with VSAM CDC (hosted on Z Gateway / managed in CoreIQ), Hub DB Poller projects, ETL from DataIQ, and VSAM→SQL schema/batch migration paths.
Products
- OL CoreIQ — Dataset CDC configuration and management
- OL Z Gateway — CDC hosting, status/teardown, and secured write surface
- OL DataIQ — Hub ETL, DB Poller, VSAM schema migration, and batch data loads
What it covers
- Change data capture for VSAM sources
- Database polling for Oracle, SQL Server, DB2, and DB400
- ETL flows between connections via OL Hub
- Schema and batch migration from VSAM to SQL targets