Sumitomo Mitsui Trust Bank

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