Oracle to AWS Data Platform Migration

Practice Area

  • Data Engineering

Business Impacts

  • Reduced license and hardware costs
  • More efficient reporting process


  • Slow data platform performance
  • Hard deadline for implementing a new data platform


  • Oracle
  • HVR
  • Talend
  • Tableau
  • Greenplum


When large organizations merge or divest, then new entity has business transformation thrust upon it. Our client, a power generation manufacturer, divested from a larger organization to become a brand-new company. With the looming deadline of a cut-over from the existing data platform, the client engaged Starschema to validate and test the existing technology stack and determine the best way to move forward.


The client had an existing, on-premises data platform for handling commercial data but was suffering from slow report loading, sometimes longer than 60 minutes, frustrating the primary data consumers, the sales and marketing teams. The performance issues drove some groups to turn to shadow IT solutions, building their own, parallel data platform. As part of the divestiture, the client wished to take the opportunity to look at migrating its data platform to the cloud. Part of the technology evaluation included the feasibility of migrating the stack components to the cloud.


Starschema data engineers completed a full design review of the existing technology stack which included Oracle ERP as the system of record, HVR for data replication, Greenplum as the database, Talend for ETL, and Tableau for data visualization. This design review included a detailed review of code and configuration for the various technologies used as well as reviewing data governance.Our experts designed a cloud-based architecture incorporating the existing technology on-premises components. After a lengthy testing phase and a Proof of Concept (PoC), the Starchema team optimized the components of the existing data platform to increase performance, validating the technology stack for post-divestiture operations.


With a successful migration of the Oracle ERP source system to Oracle cloud and the other data platform components to an AWS environment, the client has benefited from reduced hardware, license, and maintenance costs. The new, cloud-based data platform renders reports several times faster than the on-premises version.

Streamlined Enterprise Accounting with a Data as a Service Framework

A Fortune 50 conglomerate was not satisfied with its ability to serve internal customers’ data needs and track the costs associated with data requests. To achieve improved data access, as well as transparency and accuracy in intra-conglomerate financial affairs, they needed a flexible, metadata-driven solution.

A Better View of Operations for A Glimmer of Hope

A Glimmer of Hope, an American non-profit philanthropic organization, generates large volumes of data during its day-to-day operation, and wanted to effectively track the outcomes and impact of their programmatic work, improve operational efficiency, optimize costs and allow donors to see the full impact of their donations.

Enterprise-Scale AWS Cloud Migration

Our client, a Fortune 50 energy company needed to migrate all their existing data and analytics platforms to Amazon Web Services and redesign the existing architecture to leverage AWS-native technologies. This was an initiative to optimize performance and reduce long-term operation costs by taking advantage of recent advancements with AWS cloud-native solutions.

Starschema Antares iDL™

A fully automated, compliant-by-design intelligence data lake architecture with real-time ingestion and best-of-breed standardization and audit features.