Data Virtualization options with SQL Server technologies


  • Please let me know the available options for data virtualization using Microsoft BI Technologies for scenarios where high data volume and complex transformations are involved. I'm looking for a virtualization solution such that there is no persistent DWH built, no ETL involved and the virtualized layer can be built directly on top of the source databases using which reports can be generated. The main objective is to let the business users generate their reports in real-time/near real-time.

    Power Query/ROLAP SSAS/SSAS Tabular with DirectQuery serve as virtualization options but it doesn't appear to be an optimal solution for high data volume/complex transformations. Please share your thoughts if you have any other ideas.

    Monday, August 11, 2014 10:26 AM


All replies