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
Power BI On-Premises Gateway
Azure Data Factory Data Management Gateway
Azure ML and Gateway to get data from on-premises SQL Server
We now have a unified GW: https://azure.microsoft.com/en-gb/blog/on-premises-data-gateway-support-for-azure-analysis-services/
Thanks for the feedback.
I can't use it for Function Apps!! this is a problem for us since Logic Apps has a MAX bytes allowed which means we cannot query for large datasets like in Function Apps
Christos Karras commented
Does the unified GW work with Azure Data Factory too? (no mention of it in the article https://azure.microsoft.com/en-gb/blog/on-premises-data-gateway-support-for-azure-analysis-services/).
Over six months and still no action? Any updates? Would like to use a single gateway.
Has any more been done on this issue?
John Klacynski commented
Agree Gateway mgmt as u scale begins To make cloud a less attractive option
Mike Kostuch commented
Not just AS instances, but all the different toolsets though to be thorough here! THat's the real request. ONe Gateway manager for all Azure toolsets!!!
I was about raise the exact feedback. Please consolidate all the Data Gateways.