Last Modified Date: 20 Jul 2023
Environment
- Tableau Server
Answer
Step 1: Download the extract .tdsx file using tabcmd
- On the computer running Tableau Server, open the Command Prompt window as an administrator and run the following command:
cd "
C:\Program Files\Tableau\Tableau Server\packages\bin.<version>"
2. At the command prompt, run the following commands in order:
tabcmd login -s http://<server name> -u <username> -p <password> tabcmd get "/datasources/<extract name>.tdsx"
Step 2: Extract the .tde from the .tdsx file
- Right-click the .tdsx file and then extract all contents.
- Open the extracted folder and open the Data folder to locate the extract (.tde).
Note:
"tabcmd get url" command uses workbook or view id to download the resource. The names of the workbook and view as they appear in the URL are the ids that are used in tabcmd command to download the resource.
However, the id of data source is not displayed in the url similar to workbooks and views. If there are few published data sources with the same name located in in different projects, the url path can not be used to identify the data source id. In that case, the command will only download the data source with the exact id provided in the command.
If there are few published data sources with the same name located in in different projects, to find out data source id, the "tds" file of data source can be opened in a text editor and the "id" value can be extracted from <repository-location> tag in the file.
Example:
a. Two workbooks named "myworkbook" are published to different projects "Default" and "Project1".
b. Navigating to workbooks shows the following URLs:
http://<server name>/#/site/<site name>/views/myworkbook/Sheet1
http://<server name>/#/site/<site name>/views/myworkbook_16191394020850/Sheet1
c. To download these workbooks the id of workbooks are used in the command:
tabcmd get "/workbooks/myworkbook.twb"
tabcmd get "/workbooks/myworkbook_16191394020850.twb"
Both commands download the workbook as "myworkbook.twb" (not myworkbook_16191394020850.twb)
d. Two data source named "myds" are published to different projects "Default" and "Project1".
e. Navigating to data sources show the following URLs. The ids are not displayed in the URLs:
http://<server name>/#/site/<site name>/datasources/23/connections
http://<server name>/#/site/<site name>/datasources/24/connections
f. The following command can be used to download one data source with id="myds":
tabcmd get "/workbooks/myds.tdsx"
g. To download the other data source, its "id" can be retrieved from "tds" file of data source:
<repository-location derived-from='http://<server name>/datasources/myds?rev=1.0' id='myds_16190859777910' path='/t/<site name>/datasources' revision='1.0' site='<site name>' />
h. The retrieved id can be used in the command to download the other data source:
tabcmd get "/workbooks/myds_16190859777910.tdsx"
The data source is downloaded as "myds.tdsx"
Note: If there are other files with the same name the command replaces the file without notification. To avoid this issue specify the path for the downloaded resource.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials