Chapter 16. Interfacing with Tabular

One of the interesting features of SQL Server Analysis Services (SSAS) is that it is possible to interact programmatically with the server, using dedicated libraries and specific commands. By using this feature, you can handle complex scenarios in which you can control a database and a server through code. For example, you can handle the creation of new partitions and the processing of them as soon as new data is available without the need to handle them manually.

There are two ways to manage an SSAS instance:

  • AMO (Analysis Management Object) is a .NET library containing several classes that can be used to manage an instance of SSAS.

  • XMLA (XML for Analysis) is a SOAP (Simple Object Access Protocol)-based XML protocol ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.