The Challenges
The client had issues while running data on the Netezza data warehouse. Some of the issues were – complex architecture spread across disparate systems, slow ETL pipeline leading to frequent SLA miss, data quality severely affected, high dependency on aginity due to their hosted solution integration with enterprise and other 3rd party systems. Legacy system misfit for the organizational objective of the next-generation architecture, etc.
The Objective
The US-based chain of beauty stores wanted to retire their existing Netezza data warehouse platform and migrate to the Google Cloud Platform.
Solutions
- Rapid Assessment using Eagle to structure the movement of workload, users and data to GCP.
- Foundation to set up Solution Architecture, Cloud Provisioning (DevOps), Security, Governance, CI/CD pipeline.
- Data Model made compatible to Google BigQuery.
- Migrate from Aginity/Netezza to GCP.
- Data reconciliation between Netezza and Google BigQuery with Datametica Pelican.
- Google BigQuery & SAS Integration for data consumption.
Datametica Products Used
GCP Products Used
Client Benefits:
The client benefited in the following terms:
- Huge improvement in operational performance & cost.
- Time-saving of 55% in migration to GCP.
- Cost-saving of 60% because of Datametica automation technologies.
Recommended for you
subscribe to our case study
let your data move seamlessly to cloud