1 / 6

Datametica Accelerates Teradata to GCP Cloud Migration- Datametica

Datametica streamlined the Teradata to GCP migration for the UKu2019s national postal services, addressing scalability and performance challenges through automated data migration tools. Using Eagle for assessment, Raven for code conversion, and Pelican for data validation, Datametica enabled a smooth cloud migration of Teradata, Datastage, and .NET workloads to BigQuery. The result was a 50% faster migration, 40% improved performance, and lower operational costs with a highly scalable cloud infrastructure.

Datametica
Télécharger la présentation

Datametica Accelerates Teradata to GCP Cloud Migration- Datametica

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Teradata, Datastage and .NET migration to GCP By Datametica March 31, 2022 Case Study Home » Case Study » Teradata, Datastage and .NET migration to GCP The Objective: The national postal services in the United Kingdom wanted to migrate their on-premise Teradata to GCP. The objective of this engagement was to migrate the analytics, reporting and data science capabilities that are currently on the Teradata Migration to Google Cloud Platform (GCP) and leverage the cloud-native technologies for reduced operational cost and improved performance. We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. Privacy Policy Do not sell my personal information. Reject All Accept All Cookie Settings

  2. Challenges: Scalability and Performance issue The client faced challenges with high operational costs and performance issues while running data on Teradata. In peak season, the existing Teradata system wasn’t able to scale which resulted in poor performance and technical issues during the critical period. Lack of SMEs with cloud expertise was another reason for associating with Datametica. The Solution: Future Data Platform Program on GCP  Datametica simpli?ed the cloud migration process by offering a detailed assessment of the existing Teradata environment using Eagle- an automated assessment & data migration planning tool. Through this analysis, we provided the best possible approach of GCP migration.  One-time historical data migration from on-premise to GCP.  Code Conversion of Teradata SQL and ETL (Datastage and . NET) scripts to BQ using Datametica’s Automated code (SQL, Script) and ETL conversion Tool – Raven.  Migrated ELT/ ETL Pipeline (DataStage & .NET) to Google BigQuery and Cloud compose.  Shell Scripting and Python Scripting were used to manage ETL Pipeline.  Designed a Framework for complex XML Data processing and loading into the GCP BigQuery.    Performed Data Validation using Datametica’s automatic data validation tool – Pelican, for data quality assurance. This ensured incremental data loads, based on converted code during migration, match at a table, row and cell level for production parallel run between Teradata systems to Google BigQuery which gave them the

  3. con?dence to decommission the Teradata environment.  Datametica used Google Cloud Storage, Big Query, Data?ow, IAM, Pub/Sub, Stack Driver, Composer to simplify the complex data migration to google cloud and overcome challenges related to time, cost and scalability. Client Bene?ts: High Scalability with 40% Improved Performance.  50% faster migration to GCP using Datametica’s automated data migration tools. Reduced cost for the migration process. The high scalability of GCP helped them deliver high customer service in peak seasons. 40% improvement in performance.    Google Products Used

  4. Datametica Products Used Recommended for you  View More Case Study Pelican Contributed 90% Cost Savings in Data Validation Webinar Learn how Google Cloud helps Retailers leverage their data Case Study Netezza to Google Cloud Platform (GCP) Migration

  5. subscribe to our case study Email address Subscribe let your data move seamlessly to cloud Contact Us Quick Links About Careers Empowering businesses by migrating their data/workloads/ETL/analytics to the cloud. We are truly ‘Giving Data Wings’. Blogs Case Studies Contact Us Our Partners Products Address Eagle 3500 Western Ave, Suite 2D, Highland Park, Illinois 60035- 1263 Raven Pelican 1 North Bridge Road, #10-06, High Street Centre, Singapore 179094 Jubilee Business Centre, 211

  6. Kingsbury Road, Kingsbury, London, NW9 8AQ Migration to GCP Our Solution Teradata To BigQuery Data Warehouse Migration Netezza To BigQuery Data Platform Modernization Oracle To BigQuery Data Management Data Science & Advanced Analytics Migration to Azure Cloud Optimization Teradata migration to Azure Netezza migration to Azure Oracle migration to Azure © 2023 Datametica Solutions Pvt. Ltd. | Agency Partner Talkd | Privacy Policy | Code of Conduct | GDPR Compliance Statement | Terms Of Service | CSR Policy

More Related