Home
Products & Solutions
Consulting & Services
Institute
News Center
About Us
Search
English
Home / Case / China securities registration and settlement-data warehouse migration

China securities registration and settlement-data warehouse migration

Background

 The customer's former data warehouse platform was TERADATA platform with the existing storage space reaching 70 TBs. With business development of business and increasing data volume, the existing platform can no longer guarantee smooth and timely batch processing; and considering the high cost for future expansion beyond budget, the customer wants to replace the existing data platform with a more cost-effective DWS platform.


Business challenges
Large data storage of 70 TBs
Technical integration problems in heterogeneous data platforms
Lack of perfect migration solution
Time pressure for migration: the customer requires that all migration work shall be completed within 6 months
Solution
Fully analyze customer needs, combine GienTech's years of implementation experience and the actual situation to quickly tailor and improve the solution, and tailor migration tools to help customer complete migration within the specified time.
Convert about 98% of the tabulation statements via Gauss data tabulation conversion tool
Develop automated programs to migrate TD data (including tabulation, data file verification, and GBK transcoding UTF8) to GaussDB
TD macro migrates to Gaussian function via manual contrast
Achievements
  1. Smooth migration of all the historical data of ODS layer and basic layer in TD database to GaussDB

  2. Daily batch automatedincremental data synchronization between two databases

  3. Completion of migration within expected time limit with unanimous praise from customer


Contact Us

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

Contact Us

Contact GienTech to get your customized solutions

WhatsApp
Contact Us

Submit your request and we will contact you as soon as possible

  • 0/200
login

After logging in, you can experience online demo for free, download solutions and case white papers

No account yet,register now