Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
Get email alerts on the Data Migration topic
No spam. Unsubscribe anytime.
ADS outlines data-lake approach to preserve legacy reports and historical personnel records
Summary
ADS said it will place a read-only copy of the legacy Oracle environment into a data lake so roughly 400 existing reports continue to function while Prism Analytics and targeted analytical environments handle specific use cases.
Agency of Digital Services staff described a two-part data plan for the ERP transition: migrate a sizable slice of operational data into the new ERP, and put legacy data into a data lake so existing reports and analytic workloads continue to run.
"A good slice of the data is migrating into the new ERP system," Josiah Rais, chief data and AI officer, said. He added that an adjacent analytical environment, Prism Analytics, will handle common use cases such as retirement reporting while the data lake will hold a read-only copy of the Oracle environment so legacy reports keep pointing at the same logical source.
Rais said around 400 reports currently in use will be preserved via a network proxy so those reports "see" the old data source in read-only mode. He noted that baked-in database views and one-off HR processes remain work items: the team is testing read-only access and deciding whether to rebuild specific reports or provide alternate access paths for infrequent queries.
Committee members asked whether the data-lake approach was part of the ERP scoping or developed later; Rais said data-lake thinking was in initial requirements but became more explicit as the project matured. ADS staff said they are preparing a more precise cost estimate now that data sets and use cases are better defined.
