Loading...

中文 日本語

{{ caseData.title}}

Home
>
Customer Stories
>
{{caseData.meta.z_case_company}}
{{caseData.meta.z_case_quotes}}
{{caseData.meta.z_case_famous}}

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.
{{ country.name }}
Please fill out the form and submit it, our customer service representative will contact you soon.
By submitting this form, I confirm that I have read and agree to the Privacy Notice.
Submit