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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.