Infinium ran Catholic Healthcare Trust's HR, payroll and core financials (on IBM i). Syntra ETL archived ten years of Infinium history into a consolidated Oracle Autonomous (ATP) database, with Oracle APEX and Microsoft Power BI reporting, so payroll, GL and HR records stay available for legal, audit and insurance queries long after the system was switched off.
Infinium held some of CHT's longest-retention records — payroll, general ledger and HR — the kind that must be produced years later for tax, audit, legal and insurance requests.
Infinium (an Infor ERP/HRMS platform, commonly run on IBM i) was CHT's system of record for HR, payroll and core financials. Payroll registers, W-2 data, GL detail and employee service history carry multi-year retention obligations under IRS, wage-and-hour, SOX and state rules — exactly what auditors, attorneys and insurers request.
Rather than keep Infinium and its IBM i infrastructure running just to answer occasional requests, CHT archived ten years of Infinium data into the new Oracle ATP archive — part of a five-system effort totalling approximately 8 TB of data and around 150,000 attachments.
Retiring Infinium came with real data-engineering challenges.
The source systems were out of vendor support — raising security, compliance and continuity risk. Archiving and decommissioning removed that risk.
Minimal documentation survived and few functional users remained who understood the applications, so we reverse-engineered the data model and validated it with the business.
Infinium ran on IBM i (AS/400) with no modern API, so we connected directly to the underlying database to extract the full history.
Some applications hadn't been updated since 2007/2008 — dated formats, encodings and structures that required careful handling.
With some systems holding over 5,000 tables, we profiled the schema to isolate the relatively small set that actually held the records worth keeping.
Ten years of records, consolidated into the Oracle ATP archive.
Payroll registers, earnings, deductions and year-end/W-2 data.
GL detail, journals and financial history.
AP invoices, payments and vendor master/history.
Employee records, service history and status changes.
Benefit enrolments and deduction history.
Purchasing and materials records where in scope.
A governed sequence — completed and live in production.
Profiled the Infinium source and finalized the ten-year archival record set — tables, fields and attachments in scope.
Extracted ten years of Infinium history from the source, including documents/attachments, and standardized it for the archive.
Loaded the data into the consolidated Oracle Autonomous Transaction Processing (ATP) archival database.
Built the 15–20 most-used Infinium reports in Oracle APEX and Microsoft Power BI for daily business needs.
Validated the archived Infinium data against source, deployed with role-based access and audit logging, and went live in production.
Retained a complete backup of the original data on the cloud, and provided ongoing Syntra support for any query.
What Catholic Healthcare Trust staff use every day.
Payroll history, earnings and deduction reports for HR and finance queries.
Trial balance, GL detail and AP/vendor-history reports.
Employee service-history and status reports for verification and audits.
Staff search and browse the archived records themselves in the Oracle APEX portal, with filters and Excel/PDF export.
A full backup of the original source data is retained on the cloud, in addition to the archive.
Syntra provides ongoing support for any query on the archived data, if and when one arises.
Ten years of Infinium history — payroll, GL, AP and HR — was archived to meet legal, audit and insurance retention requirements, and it remains fully searchable in the Oracle ATP archive.
15–20 of the most-used Infinium reports were built in Oracle APEX and Microsoft Power BI for daily business use — covering payroll/earnings, GL/financials and HR/service history.
Yes — payroll registers, earnings, deductions and year-end data are archived and reportable, so HR, finance and auditors can respond to tax, wage-and-hour and legal queries without the legacy system.
In an Oracle Autonomous Transaction Processing (ATP) database, with Oracle APEX and Power BI reporting, role-based access and audit logging. A complete backup of the original data is also retained on the cloud, and Syntra provides ongoing support.
Retiring a system like Infinium? We can archive 10+ years of history into a secure, reportable Oracle archive — with backup and support. Tell us your systems.