Connecting anvil datatables to external BI tools (like Tableu)

What I’m trying to do:
I want to have better analytics on my anvil datatables.

What I’ve tried and what’s not working:
Most tools (Tableu, BlazeSQL, …) require static connection credentials (I think), but anvil’s are temporary and must be retrieved with

anvil.tables.get_connection_string()

I am parallely trying to use Anvil X and connecting this way, but I am not finding a way to connect the anvil tables to tableau, only to manipulate a tableau workbook using anvil’s python.

Have others tried to do the same? Does anyone have an easy approach? Or is Anvil X the best way forward?

With Anvil X, I just started, but it seems I need an anvil X app, so I connect from that to my main app’s datatables somehow? Again with

anvil.tables.get_connection_string()

or is there a simpler way?

Just trying to get a handle on this. It’s all quite new to me!

We have a couple of ways to support this functionality – we have a direct Tableau connector available for Anvil X customers, and as a dedicated customer we can also arrange static credentials for your database. Drop us a line at support@anvil.works.

1 Like