BI & Analytics Case Study Hexaware automates data warehouse migration from Oracle Exadata to Azure Synapse Analytics for a leading biopharmaceutical firm Our client, who is a leading biopharmaceutical company in the US and provides clinical research, medical communications, consulting and advanced technology products and services, was facing issues with their current EDW on Oracle Exadata. It was incapable to handle the large enterprise data volumes generated from clinical trials and research. Moreover, it was becoming very expensive to maintain and manage their legacy DW appliance. Their Total Cost of Ownership (TCO) was skyrocketing. As Hexaware was chosen as a partner for the task of Oracle Exadata migration, we proposed using Microsoft Azure data service components to achieve agility and cost effectiveness. The newly architected solution involved extracting data from various data sources like research, trials, Finance, CRM and HR applications into Azure Data Lake. Azure Synapse Analytics was selected to replace Oracle Exadata as the new EDW, where data will be used for reporting, analytics and ad hoc querying. Azure Analysis services were used for tabular models, relational modelling and Power BI for visualization. The entire migration was automated using AMAZETM for Data & AI platform. Key Benefits Leveraging Azure Synapse Analytics, the TCO of EDW landscape was reduced by 45% The new cloud ecosystem brought better scalability and security with super-fast querying ability AMAZETM for Data & AI automated the entire migration process, enabling rapid cloud migration in just 11 months