Project Overview
Enhancement ODS ODW. We assisted BNI in enhancing their operational data store and warehouse by integrating real-time transaction history and master data modules.
Enhancement ODS ODW. We assisted BNI in enhancing their operational data store and warehouse by integrating real-time transaction history and master data modules.
The Challenge
The bank lacked the capability to connect existing transaction master modules in real-time to their data store, while needing to manage over 15 million daily transactions for loan and savings.
The bank lacked the capability to connect existing transaction master modules in real-time to their data store, while needing to manage over 15 million daily transactions for loan and savings.
The Solution
We implemented real-time data replication using IBM CDC and Kafka to stream loan and savings transaction history and master data into the operational data store and warehouse.
We implemented real-time data replication using IBM CDC and Kafka to stream loan and savings transaction history and master data into the operational data store and warehouse.
The Result
The project successfully delivered integrated data modeling and mapping for INCT and BOCT, ensuring real-time data synchronization across the bank's operational platforms..
The project successfully delivered integrated data modeling and mapping for INCT and BOCT, ensuring real-time data synchronization across the bank's operational platforms..
About
Bank Negara Indonesia (BNI) is one of Indonesia’s largest state-owned financial institutions, dedicated to providing integrated digital-based financial solutions with a focus on both corporate and consumer banking excellence.
The Business Challenges
- Lack of features to connect existing transaction master modules in real-time to the operational data store and operational data warehouse.
Required to manage over 15 million transactions daily for LOAN and INV (savings).
Sibernetik Solutions
Creating real-time transaction history and mutation data for loan (LOAN) and savings (INV) modules, along with loan master data, using IBM data replicator (CDC) and Kafka to handle over 15 million daily transactions.
Developing new features for existing transaction master modules to enable real-time integration with the operational data store and operational data warehouse.
The Business Benefits
- Developed data modeling for INCT and BOCT on the operational data store, integrated with CDC and Kafka.
- Created data mapping for both INCT and BOCT.
