CODEWITHSUNDEEP
azure-synapse
Dinesh Kumar P
Dinesh Kumar P

Reputation: 1178

Can Azure SQL data warehouse (Synapse Analytics) be installed in on-premise?

To store and analyze private data, can Azure Synapse Analytics be installed in their bare metal? i.e. an Azure SQL data warehouse installed in private infrastructure.

Upvotes: 0

Views: 1841

Answers (2)

Martin Cairney
Martin Cairney

Reputation: 1767

Short answer is NO. Azure is not just VMs running in the cloud so how would you expect to run a PaaS system on-premises?

In saying that, you do have options. The on-premises version of a MPP data engine is Microsoft APS. This requires specific hardware and is expensive, but gives the same MPP experience as Synapse Dedicated Pools.

Big Data Clusters may also help to implement what you need. This runs on a Kubernetes cluster which you can easily run on-premises.

Finally - the true way to run Azure PaaS services on-premises WILL be Azure Arc. I say WILL BE as it is still preview and currently only enables Azure SQL Managed Instance and PostgreSQL Hyperscale. There is no guarantee that Synapse will ever be enabled on this platform and if it does come it is still a long way off.

If you are only concerned with the privacy of data then this can be crafted with attention paid to encryption, data masking, use of Azure Managed Identities and RBAC roles, and the use of Private Links to restrict access to specific VNETs

Upvotes: 0

Kashyap
Kashyap

Reputation: 17441

No.

I tried to find some source to quote, but hard to prove a negative. Only things you would find that you can download and install are tools/SDKs to connect to DB/Workspaces in cloud for development, not DB itself.

Upvotes: 1

Related Questions