Licensing options for accessing cube over internet

Mark 21 Reputation points
2020-12-31T11:03:13.16+00:00

Hi, I need to develop a couple of tabular models / cubes for a client and make them accessible to them over the internet - the plan is to use the HTTP data pump (msmdpump.dll) and basic authentication.

I'm a data engineer / SQL developer and don't have a lot of experience with server licensing side of things. In terms of the actual setup this is what I'm thinking but happy to go with whatever makes more sense and is most cost efficient.

Essentially I'm trying to understand the licensing requirements for the IIS / Webserver and the SSAS Instance that would best meet my needs.

Thanks for your help, Mark

52526-setup.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,290 questions
0 comments No comments
{count} votes

Accepted answer
  1. David Browne - msft 3,851 Reputation points
    2020-12-31T16:04:08.21+00:00

    In this configuration you can simply install IIS on the SSAS box, as IIS/Data Pump don't really do much. And as for licensing, you only need to license the SSAS server using core-based licensing.


2 additional answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,376 Reputation points
    2021-01-01T01:43:02.24+00:00

    Hi @Mark ,

    Welcome to Microsoft Q&A forum.

    In my view, David has already given the helpful suggestion.

    You may refer that to do configuration with your needs.

    For more information about SQL Server license, could also refer the pdf.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments

  2. Mark 21 Reputation points
    2021-01-03T21:55:48.387+00:00

    Thanks everyone this indeed does answer my question.

    Cheers,
    Mark

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.