Gathr Case Studies Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift

Edit This Case Study Record

	Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift Gathr

Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift

Gathr

Technology Category	Analytics & Modeling - Real Time Analytics Infrastructure as a Service (IaaS) - Cloud Computing Infrastructure as a Service (IaaS) - Cloud Storage Services Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Telecommunications
Applicable Functions	Business Operation
Services	Cloud Planning, Design & Implementation Services Data Science Services System Integration
Challenge	The customer, a US-based Fortune 100 broadband connectivity company and cable operator serving more than 30 million customers, was facing several technical and business challenges with their existing data workflow. They received data from multiple sources that was fed into an SFTP server. After ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. The client wanted to make a strategic shift to the cloud to enhance scalability, reduce costs, improve query performance, realize a unified view, simplify management, seamlessly integrate with other cloud-native services, and automate workflows for CI/CD. Read More
About Customer	The customer is a US-based Fortune 100 broadband connectivity company and cable operator. They serve more than 30 million customers across the country. In their existing setup, they received data from multiple sources that was fed into an SFTP server. Once ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. However, this workflow was posing several technical and business challenges, prompting the client to seek a strategic shift to the cloud. Read More
Solution	To meet the customer’s business requirements, an end-to-end data flow solution was built leveraging key components such as Amazon Redshift, Amazon S3, Amazon Athena/EMR/Redshift, and Gathr. Gathr was used to configure ETL flows, ingest data, perform full load, incremental load, and CDC from Teradata to Redshift, transform and persist data feeds to Amazon S3, enable one-time migration by directly loading Teradata tables into Amazon Redshift, validate data post migration, provide a unified view of the complete workflow, set up CI/CD for upgrading ETL flows and moving them seamlessly from one environment to another, and schedule and trigger the data flow process at a pre-configured frequency. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Computing

Infrastructure as a Service (IaaS) - Cloud Storage Services

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Telecommunications

Applicable Functions

Business Operation

Services

Cloud Planning, Design & Implementation Services

Data Science Services

System Integration

Challenge

The customer, a US-based Fortune 100 broadband connectivity company and cable operator serving more than 30 million customers, was facing several technical and business challenges with their existing data workflow. They received data from multiple sources that was fed into an SFTP server. After ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. The client wanted to make a strategic shift to the cloud to enhance scalability, reduce costs, improve query performance, realize a unified view, simplify management, seamlessly integrate with other cloud-native services, and automate workflows for CI/CD.

About Customer

The customer is a US-based Fortune 100 broadband connectivity company and cable operator. They serve more than 30 million customers across the country. In their existing setup, they received data from multiple sources that was fed into an SFTP server. Once ETL was performed, the data was read by an Informatica workload and persisted to their Teradata data warehouse. Business analysts then accessed this data and ran queries to gather insights. However, this workflow was posing several technical and business challenges, prompting the client to seek a strategic shift to the cloud.

Solution

To meet the customer’s business requirements, an end-to-end data flow solution was built leveraging key components such as Amazon Redshift, Amazon S3, Amazon Athena/EMR/Redshift, and Gathr. Gathr was used to configure ETL flows, ingest data, perform full load, incremental load, and CDC from Teradata to Redshift, transform and persist data feeds to Amazon S3, enable one-time migration by directly loading Teradata tables into Amazon Redshift, validate data post migration, provide a unified view of the complete workflow, set up CI/CD for upgrading ETL flows and moving them seamlessly from one environment to another, and schedule and trigger the data flow process at a pre-configured frequency.

Impact #1	The solution enabled the client to accelerate and de-risk the entire migration process.
Impact #2	The client was able to seamlessly integrate with Amazon’s cloud-native services.
Impact #3	The client was able to switch to a cost-effective pay-as-you-go business model.

Impact #1

The solution enabled the client to accelerate and de-risk the entire migration process.

Impact #2

The client was able to seamlessly integrate with Amazon’s cloud-native services.

Impact #3

The client was able to switch to a cost-effective pay-as-you-go business model.

Benefit #1	Support for 40% more analytics users across the enterprise.
Benefit #2	15% increase in the number of queries executed, enabling users to unlock new business opportunities.
Benefit #3	Lower licensing and infrastructure cost.

Benefit #1

Support for 40% more analytics users across the enterprise.

Benefit #2

15% increase in the number of queries executed, enabling users to unlock new business opportunities.

Benefit #3

Lower licensing and infrastructure cost.

Download PDF Version

Overview

Fortune 100 telecommunications company seamlessly migrates from Teradata to Amazon Redshift

Operational Impact

Quantitative Benefit