SQL Server Analysis Services Data Portability Overview

 This document provides an overview of data portability scenarios between Microsoft SQL Server Analysis Services and a vendor’s application.

Analysis Services provides a business intelligence (BI) platform that enables end users and IT professionals to efficiently analyze business data. Two primary workloads exist for achieving this:

• Corporate BI: In this mode, IT professionals use Business Intelligence Development Studio and Microsoft SQL Server Management Studio to build and manage Analysis Services installations.
• Self-Service BI: In this mode, end users build their own solutions by using PowerPivot technologies.

In either mode, Analysis Services databases are built and used by the client tools. Unless specified otherwise, concepts and mechanisms described in this document are applicable to both workloads.

Read more...

More Microsoft SQL Server Data Portability Documentation...