Virtual Data Layer Accelerates Financial Research
The Firm is a global leader in multi-manager investment services, providing investment products and services in more than 40 countries. Accessing the data required expert knowledge of the Research Database (from dozens of disparate data sources in several data formats) and T-SQL. In order to serve 300+ users with limited resources in a timely fashion, developers utilize various pre-built SQL server views to gain certain level of efficiency. These views were functional but extremely resource intensive and cumbersome to maintain. The goal was to use data virtualization technology to provide a single, unified, re-usable view for real time data access that improves performance and time to market while greatly reducing initial setup and ongoing support costs. This resulted in 1.5% revenue increased.