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
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.
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.
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.
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
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
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.
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.
About Indium
Indium is an Al-driven digital engineering company that helps enterprises build, scale, and innovate with cutting-edge technology. We specialize in custom solutions, ensuring every engagement is tailored to business needs with a relentless customer-first approach. Our expertise spans Generative Al, Product Engineering, Intelligent Automation, Data & Al, Quality Engineering, and Gaming, delivering high-impact solutions that drive real business impact.
With 5,000+ associates globally, we partner with Fortune 500, Global 2000, and leading technology firms across Financial Services, Healthcare, Manufacturing, Retail, and Technology-driving impact in North America, India, the UK, Singapore, Australia, and Japan to keep businesses ahead in an Al-first world.
