Challenges
- Disparate IT systems because many banks come together to form SMTB
- High costs in maintaining integration workflows due to changing data sources
- Existing technologies, such as ETL and file transfer have high maintenance costs
Solution
- Denodo Data Virtualization used to provide a unified virtual view of over 20 disparate data sources
- Consolidated data is fed to custom applications that feed the data warehouse to be accessed eventually by Excel or MS Access
- Scheduler within Denodo performs a monthly run to feed consolidated data for further processing
Benefits
- Virtual views within Denodo are easy to create and maintain, thereby reducing IT costs
- Increased agility in keeping up with changing source data and ensuring that timely data is fed to reporting process
- Greater accuracy in reporting data due to reduced replication
Other Resources
Solution Brief: Facilitating the Digital Transformation in Banking
Find out how Sumitomo Mitsui Trust Bank benefited from data virtualization capabilities.