There is no way to write back in the database with Tableau, however you could use URL actions that submit the wanted values to a PHP Web Service. The latter will insert those values into the database. You have a great example of the PHP code for this here, from Aaron Clancy - Re: Can Tableau write data back to the data source?
Do I need to load the dashboard with the extension to the SQL Server (Beta) first and call the REST API for the underlying metadata?
That would be the best way to proceed. have you tested this yet?
Do you have an error when you try to submit?
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
1 of 1 people found this helpful
I'm confused. One of the main benefits of the new Extensions API touted at TC17 was the write-back functionality it would allow. Also, on the product page here it specifically says:
With our Extensions API, developers can create dashboard extensions that enable customers to integrate and interact with data from other applications directly in Tableau.
- Create an extension that has write-back functionality, so users can modify data in a viz and have that change automatically update the source data in the data base or web application
- Build custom viz and interactivity types such as a filter replacement with a custom interface and network diagram
- Integrate 3rd party functionality inside the dashboard
- Interact with data from other business applications directly in Tableau
- Customize Tableau's Desktop environment for a specific team's workflow
Level of Support: Tableau-supported once released
This is new territory so I would recommend contacting Tableau Support. These forums are not Tableau Support, they are supported predominantly by volunteers.
You are correct, with the new Extensions API you will be able to create an extension that enables your users to write back to a database or file. The method (JS, PHP etc.) is up to you once your user hits submit. I found a write back extension (currently in development) written by Andre de Vries that writes back data to a text file. Not exactly your use case but hopefully it can get you going in the right direction!