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.
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
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