China securities registration and settlement-data warehouse migration
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.
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
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
Smooth migration of all the historical data of ODS layer and basic layer in TD database to GaussDB
Daily batch automatedincremental data synchronization between two databases
Completion of migration within expected time limit with unanimous praise from customer
+852 39030102 （9:00-18:00）
Submit your request and we will contact you as soon as possible
After logging in, you can experience online demo for free, download solutions and case white papers