2 of 2 people found this helpful
Tableau Prep outputs data into three formats.
.tde (Tableau extract for versions below 10.5)
.hyper (Tableau extract for versions above/equal to 10.5)
.csv (comma separated value, a flat file format).
You cannot have a "live-query" to your datasource running through Prep.
1: The tde is a "dead" extract. Meaning it has no knowledge of the Prep flow that created it. It just contains an extract of the data outputted from prep.
Publishing to (in my case) my company's Tableau Server allows me to connect directly to the data source in real-time... LIVE data. Yes you can save as you've describe above, but you can publish to a server and with the right authentication, you can publish as live data.
The scenario you describe is not possible with prep since
A: You cannot publish a Prep flow, only the extract it creates
B: Prep cannot create live connections - the tds file points to the .tde or hyper extract that is also created
Thanks for the reply..... So some things have changed over the last few weeks.....
1. I received access to publish on our company's Tableau Server... so creating a flow and publishing it to the server is now possible.
The lead up to the problem....
I connect to our live Oracle database through Flow. Then add-in joins, create unions, clean-up data, etc.... then I create the Output and publish to our company's Tableau Server.
The data I publish isn't live (as you said, it apparently doesn't publish as a .tds file).... I assumed that because my Oracle data comes right out of the live database; when my data refreshed it would be with real-time data... However, it isn't real-time. (i.e. the Flow I published on 5.18 still only has data from that date, nothing new).
I just cannot fathom why Tableau would put out a preparation software that doesn't account for LIVE updating. I'm still green in the Tableau world... but even as a new user... why would any data analyst use Prep if it cannot (in it's fullest form) allow LIVE connections? My time wasn't wasted... my static data did need to be cleaned up... but I feel like I wasted a lot of time using Tableau Prep to manipulate my data the exact way I needed it, only to be told... I guess I just don't understand the specific details of why this would be so difficult to do from a software development perspective.
1 of 1 people found this helpful
What you need is Custom SQL in Tableau Desktop for your use case.