Blog Posts

Striim-Powered Real-Time Data Integration of Core Banking System with Azure Synapse Analytics

Cloud-based technologies such as Azure Synapse data warehouse, formerly MS SQL, enable banks to leverage their analytical capabilities to get insights that can help with operational decision making on a continuous basis.

It allows querying data as per the bank’s requirements and brings together enterprise data warehousing and Big Data analytics. Based on these insights, banks can devise strategies for improved efficiencies in operations and development of products for better customer service.

Striim for CDC

A platform such as Striim enables the transfer of data from heterogeneous, on-premise data warehouses, databases, and AWS into Azure Synapse Analytics with in-flight transformations and built-in delivery validation. This helps with operational decision making on a continuous basis.

For the exercise to be really fruitful in today’s world of instant response, it is necessary for the data being transferred to be as current and close to the source database on the core banking system. A platform like Striim enables this data integration from the source table to the target using Change Data Capture (CDC).

Learn more about Indium’s Strategic Partnership with Striim

Learn More

CDC allows for data from on-prem sources, regardless of whether it is an RDBMS, No-SQL, or any other type, to a Synapse table or ADLS Gen-2 (Azure Data Lake Store Generation – 2) to be created and updated in near real-time. It doesn’t hit the source database directly.

Instead, it captures all the transactions, be it an update, insert, or delete, from the source database on-prem on a daily basis from the log and gets it generated and duplicated on the target database

This way, the performance of the source database is not affected while there is access to data on the cloud in near real-time for analysis and response.

Advantage Striim

One of the factors that make Striim the most desired CDC tool is its price point while being feature-rich. An evolving tool, it also allows for features such as UDF (User Defined Function) that can be plugged in on the fly. It allows for data manipulation and querying based on the unique needs of the bank. The icing on the cake is the reporting feature with live dashboards and a diverse set of metrics for effective data monitoring.

Its built-in monitoring and validation features include:

By powering the data integration of the on-prem database of the core banking system with Azure Synapse using Striim, banks can ensure continuous movement of data from diverse sources with sub-second latency.

It is a non-intrusive way of collecting data in real-time from production systems without impacting their performance. It also allows for denormalization and other transformations on data-in-motion.

The data warehouses Striim supports include:


Striim can integrate data in real-time data from logs, sensors, Hadoop, and message queues to real-time analytics.

Leverge your Biggest Asset Data

Inquire Now

Inquire Now

Leverge your Biggest Asset Data

Indium – A Striim Enabler

Indium Software is a two-decade-old next-generation digital and data solutions provider working with cutting edge technologies to help banks and traditional industries leverage them for improving their business process, prospects, and efficiencies.

We can help identify the tables in the core banking system that need to be replicated on the target Synapse and set up the Striim platform for smooth integration. Leaders in implementing Striim, we have successfully lead several such integrations across sectors. Our team has cross-domain experience and technology expertise which helps us become partners in the truest sense.

If you would like to leverage cloud and analytics through Striim, contact us here:

The post Striim-Powered Real-Time Data Integration of Core Banking System with Azure Synapse Analytics appeared first on Indium Software.

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples