Overview
Tianjin Xintiangang Steel Group Co., Ltd. | Large-scale steel manufacturing enterprise
Country: China
Industry: Manufacturing / Steel Production
Solution: i2Stream Real-Time Data Synchronization Platform
The Group operates multiple core databases, including Oracle, MySQL, and SQL Server, which needed to be integrated into a big data platform for real-time analysis and reporting. The objective was to decouple front-end business systems from back-end platforms while ensuring high performance, reliability, and cross-platform compatibility.
Customer Challenge
- Diverse database environment — Oracle, MySQL, SQL Server required unified real-time log-level data capture.
- Performance overhead — Needed to minimize impact on source systems while ensuring continuous operation.
- Data silos — Business units operated independently, leading to fragmented data and inconsistent reporting.
- Integration complexity — Required flexible decoupling to support data warehouses, traditional databases, and big data platforms.
I2 Solution
- Log-level analysis — i2Stream parsed committed database transaction logs (DDL + DML), standardizing changes in real time.
- Kafka-based middleware — Data extracted once from source systems, loaded into Kafka for full decoupling, supporting multiple downstream consumers.
- Load balancing — Implemented table-level and primary key-level balancing, preventing data skew across Kafka partitions.
- Non-intrusive capture — Online data initialization through SCN control, enabling safe, high-performance collection without downtime.
- Web-based monitoring — Provided a graphical management platform for real-time monitoring, trend analysis, and system-wide oversight.
Solution Effects
- Achieved cross-platform compatibility, supporting Oracle, MySQL, SQL Server, and DB2 across multiple OS environments.
- Eliminated data silos, enabling consolidated, accurate reporting and seamless connection to analytics platforms.
- Delivered 7×24 safe operation, with real-time, high-performance data streaming and flexible downstream integration.
- Simplified management with centralized web-based monitoring and reporting.