none
Is there a REST interface for SSAS (or PowerPivot)

    Question

  • Is there a possibility to query SSAS by means of a REST interface?

    I know SQL Server Relational has a service which lets us query and interact with SQL via RESTFUL API. 

    I want to know if this is available for SSAS (or its newer variants like the Tabular and PowerPivot).

    This will help me in querying SSAS from analytical packages developed in Python (linux) and R (linux).

    Friday, April 11, 2014 9:19 PM

Answers

  • REST with relational data source works fine & easy: You pass an id and get the entity for it. But how should it work with a multidimensional data source? How to pass which measure you want to get?

    For such application SSAS Support XML/A Access over HTPP; see Configure HTTP Access to Analysis Services on Internet Information Services (IIS) 7.0


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, April 15, 2014 6:39 AM
  • REST can involve more that just URL access. It's more about appropriately using both URLs and HTTP methods to express your API. I have an internal project at the moment which has a REST interface that allows me to send queries to SSAS using HTTP POST requests and sending MDX or DAX in the body of the request so that I am not limited by URL length and character restrictions. It's not too hard a thing to build, but there is nothing that comes "out of the box" from Microsoft and I'm not aware of any generic open source projects.

    http://darren.gosbell.com - please mark correct answers

    Tuesday, April 15, 2014 12:53 PM

All replies

  • Unfortunately no, there is not a REST interface available that comes with SSAS. It's probably not hard to build one in .Net using ADOMD.NET, but I'm not aware of any that are available for download.

    http://darren.gosbell.com - please mark correct answers

    Saturday, April 12, 2014 9:55 PM
  • Hi Technologist,

    As Darren said, there is no such a REST interface for SQL Server Analysis Services, If you have any concern about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, April 14, 2014 8:52 AM
  • So how will people use SSAS in a Office 365/Azure scenario?

    I believe that all Microsoft technologies are moving in the direction of REST so that they can be easily programmable in a cloud scenario.

    Does this mean SSAS does not have a roadmap into Azure/Office365?

    Monday, April 14, 2014 3:12 PM
  • There is no current SSAS offering in SQL Azure, I'm pretty sure that Micorosoft has said that there will be one, but they have not announced anything about the sort of API's they will use. A REST interface would be nice, but they may just use the existing SOAP based interface as that works fine over HTTP.

    http://darren.gosbell.com - please mark correct answers

    Monday, April 14, 2014 9:21 PM
  • REST with relational data source works fine & easy: You pass an id and get the entity for it. But how should it work with a multidimensional data source? How to pass which measure you want to get?

    For such application SSAS Support XML/A Access over HTPP; see Configure HTTP Access to Analysis Services on Internet Information Services (IIS) 7.0


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, April 15, 2014 6:39 AM
  • REST can involve more that just URL access. It's more about appropriately using both URLs and HTTP methods to express your API. I have an internal project at the moment which has a REST interface that allows me to send queries to SSAS using HTTP POST requests and sending MDX or DAX in the body of the request so that I am not limited by URL length and character restrictions. It's not too hard a thing to build, but there is nothing that comes "out of the box" from Microsoft and I'm not aware of any generic open source projects.

    http://darren.gosbell.com - please mark correct answers

    Tuesday, April 15, 2014 12:53 PM