Best answer

Access to on-prem SQL server

  • 27 November 2020
  • 1 reply
  • 298 views

Userlevel 2
Badge +1

Hi everyone,

Does Zapier have a way to access on-prem SQL servers? The current function expects a cloud-based SQL with direct IP connectivity but clearly that wouldn’t work for on-prem boxes.

I am looking to a similar mechanics to what Azure/PowerBI does with on-prem database gateway (running on an on-prem VM of course) in order to tap into SQL servers which are not exposed to the public Internet.

Any feedback and ideas will be appreciated. I know I can replicate on-prem tables to Azure Synapse Analytics and/or Azure SQL Data Warehouse and then hit it from Zapier using the stock SQL access function but that’s not the kind of workaround I am looking for :)

Thank you everyone

~B

icon

Best answer by AndrewJDavison_Luhhu 12 December 2020, 16:58

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Hi @bubba198 

Sadly, Zapier is rarely able to handle connecting to on-prem/desktop app setups due to the very nature of how Zapier connects with apps.