Oracle, HVR, Talend, Tableau, Greenplum
Summary
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.
Challenge
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.
Solution
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.
Results
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.
How can Starschema help you?
By completing this form, you agree to receive periodic product and services related communications, emails and promotional materials from Starschema and their partners, and provide your consent to our processing of your information in accordance with Starschema’s Privacy Policy. We take the protection of your information seriously.
White Paper
For many businesses, demand planning is essential. Profitability, cash flow, and customer satisfaction and retention all hinge on getting this right. This white paper will introduce latent matrix factorization to model demand curves and discuss how it can be used to achieve these outcomes.
Webinar Replay
Fast unobstructed access to data and time to insight matters more now than ever. In these quickly changing times, businesses must innovate and implement a ‘Stack of the Future’ to be able to make accurate, data-driven decisions in minutes, not hours or days. The potential value of data is well known but in the new environment, the ability to easily share and collaborate on data is a competitive differentiator that will be leveraged by forward-thinking companies
Solution Brief
During times of crisis, companies must look at the available data — both internal and external— and try to understand how that data can be used to determine how the business is currently being impacted, how it is likely to be affected in the future, what are most likely scenarios that will play out, what can be done to counter those scenarios and take advantage of hidden opportunities in this rapidly changing environment. The Starschema COVID-19 dataset ingests reliable data from multiple sources and makes it analytics-ready so it can be easily accessed and used.
Webinar Replay
Keeping your data platforms running with operational efficiency is both paramount and can be a costly and complicated endeavor. Join us and learn how to apply strategies, techniques, and tools to build a reliable and effective DataOps practice in your organization.