This company sought to improve its data platform's speed, scale and sustainability to respond to evolving business needs and deliver data products faster and more efficiently.
The company partnered with NTT DATA and Hashmap, an NTT DATA company, to migrate from an on-premises Oracle data warehouse and Informatica ETL environment to Snowflake's Data Cloud with Matillion ELT and Qlik Replicate on AWS.
By developing innovative equipment and machinery for electrical power generation, a leading manufacturing and industrial machinery company empowers its customers by maximizing availability, reliability and value throughout an equipment's life cycle. To meet evolving business needs and deliver advanced data-driven solutions, it turned to NTT DATA Cloud Transformation services to modernize its data architecture.
The goal was to transform a data infrastructure to the Snowflake Data Cloud, Matillion ELT and the Qlik Replicate Data Integration Platform—all hosted on AWS. The modernized architecture would deliver an extensible technology stack that unites data sources, management and analytics tools for greater agility, scale and sustainability.
A successful journey begins with a roadmap
Together, they collaborated throughout the cloud transformation journey by identifying the shared goals of multiple stakeholders and designing a roadmap to connect the dots from strategy to execution. That roadmap encompassed several phases:
Data transformed for speed, simplicity and scalability
NTT DATA applied several of its Data Architecture Modernization capabilities to design and deploy a new data platform.
It migrated an on-premises Oracle data warehouse to the Snowflake Data Cloud. Snowflake's multi-cluster shared data architecture empowers the company with on-demand scale and performance to load data instantly and simultaneously run multiple workloads on that data. The data cloud also provides automation capabilities for platform management, performance optimization, data sharing, security and governance.
The migration team chose a combination of Matillion and Qlik Replicate to replace the on-premises Informatica ETL environment. Matillion is architected for the cloud and natively integrates with Snowflake. In addition, it supports many pre-built data source connectors that simplify extraction from frequently used data sources and quickly load that into the data warehouse. Qlik Replicate also provides synchronization with several on-premises data sources, including Oracle and SQL Server.
The combination of integration solutions enables the company to operationalize that data efficiently and accelerate business value.
Thanks to their close collaboration and planning, architecture modernization was completed in under five months. In the process, they migrated 3,000 Oracle tables, 42 data sources, 4,002 Informatica and Alteryx mappings and 2,350 Tableau and Cognos reports.
This cloud transformation improves and simplifies data management while reducing data load times and data latency. In addition, the transformation broadens the scope of the cloud-based data sources while cost effectively giving it on-demand scale and performance for data warehousing.
As a result of its modernization effort, the company now has an agile, sustainable cloud data platform to power compelling business insights and drive continued growth.