How Indium Helped A Private Sector Bank Reduce Maintenance Costs By USD 500K Leveraging Striim And Azure Synapse Analytics
Indium leveraged Striim for Real-Time Data Integration to migrate data from Oracle & MS SQL On-prem Core Banking System to Azure ADLS and Azure Synapse Analytics, ensuring data concurrency and formatting in the data pipeline. Historic data migration was also accomplished.
The client is one of the fastest-growing private sector banks, offering specialized services across various business verticals, namely: Corporate & Institutional Banking, Commercial Banking, Branch & Business Banking, Retail Assets, Development Banking and Financial Inclusion, Treasury and Financial Markets Operations. With close to 9 million customers, they have a presence with thousands of office locations and branches.
The client required real-time data updates from their core banking systems to a reliable destination database for downstream analytics in order to support their banking services. The data migration process needed to be efficient and scalable to meet future business needs.
The existing system consisted of two Core Banking systems: (i) Finacle (Oracle) and (ii) Ganaseva (MS SQL). Approximately 350+ tables needed to be updated in real-time from these Core Banking Systems. Some of the table extracts were in XML format, and it was essential to migrate them as they were and parse them as relational data.