Forums

Dashboard to visualize data from database.

Hi everyone,

I'm trying to connect mySQL database to one of those dashboard where you can visualize your data dynamically, like google datastudio. I read here that the only way to access to database is through SSH, but datastudio doesn't allow you to do this way. Is there anyone who managed to connect its database to google datastudio or another kind of free service like this? I also accept other suggestions of how I can do this.

Thanks

If the service does not support connection via an SSH tunnel, then you cannot use the service to directly connect to your database on PythonAnywhere.

I asked tableau this same question as I use it for work and was planning to create dashboards with my user data. Apparently ssh isnt native to tableau but can be been done via 3rd partys... heres the ssh support and community posts they provided in response

Heres a similar post I just found for Qlik where the person asking the question mentions the putty method, as tableau does above

Qlik

Same for Microsoft (ssh not supported)

Power BI