I'm trying to understand what you are trying to accomplish with this situation. What is the use case for why you would do this? Is this using Tableau Desktop, Server or both? There are a few words and phrases used that don't quite sync up with Tableau's terminology and I have a few clarification questions.
In the phrase "...create a .TDE file for each request..." what do you mean by "request"? A .TDE file is a Tableau Data Extract that contains data extracted from a database and is created by the user in Tableau Desktop or during extract refresh processes on Tableau Server.
in the phrase "...use one predefined workbook..." what do you mean by "predefined"? Like a template? While you could swap data sources in a workbook using Tableau Desktop, unless the underlying structure of data is 100% identical, it will produce errors.
It may be more useful to approach this issue from a "what are I trying to accomplish?" standpoint then a "here is the exact task I need to do but don't know how". What's your goal here?
We are planning to create a UI where users can request what fileds that they want in final dashboard(for ex, merchant name,city,state,spend)
Please consider this as one request with (merchant name :ABC ,city: denver ,state:CO,spend:$10). In the backend we pull the data from Hadoop and create a .tde file using Tableeau data extract API.
I have a workbook created with all these fields and saved.
Please assume that fields are always same in my dashboard for all these requests.
Our goal is we may get 100 requests for different merchants and want to create 100 .tde files and use these .tde files to use the same workbook and export dashboard to pdf…
Hope this is clear
Additionally, the Developer Portal may be better place to post this inquiry or search for help. Developer Forums
One more possibility, you could gain this functionality using a workbook with filters that would change the view dynamically with the users' requests, but given that Hadoop is being used, there may be a large set of data that causes this process to be too slow. This is a link to an extremely simple version but basically, someone could select each option from a drop-down menu in a workbook and then the view would adjust based on those filters. Creating a Sheet Selector for a Dashboard | Tableau Software
Hope this helps!
I found this nice video that partially answers your question: Tableau Tutorial: Automated PDF Report Creation in Tableau Desktop (Part 2) - YouTube
Unfortunately, Tableau does not provide a way to programmatically export to PDF (without Tableau Server at least) but I'd do something like this:
- Create a template where you can substitute path to TDE in workbook's XML. This step is pretty easy in any scripting language.
- Use tableau.com executable to print to default system printer - this can in theory be a PDF printer!
Maybe it won't be so bad. I didn't try
Thanks for the details
We have a tableau server environment and if there is way to achievable using tableau server please share the details