### 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](/en/document/solution-brief/facilitating-digital-transformation-banking)

Find out how Sumitomo Mitsui Trust Bank benefited from data virtualization capabilities.