Analysis Services Data Access Interfaces (Analysis Services - Multidimensional Data)
Microsoft SQL Server Analysis Services supports several technologies that can be used to access data and metadata stored on an instance of Analysis Services. Using the Analysis Services data access technologies, you can do the following:
Describes the OLE DB, OLE DB for OLAP, OLE DB for Data Mining, and XMLA schema rowsets supported by Analysis Services.
Describes ASSL the extended version of XMLA protocol, used to communicate with an Analysis Services instance.
ASSL takes advantage of SOAP to provide direct access to Analysis Services through a XMLA based open standard for multidimensional data access.
Describes the native OLE DB provider for Analysis Services.
Describes ADOMD.NET, the set of namespaces in the .NET Framework that provide access to data and metadata on an Analysis Services instance.
Starting with SQL Server, Analysis Services fully supports the Microsoft .NET Framework. Support of the .NET Framework lets developers access Analysis Services data and metadata using a choice of .NET-compliant languages or by using native code. The Microsoft .NET Framework SDK includes the Microsoft Visual Basic .NET and Microsoft C# compilers, as well as related tools.
To create applications that use Analysis Services, developers can use Microsoft Visual Studio .NET—an integrated design environment (IDE) that offers developers many tools and features that simplify and accelerate the iterative cycles of coding, debugging, and testing, and deployment. However, developers do not have to use Visual Studio .NET to compile and build managed applications for Analysis Services. Developers can use any code or text editor that is compatible with the .NET Framework.
By default, the .NET Framework is installed with SQL Server, but the .NET Framework SDK is not. Without the SDK installed on your computer and included in the Books Online collection, links to SDK content in this section will not work. Install the .NET Framework SDK. After you install the SDK, add the SDK to the Books Online collection and table of contents by following the instructions in SQL Server Combined Help Collection Manager.