Indium helps a global bank save 500k with Striim And Azure Synapse analytics

Project Overview

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.

About Client

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.

Business Challenge

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.