Has anyone come up with a way to connect to an on premise server?
Thanks!
Unfortunately I don’t think there is a single or simple answer. The solution has to involve the on-prem server being exposed to the internet in some way, which will require the approval and coordination with your security and IT teams.
A modern approach is to use a “Zero Trust” access model, where access to a service is always based on credentials vs the network the device is on. In the past I created a POC for connecting to an “internal” endpoint protected by Google Cloud’s Identity Aware Proxy, but every cloud provider has a different way of authenticating these requests.
The simpler path (at least approval wise) is usually to build out an internal application that can regularly export a subset of the data to a non-internal location (a Google Sheet, AWS bucket, Coda doc, etc).
2 Likes
So if we’re hosting Tableau on premise, we would need to create/ use something like this as an in between, there wouldn’t be a way to connect them directly, right?
You’ll certainly need to bring in some other component, but as mentioned there are various paths. If your application is on an internal network, and not accessible from the internet, you’ll need to build some sort of bridge over the network firewalls that separate them.
1 Like
I run an n8n instance locally that syncs our mssql into coda docs