Home » Case Study »
Objective: Seamless Code Conversion at a Cost-Effective and Time-Saving Manner
An American multinational financial service provider was looking for a technology partner that could take care of its code conversion in its cloud migration process in a cost-effective and rapid manner. Datametica’s Raven, an automated code transformation product, helped the client convert their current system code and data objects to BigQuery as part of their migration to GCP.
Challenges: Complex System Codes of Teradata and Hadoop
The client wanted to leverage GCP capabilities, so they had initiated the cloud migration process. They were facing difficulties in converting the current complex system codes of Teradata and Hadoop.
Solutions:
Datametica determined the code details and deployed its automated code (SQL, Script) and ETL conversion technology – Raven to convert all the Teradata and Hadoop objects (scripts).
- The automated code conversion process by Raven translated the source artifacts to target, without any change to source logic.
- The implementation and validation was performed iteratively for agreed upon source applications and artifacts over the course of the project duration.
Key Features of Raven
- Automated SQL & ETL Conversion
- Lineage Aware Data Model
- Support non-ANSI compliant constructs, function & clauses
- SQL, expression and workflow Optimizations
- Smart emulations for incomplete SQL statement and clauses
Client Benefits: Faster Migration, Reduced Cost and Enhanced Performance
- Successful translation of complex Teradata, Hadoop, and related codes.
- GCS bucket was created and shared with the client for data transfer and conversion.
- Unit tested all the converted codes on the empty data structures.
- 35% Faster Migration to GCP.
- 50% Reduction in total cost and enhanced performance.
- High quality delivery in Production.
DM Product Used
GCP Product Used
One Comment