Indium Helps a Global Bank Save 500k with Striim and Azure Synapse Analytics
A Faster Way to Serve Millions: A Streamlined Journey to Real-time Analytics
Imagine being a bank with nearly 9 million customers across thousands of locations, all relying on real-time data for everything from retail transactions to complex financial analysis. That’s the reality for our client, a leading private sector bank offering a wide range of financial services that was experiencing limitations with their existing data infrastructure. Their core banking systems, Finacle (Oracle) and Ganaseva (MS SQL) contained crucial data spread across 350+ tables that needed to be readily available for downstream analytics to support their diverse banking services. However, the existing system lacked the efficiency and scalability required for real-time data updates and future growth.
The challenge? This wasn’t just about moving massive amounts of data. Our client faced several challenges:
Data silos
Real-time data updates from their core banking systems were unavailable, hindering critical analytics and decision-making.
Data latency
Existing data pipelines were inefficient, leading to delays in accessing crucial information.
Scalability concerns
The on-premises infrastructure couldn’t keep pace with the bank’s growing data volume and future needs.
XML data management
Migrating and managing XML data extracts from the core banking systems presented an additional hurdle.
Our client’s requirements were clear - Securing the past and enabling the future!
Real-time data replication
Establish a robust pipeline to deliver real-time data updates from the core banking systems to the cloud.
Historic data migration
Migrate all historical data securely to the cloud platform without any data loss.
Real-time replication for currency
Real-time replication for currency.
Flexible XML handling
Migrate XML data into the cloud while preserving both its original format (ASIS) and relational database format (RDBMS) for optimal utilization.
We Stepped in to Empower the Bank with a Future-proof Solution
We designed a robust and highly scalable data warehouse ecosystem leveraging the power of Azure cloud. Here’s how we delivered:
01
Real-time Data at Your Fingertips
We leveraged Striim, a powerful tool that established a real-time data replication pipeline. Our client received constant updates from their core banking systems directly to the Azure cloud. Striim also handled on-the-fly conversion of XML data, ensuring seamless integration.
02
Cloud-powered Data Hub
We set up our client’s Azure cloud infrastructure with a two-pronged approach: Data Lake on ADLS: This secure, cost-effective storage solution housed the client’s historical and real-time data. Data Warehouse on Azure Synapse Analytics: We built a powerful data warehouse on Synapse Analytics to facilitate in-depth analysis and reporting.
03
Seamless Legacy Data Migration
Indium designed a process to migrate terabytes of historical data residing in the client’s Oracle and MS SQL core banking systems to the cloud securely and efficiently.
04
Data at a Glance
We implemented a diverse set of metrics and live dashboards to empower informed decision-making. This gave the client real-time insights into their data health and overall performance, all presented in an easy-to-use format
The Impact: Speed, Efficiency, and Growth
01
50% improvement in efficiency Striim for speed
Leveraging Striim for data migration boosted the efficiency of the process by over 50%. Real-time data flowed seamlessly from the on-premise core banking systems to the Azure cloud
02
80% reduced costs, enhanced efficiency (cost savings of USD 500,000)
The user-friendly nature of the tools and cloud infrastructure significantly reduced maintenance and technical support costs by nearly 80%. This allowed the bank to reallocate resources towards strategic initiatives.
03
Empowering customer service and operations
With real-time data readily available, the bank was able to improve customer responsiveness and streamline operational efficiency. This translated to a more competitive edge and a superior customer experience.