Analysis Management Objects (AMO)

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

Analysis Management Objects (AMO) is a library of programmatically accessed objects that enables an application to manage an Analysis Services instance.

If you are programming for Azure Analysis Services, SQL Server Analysis Services, or Power BI Premium tabular models at 1200 or higher compatibility level, use the Tabular Object Model (TOM). TOM is an extension of the Analysis Services Management Object (AMO) client library.

This section explains AMO concepts, focusing on major objects, how and when to use them, and the way they are interrelated. For more information about specific objects or classes, see:

Beginning with SQL Server 2016, AMO is refactored into multiple assemblies. Generic classes such as Server, Database, and Roles are in the Microsoft.AnalysisServices.Core Namespace. Multidimensional-specific APIs remain in Microsoft.AnalysisServices Namespace.

Custom scripts and applications written against earlier versions of AMO will continue to work with no modification. However, if you have script or applications that target SQL Server 2016 or later specifically, or if you need to rebuild a custom solution, be sure to add the new assembly and namespace to your project.