Tianjin Xintiangang Steel Group Co., Ltd.

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.