Enhancing Data Transfer Efficiency:
A Case Study on Tipsport’s Migration to NCDC

In the dynamic world of data management, businesses often face challenges in seamlessly transferring and synchronizing data between different database systems. Tipsport, a leading company in the gaming and betting industry, encountered issues with its previous data transfer solution provided by Microsoft. Frequent system freezes and a lack of detailed logs to diagnose the root cause prompted Tipsport to explore alternative solutions. The transition to Oracle Exadata, while addressing some issues, introduced new complications with old CDC software, such as data being returned in the wrong order. In their quest for a robust and efficient solution, Tipsport adopted the NCDC tool, which not only resolved existing issues but also facilitated a smooth transition without system downtime.

NCDC Implementation

The decision to implement NCDC proved to be a pivotal moment for Tipsport’s data management strategy. Unlike its predecessor, NCDC seamlessly integrated into the existing infrastructure, allowing for a month-long parallel run of the old and new Change Data Capture (CDC) components. This strategy ensured a smooth transition of responsibilities from the legacy system to the new Data Warehouse (DWH), minimizing any potential disruptions.

Key Statistics and Performance Metrics

386

 Number of Monitored Tables

3,790

Number of Monitored Columns

36 seconds

 Average CDC Latency (Write to CT Tables)

65 seconds

Average DWH Data Latency

130-150 million

Daily Processed Changes

29TB+0,5TB

DWH Size (Data + Log)

Benefits Realized

The implementation of NCDC at Tipsport resulted in several tangible benefits. The system achieved remarkable daily change processing rates, totaling 150 million changes. The average CDC latency demonstrated significant improvements over the previous solution. With an average data latency of 65 seconds in the Data Warehouse, Tipsport experienced enhanced efficiency in data retrieval and utilization.

Conclusion

Tipsport’s journey with NCDC exemplifies the positive impact of choosing the right data transfer solution for business-critical operations. The successful migration from a problematic Microsoft solution to an efficient NCDC tool not only resolved existing issues but also positioned Tipsport for future scalability and growth in the ever-evolving landscape of data management.

Ready to get started?

Get in touch and try NCDC for free!

try for free