The structure, calculated fields, etc. are stored in XML outside of the TDE. If you save the datasource as a "tdsx", it is essentially a zip file with an XML structure and the tde inside. You should be able to unzip it, replace the tde, then rezip it.
Hope this helps!
That is awesome. I've looked at the XML of a workbook before but never a data source. Do you know whether a data source (.tdsx) can be published to Tableau Server via a script? I would assume to (since Desktop is doing it), but I haven't done that myself.
Let me check w/ my IT guys on this...I've been told that there are issues with doing this, but maybe we've simply been doing it wrong. :-) Thanks for your help.
Any luck yet? I've been using SSIS to ALTER VIEW then call tabonlinsyncclient.exe to incrementally refresh and append updated TDE's to tableau online. I've been able to append hundreds of millions of rows this way.
But sometimes there are errors, so I'm looking for alternative methods of automating local TDE updates.
(Note: my source data is sqlsvr, not a csv, and my TDS contains lots of curation I've performed on it, so my TDE updates must come from my TDS xml structure.)
btw - Kosta has a similar question here: https://community.tableau.com/message/473655#473655