If you get the TDSX, the TDE will be packaged with it. Once you have it locally, you can unzip it from the command line, that will create a TDS along a Data folder.
The TDE will be within this folder: Data\Extracts.
Can you advise the scripting to extract the TDE out of a TDSX?
1 of 1 people found this helpful
Depends on the tool you have on your machine. I see Info-Zip already within the Tableau Server bin folder (same place where tabcmd is). If you choose to use it, assuming the TDSX file is located at 'C:\Temp\extract.tdsx', this should work:
unzip -o C:\Temp\extract.tdsx -d C:\Temp
Now the Data folder will be located on your C:\Temp directory, TDE within it.
Thank you so much! This is something I have been working on for the past 5 months and your help has finally allowed me to complete the task!
I needed the TDE as it is from a Microsoft SQL Server extract that I had to append on to Teradata EDW data inorder to have a complete view of inventory.
I am utilizing Tableau server to refresh both SQL Server and Teradata extracts. I use the code in my initial request which downloads the TDSX file from the server on to my local machine. I then Unzip the TDSX using your code. And finally, I AddFileToExtract to append the published Server Teradata extract with the SQL Server rows.
This is fantastic. Thanks again!
Dixon, so glad to hear this! And thanks for sharing the extra context. I didn't realize what the purpose was but now it makes total sense!
With cross-database joins already available on version 10, cross-database unions might be not that far away and that could be another solution to this. While that happens, TABCMD to the rescue!
Can you please tell me how to use the Unzip with tableau ?
I couldn't unzip the tdsx file as it says 'Unzip' is not recognized as an internal or external command. but i have 7zip in my machine so should i install the 7zip inside the Command line utility folder or in the tableau bin directory ?.
Please help me
I tried to unzip the tdsx file with 7zip and i got the tds file instead of tde file.
Is there anyway to extract the tde file out of tdsx file ?
Sorry for the slow reply, I was off the grid for a couple of weeks. If you unzip the TDSX file, you'll see a 'Data' folder on the place where you unzip the file. Within that folder you will find the TDE file.
Hope that helps,