All Anvil apps, including Tableau Extensions built with Anvil X, have a built-in database called Data Tables. You can connect your extension’s Data Tables as a data source in Tableau.
To do this, open the Anvil X configuration in the left-hand sidebar of the Anvil Editor:
Scroll down to “Access your Data Tables from Tableau”, and click Enable:
You will now see the authentication details required to access your extension’s Data Tables from Tableau:
Now, you can add your app’s Data Tables to your Tableau dashboard as a Postgres data source. Follow Tableau’s instructions to add and query the data source.
If you have published your extension, it’s possible you are using separate databases for your personal testing and for your deployed extension. Anvil will offer you connection details for both testing and published versions of your extension:
In order to make sure that your Tableau dashboard sees the correct data, make sure that dashboards using the testing version of your extension use the testing password, and dashboards using the published version use the published password.
Learn more about testing vs published versions of your extension.
Do you still have questions?
Our Community Forum is full of helpful information and Anvil experts.