Project Overview
Implementation of CDC and Data Stream Banking. We helped Bank Sinarmas modernize their data architecture by implementing a real-time data streaming solution using (CDC) technology.
Implementation of CDC and Data Stream Banking. We helped Bank Sinarmas modernize their data architecture by implementing a real-time data streaming solution using (CDC) technology.
The Challenge
Legacy batch-based extraction caused significant replication delays and heavy operational loads on core systems, limiting real-time access for customer inquiries and investigations.
Legacy batch-based extraction caused significant replication delays and heavy operational loads on core systems, limiting real-time access for customer inquiries and investigations.
The Solution
Implemented a high-availability architecture using Qlik Replicate to stream data from Oracle T24 systems into a scalable Kafka Confluent layer for downstream consumption.
Implemented a high-availability architecture using Qlik Replicate to stream data from Oracle T24 systems into a scalable Kafka Confluent layer for downstream consumption.
The Result
The project enabled near real-time data replication while reducing system pressure and establishing a standardized framework for future data integrations.
The project enabled near real-time data replication while reducing system pressure and establishing a standardized framework for future data integrations.
​
About
Bank Sinarmas is a prominent financial institution in Indonesia that focuses on digital banking innovation and integrated distribution networks to provide high-quality services to its diverse customer base.
The Business Challenges
Batch-based data extraction (H+1 after EOD) from T24 Core Banking caused replication delays to downstream platforms (EDW, analytics).
High operational load on core systems (CPU, memory, bandwidth) due to repeated batch processing.
Limited real-time integration with analytics and operational applications, impacting inquiry use cases (account statement, customer inquiry, transaction investigation).
Sibernetik Solutions
- Implemented Realtime Change Data Capture (CDC) using Qlik Replicate from Oracle T24 FO core system & streamed data into Kafka (Confluent Platform) as an intermediate, scalable data streaming layer.
Delivered downstream consumption through HBase + Phoenix and Cloudera Big Data Platform, enabling near real-time access for applications.
- Deployed across Pre-Production and Production environments with high availability and tuned CDC parameters.
The Business Benefits
Enabled near real-time data replication from core banking systems instead of H+1 batch extraction.
Reduced dependency and resource pressure on T24 core systems by using incremental CDC updates.
Improved data availability for operational reporting and real-time inquiry use cases, including account statements and customer transaction checks.
Established a scalable and standardized data streaming architecture
for future downstream integration
