A New Hampshire health system needed to retire five aging platforms — Infinium, SMS, Kronos, Papervision and ECHO Credentialing — while keeping ten years of records available for legal, audit and insurance queries. Syntra ETL migrated approximately 8 TB of data and around 150,000 attachments into a consolidated Oracle Autonomous (ATP) archive, with Oracle APEX and Microsoft Power BI reporting. Oracle Fusion and Oracle Taleo recruiting data were extracted and archived into the same platform. All five systems are now decommissioned and the archive is live in production.
Catholic Healthcare Trust (CHT) had accumulated a stack of specialized applications — each holding records the organization must retain for ten years to answer legal, audit and insurance queries — but keeping them running purely to read history had become expensive and risky.
CHT's estate spanned an Infinium ERP/HR platform, an SMS hospital information system, Kronos workforce management, Papervision document imaging, and ECHO provider credentialing. Auditors, finance, HR, credentialing and clinical staff still needed to retrieve records going back years — so the systems couldn't simply be switched off.
But maintaining five legacy platforms just to read history means paying for licenses, infrastructure and the shrinking pool of specialists who run them. Across the five systems, this meant preserving roughly 8 TB of data and around 150,000 attachments — searchable, secure, and available for daily business as well as legal, audit and insurance requests.
This wasn't a clean, documented migration — retiring five systems meant solving some genuinely hard data problems.
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.
With no clean APIs, we connected directly at the database and file level — SQL Server, IBM i (AS/400) and file-based data — to extract complete, accurate 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.
An end-to-end legacy archival platform on Oracle Autonomous Database.
Reviewed and finalized exactly which archival tables, records and attachments to bring across from all five systems and Oracle Fusion.
Extracted, transformed and loaded ten years of history into a single Oracle Autonomous Transaction Processing (ATP) archival database — one secure home for every legacy record.
Legacy systems extracted directly; for Oracle Fusion, BI Publisher (BIP) reports and HDL-based templates fetched records — a complete replication of everything CHT could previously access.
An Oracle APEX portal for search, browse and export, plus 15–20 key Microsoft Power BI reports per system for daily business use.
Role-based access control, an access audit log, and a strictly read-only design — simple, secure and inexpensive to maintain.
A complete backup of the original source data retained on the cloud, plus ongoing Syntra support for any query.
A governed engagement — completed and live in production.
Profiled the five source systems, Oracle Fusion and Oracle Taleo, finalized ten-year table mapping, and stood up the extraction approach.
Designed the Oracle ATP archival schema and built the APEX portal, Power BI reports and data-load pipelines.
Loaded ~8 TB and ~150,000 attachments, validated against source, and ran user acceptance testing to sign-off.
Deployed to production with secure, role-based access, and 15–20 live reports per system.
Retained a full cloud backup of the originals, delivered documentation and training, and set up ongoing Syntra support.
The outcome for Catholic Healthcare Trust.
Ten years of data from five systems, consolidated and searchable in the Oracle ATP archive via APEX.
Infinium, SMS, Kronos, Papervision and ECHO decommissioned — no longer paid for or maintained.
The most-used business reports for each system, live in Power BI/APEX for daily operations.
Role-based access and audit logging support 10-year legal, audit and insurance retention.
A complete cloud backup of the original data, plus ongoing Syntra support for any query.
Recurring license, infrastructure and specialist cost for five legacy systems removed.
Five systems were archived and decommissioned — Infinium, SMS (Shared Medical Systems), Kronos, Papervision and ECHO Credentialing — each with its own detailed archival page linked below.
Approximately 8 TB of data and around 150,000 attachments across the five systems, covering ten years of history to meet legal, audit and insurance retention requirements.
The consolidated archive runs on an Oracle Autonomous Transaction Processing (ATP) database, with an Oracle APEX portal for search/browse/export and Microsoft Power BI for the business reports — 15 to 20 of the most-used reports per system, delivered post go-live.
Yes — a complete backup of the original source data is retained on the cloud in addition to the archive, and Syntra provides ongoing support for any query that arises.
Keeping five legacy systems alive purely to read history is costly and risky. A read-only Oracle ATP archive preserves complete, searchable, reportable access to ten years of records while letting CHT decommission the systems and remove their recurring cost.
Built on Oracle Cloud Infrastructure (OCI), in close collaboration with Oracle. Data from the five legacy systems — plus records surfaced through Oracle Fusion and Oracle Taleo — moved through a repeatable Extract → Stage → Load → Reconcile → Report pipeline, with the Oracle Autonomous (ATP) database as the destination.
Oracle Fusion data was extracted using BI Publisher (BIP) reports built on Public View Objects (PVOs) and HDL-based templates. Systems outside Fusion were read at source — a direct connection to the IBM i (AS/400) for Infinium, direct SQL for SMS, Kronos and ECHO, and file-based extraction for Papervision. Taleo recruiting objects (Candidate, Application, Attachment) were pulled via Oracle's APIs.
Extracted data landed as files in Oracle Cloud Infrastructure (OCI) Object Storage buckets — a secure, elastic staging zone that decoupled extraction from loading and made re-runs and validation inexpensive.
From the Object Storage buckets, the data was ingested into the Oracle Autonomous Transaction Processing (ATP) database using OCI's native cloud-load capabilities, into the single consolidated archival schema.
For every object, row counts were matched between source and ATP. A full table list with record counts was published for audit and traceability, and data was validated against source on a sample basis.
Oracle APEX served the search-and-browse portal, and 23 APEX audit & analytics reports (across AP, PO, GL, HR and Supplier) plus Power BI reports were built for daily business use.
Reconciliation was count-based and evidence-driven. For every archived object, source and ATP record counts were matched and documented, producing a table-level traceability list the business and auditors could rely on. The ATP database was confirmed fully populated and validated with record counts before user acceptance testing — which was completed across multiple client sessions and signed off.
A core part of the build was the OCI integration between Oracle Fusion/Cloud and the ATP database, established under an agreed OCI cloud configuration and coordinated directly with Oracle. Integration was tested early to de-risk the load, and validation checks confirmed completeness before go-live. Where Fusion/Taleo extraction hit platform limits (e.g. a 500K-row/day cap on certain Taleo objects), these were resolved through service requests raised with Oracle.
Ten years of data, 15–20 reports each — a detailed page per system.
HR, payroll & financials (IBM i) — payroll, GL, AP and HR history.
Hospital information & patient accounting — billing, claims and registration.
Time, attendance & scheduling — timecards, accruals and labor.
Document imaging — the bulk of ~150,000 archived attachments.
Provider credentialing & privileging — licenses, credentials and PSV.
If you're retiring legacy systems but need compliant, searchable, reportable access to years of data, we can do the same for you. Tell us your source systems and retention needs.