How can we improve Microsoft Azure Analysis Services?

Create a Data Gateway Manager to be used for all Cloud Services (to consolidate all other data gateways)

Currently we have these gateways, all of which require a separate VM/Machine to install for the scenario where we have in data sources on-premises (hybrid scenario). This is way too many gateways and who knows how many more we will have in the future. It takes maintenance and up-keeping of data sources, passwords, latest version installation, etc.

We should consider consolidating all gateways into a Gateway Manager where we can manage all of them on one machine/VM location. This way, we can check for versions, login/passwords, data sources, etc. and can potentially reuse data sources (shared data sources) for different consuming cloud services. We can also test for connectivity issues in one place and perhaps troubleshoot in one place as well. We can even have HA OR scale out the gateways by having multiple machines/VM clustered or participate in NLB (network load balance) solution.

• SSAS as a Service gateway
• Power BI on-premises gateway
• ADF (Azure Data Factory) gateway
• Azure ML data gateway

SSAS as a service On-Premises Gateway
https://azure.microsoft.com/en-us/documentation/articles/analysis-services-gateway/

Power BI On-Premises Gateway
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/

Azure Data Factory Data Management Gateway
https://www.microsoft.com/en-us/download/details.aspx?id=39717

Azure ML and Gateway to get data from on-premises SQL Server
https://azure.microsoft.com/en-us/documentation/articles/machine-learning-use-data-from-an-on-premises-sql-server/

83 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Binh Cao shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

7 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base