Login | Register
ORIGIEN Next-Gen Digital Infrastructure
Distributed Core Banking System
Distributed Financial PaaS
Data Middle Platform
Digital Marketing
Risk & Compliance
Payment & Settlement
Channel Solutions
Credit Management
Transaction Banking
Open Banking
Digital Operation
QA Platform
AI Applications
Industry Solutions
About Us
Search
Home / Case / Data Warehouse Migration for Securities Depository

Data Warehouse Migration for Securities Depository

Client Background

The client´s existing data warehouse was based on the Teradata platform, with a total storage volume reaching 70TB. As business volumes and data continued to grow, the platform could no longer meet batch processing timeliness requirements. Considering the high cost of future expansion, the client sought to migrate to a more cost-effective DWS platform to replace the current system.


Challenges

Large volume of existing data (70TB)

Technical complexity in interfacing with heterogeneous platforms

Lack of a comprehensive migration solution

Tight timeline—client required the entire migration to be completed within six months


Our Solution

Based on a deep understanding of the client’s needs and leveraging our extensive migration experience, we rapidly tailored a solution and supporting tools to meet the deadline:

  • Utilized our proprietary table conversion tool to convert approximately 98% of Teradata DDL statements to Gauss syntax, significantly accelerating the migration process

  • Developed an automated data migration program using batch APIs to efficiently and accurately transfer massive volumes of historical data

  • Executed complete Teradata-to-Gauss migration, covering table creation, data verification, and character encoding conversion (GBK to UTF-8), ensuring migration progress and shortening the timeline

  • Manually mapped and converted Teradata macros into equivalent Gauss functions


Results
  • Successfully migrated all historical data from Teradata’s source and foundation layers to the Gauss database

  • Enabled daily automated incremental synchronization between the two systems, solving data verification challenges

  • Completed the full migration project within the six-month deadline and received highly positive feedback from the client

  • Post-launch, the system operated smoothly and was able to detect and alert on data inconsistencies in real time, preventing rework and ensuring data integrity

Contact GienTech to get your customized solutions Consult expert
Online Trial

中电金信鲸Bot RPA是一款面向金融行业客户的机器人流程自动化的开发平台。

  • 鲸Bot设计器

    鲸Bot设计器集成了浏览器自动化组件,office办公自动化组件,数据库组件,文件处理组件、邮件组件等多种类型组件,通过全栈自动识别技术,自动识别目标元素,使开发过程所见即所得,降低了RPA开发门槛,让业务人员也可以方便地进行业务流程的开发。

  • 鲸Bot机器人

    通过手动执行、定时执行、控制台远程调用的方式运行自动化流程,配合控制台对外提供API接口,供外部程序调用。通过特有的视觉反馈技术提供统一的异常处理机制,极大降低开发和运维成本,让RPA流程运行更加稳定,而解决金融行业因技术人员产能不足难以支持其业务发展的问题。

Discover the Next-Gen Digital Infrastructure ORIGIENVideo
Contact Us

+852 39030102 (9:00-18:00)

WhatsApp
Contact Us

Submit your requirements and we will contact you as soon as possible.

  • 0/200