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
Best answer by AndrewJDavison_LuhhuView original