Analysis Services Class Libraries

References to these libraries are required when writing .NET applications that interface with Analysis Services. However, as I’m not a serious .NET developer (thank god! /jk /sortof) I don’t use them that much. But when I do, I usually waste the first 10 minutes searching for it in windows explorer before giving up and wasting another 5-10 minutes bingl’ing for the answer.

To avoid this waste of time in the future, I’ve decided to just create a silly little blog post so that I know where to find these silly little files.

Microsoft.AnalysisServices.AdomdClient.dll (ADOMD)

ADOMD.NET is a managed data provider used for querying Analysis Services data. Excel uses ADOMD.NET when connecting to a specific Analysis Services cube.

  • [SQL 2014] C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\120
  • [SQL 2016] C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\130


Microsoft.AnalysisServices.dll (AMO)

Provides an object API used to administer Analysis Services multidimensional server instances, databases, roles, and assemblies. It’s also used to administer data mining models and tabular models that use multidimensional metadata for object definitions (compatibility levels 1100 and 1103)

  • [SQL 2014] C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies
  • [SQL 2016] C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s