
DXC Technology successfully migrated a legacy AS400/Db2 database to a cloud-native architecture using Amazon S3, AWS Glue, Amazon Athena, and Power BI, reducing monthly costs from thousands of dollars to under $10 while improving accessibility, reporting, and security.


<div><p>This article describes how DXC Technology migrated a legacy AS400/Db2 database to AWS cloud-native services for a global oil and gas company.</p><ul><li>Customer faced high maintenance costs, hosting expenses, and lack of skilled AS400 personnel</li><li>Two-phase migration: application to SaaS, then legacy data to cloud-native architecture</li><li>Solution uses Amazon S3, AWS Glue, Amazon Athena, and Power BI for data storage and reporting</li><li>Data extracted from Db2 as CSV files and uploaded to S3 buckets</li><li>AWS Glue crawlers automatically discovered and cataloged data for Athena queries</li><li>70 SQL queries rewritten for Athena; Power BI created interactive dashboards</li><li>Cost reduced from thousands monthly to under $10 monthly</li><li>Improved security through centralized SSO authentication and access management</li></ul><p>The migration demonstrates how cloud-native services enable cost savings, scalability, and improved accessibility for legacy workloads.</p></div>


Related articles