Developing with ADOMD.NET


Applies To: SQL Server 2016 Preview

ADOMD.NET is a Microsoft .NET Framework data provider that is designed to communicate with Microsoft SQL Server Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification. Commands can be sent in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), Analysis Services Scripting Language (ASSL), or even a limited syntax of SQL, and may not return a result. Analytical data, key performance indicators (KPIs), and mining models can be queried and manipulated by using the ADOMD.NET object model. By using ADOMD.NET, you can also view and work with metadata either by retrieving OLE DB-compliant schema rowsets or by using the ADOMD.NET object model.

The ADOMD.NET data provider is represented by the Microsoft.AnalysisServices.AdomdClient namespace.

ADOMD.NET Client ProgrammingDescribes how to use ADOMD.NET client objects to retrieve data and metadata from analytical data sources.
ADOMD.NET Server ProgrammingDescribes how to use ADOMD.NET server objects to create stored procedures and user-defined functions.
Redistributing ADOMD.NETDescribes the process of redistributing ADOMD.NET.
Microsoft.AnalysisServices.AdomdClientDetails the objects that are contained in the Microsoft.AnalysisServices.AdomdClient namespace.

Multidimensional Expressions (MDX) Reference
Data Mining Extensions (DMX) Reference
Analysis Services Schema Rowsets
Developing with Analysis Services Scripting Language (ASSL)
Multidimensional Model Data Access (Analysis Services - Multidimensional Data)

Community Additions