Hi community,
I currently face a problem with one of my customer's requirement.
He asked me to allow the Tableau users to send data displayed in a dashboard to a third party database.
The use case would be the following:
1. A Tableau user will be presented with a set of elements based on his permissions
2. The user will have the possibility to apply a set of Tableau filters to refine more precisely his scope
3. Then he will click on a button/link/whatever in the Tableau UI to “pass” (automatically) those elements to the target system for further processing.
I already imagined some solutions but none is really satisfying:
- Using Tableau URL action to call a service, passing the filters values as parameters of that URL. Unfortunately, there is too many filters and too many available values for each.
- Embed Tableau dashboards in a HTML page, filters and the transfer action would have been managed in the page, not in Tableau. The transfer management would be easier but with a huge rework ahead.
If any of you has a better idea, I'll take it!
Hi Diego,
Thanks for your answer.
The problem of using a URL action is that we can only pass single values in its parameters and not a list of values (maybe I'm wrong on that point, though).
for instance, the call would be :
http://mywebserver/pages/insertscript.php?Country=<Country>&BU=<BU>&Brand=<Brand>&Range=<Range>&...
with <Country> as the country selected in filters, <BU> as the Business Units, and so on.
The problem is that my filters are (and have to be) multiple values filters.
Since I wrote my first note, I thought twice about the second solution (embed Tableau dashboard in a web page), using Tableau API, and I think it should be the best solution.
For those interested, I was given a link to an interesting blog post explaining how I could do:
http://themarkscard.com/2016/08/11/exporting-viz-data-with-the-tableau-10-javascript-api/
Thanks again for your time.
- Greg
