Etlworks
91 Case Studies
A Etlworks Case Study
Raiffeisen Bank International needed to move data from a denormalized MongoDB source into a normalized SQL Server schema across four on-premise data centers. Their complex challenge, solved with Etlworks, involved maintaining referential integrity during the load, using identical logic for both bulk ETL and change data capture (CDC), deploying one parameterized build to all sites, and processing millions of records in under a minute.
The solution implemented by Etlworks used fully parameterized flows to normalize the data on the fly and load it in the correct order to satisfy foreign key constraints. The same logic was applied to both scheduled bulk loads and CDC streams. As a result, the bank achieved its goal of running one identical build across all four data centers, preserved referential integrity, and successfully processed millions of records in under a minute, with the bank reporting complete satisfaction.