Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
28 lines (21 sloc) 1.85 KB
title ms.date ms.prod ms.technology ms.custom ms.topic ms.author ms.reviewer author manager
Data providers used for Analysis Services connections | Microsoft Docs
05/02/2018
sql
analysis-services
conceptual
owend
owend
minewiskan
kfile

Client libraries (data providers) used for Analysis Services connections

[!INCLUDEssas-appliesto-sqlas-all-aas]

Analysis Services provides three client libraries, also known as data providers, for server and data access from tools and client applications. Tools like SSMS and Analysis Services projects for Visual Studio, and applications like Power BI Desktop and Excel connect to Analysis Services by using these libraries. Two of the client libraries, ADOMD.NET and Analysis Services Management Objects (AMO), are managed client libraries. The Analysis Services OLE DB provider (MSOLAP DLL) is a native client library. Client libraries are the same for both SQL Server Analysis Services and Azure Analysis Services.

Where to get newer versions

The version installed on a client computer should match the major version of the server providing the data. If the server installation is newer than the data providers installed on the workstations in your network, you might need to install newer libraries.

Client libraries included in earlier SQL Server Feature Packs correspond to that SQL version; however, they may not be the latest. Connecting to Azure Analysis Services may require later versions. All versions are backward compatible.

To get the latest, see Client libraries for connecting to Azure Analysis Services.

See also

Connect to Analysis Services

You can’t perform that action at this time.