How can i connect a no-code dashboard to an on-prem database securely?

[LunaS]

I’ve built a pretty complex internal dashboard using a no-code platform, but now my team needs to connect it to our legacy on-premise database for live reporting. I’m hitting a wall because the platform’s native connectors only work with cloud services, and I can’t figure out a secure way to bridge that gap without writing custom middleware, which defeats the purpose of using this tool in the first place. Has anyone else managed to solve a similar problem?

[Aria.S]

We hit the same wall and ended up running a small on prem gateway in a container. The no code tool talks to the gateway over TLS, and the gateway talks to the legacy database inside the network. It adds a little latency but keeps things inside the firewall and lets you keep cloud based auth.

[RyanAP]

We experimented with a VPN backed bridge and a lightweight API layer, but the maintenance felt heavy and we ended up limiting it to read only dashboards.

[Logan3]

Is the real problem the live connection itself, or is the data modelling and schema drift the bigger blocker?

[Kevin14]

There was a moment we chased a on prem data cache idea, but it felt like a Band-Aid. We kept returning to the bridge idea and never nailed the auth story.

[Logan43]

If you want, we can sketch the constraints together: latency, security posture, who needs access, and what the no code tool can actually call.