Is it possible to connect to Microsoft Analysis Services other than the connector?

Question

Microsoft

Greetings.
There are OLAP cubes that live on Microsoft Analysis. I would like to receive data from them for the site. For a huge list of reports, Excel connects to them through the built-in connector. Is there any way to befriend them via REST/SOAP? Or some other way.

Answer 1

There is
https://docs.microsoft.com/en-us/analysis-services...
XMLA, the XML for Analysis protocol.
There are plugins for various servers, such as Microsoft IIS, which translate queries written in the XMLA dialect into native queries of the analytical service, and respond with data tables. Moreover, they work not only with Microsoft Analysis Services, but with all services that correspond to the interface, in particular, there is a translator for Kettle Pentaho, which, at least before, worked on top of Tomcat. Last year they were promised to be transferred to the rails of the Hitachi software development center, but I never bothered to get acquainted if the platform was released by one of the houses of Matsushita Corporation in the field of open sources, or at least as an open platform, its license for "communal".

Answer 2

Try this https://docs.microsoft.com/ru-ru/sql/reporting-ser... Publish finished reports on the site