Almost every BI system is made up of many data marts. These data marts are commonly developed to improve query performance, to deliver to users the data with the right data structure and the right aggregation level, to minimize network delay for geographically dispersed users, to allow the use of specific database technologies, and to give the users more control over their data. Unfortunately, data marts are expensive because they require a lot of work to develop, operate, and maintain. They also complicate the architectures of BI systems. Virtual data marts can be provide a solution in various ways. This whitepaper describes in detail a step‐by‐step approach for migrating physical data marts to virtual data marts using Data Virtualization. The approach is based on an evolutionary migration that does not impact the existing reporting workload.
Complete the form and download the full Whitepaper.