Autonomous Data Warehouse helps insurance company carry on business-as-usual while retaining legacy data at a significantly lower cost.
Companies are increasingly becoming aware of the amount of legacy data they are retaining, and the costs associated with its storage. Whilst some data is (and should be) deleted as part of a robust retention and disposition strategy, much of it needs to be retained for business and regulatory compliance.
One global insurance company found itself in exactly that position when deciding on its data archiving strategy, with the ultimate aims of simplifying its managed IT estate and reducing costs.
This customer had built up over 1.2TB of Enterprise Resource Planning (ERP) data in an instance of Oracle eBusiness Suite (EBS) that was no longer in active use since the company had migrated to the cloud. This version of EBS was out of support along with the ageing hardware on which it was running.
Oracle Consulting helped the company move this data into an EBS Archive solution, built on Oracle Cloud Infrastructure (OCI) using Autonomous Data Warehouse (ADW) and Application Express (APEX).
The EBS Archive solution now contains all the legacy data for this organisation, allowing users to run reports and raise ad-hoc queries for business and regulatory purposes.
Overall this has reduced costs by over 75% with a clear Return on Investment in less than three months.
By using ADW for storage, the customer can rely on a ‘self-driving’ solution with all patching, updating, backups and encryption taking place automatically.
This customer is now able to carry on business as usual while retaining legacy data at a significantly lower cost with its EBS Archive solution from Oracle Consulting.