Tableau Report Extraction Prerequisites
This topic briefs about the Tableau report extraction prerequisites.
In This Topic:
Introduction
LeapLogic’s Assessment profiles existing inventory, identifies complexity, draws lineage, and provides comprehensive recommendations for migration to the modern data platform.
LeapLogic requires Tableau report in the TWB format to perform an assessment. See the following options containing the steps to achieve the same.
Option#1 Using Command Line (Bulk download)
Follow the below given steps to export the Tableau reports using command line.
As a prerequisite, you need tabcmd. If you do not have it, use this link to download it: tabcmd (tableau.github.io)
tabcmd login -s “http://myserver.company.com” -u “terkson” -p “passwordGoesHere” – – no-certcheck – – timeOut 6000
tabcmd get workbooks.xml -f “C:\temp1\workbooks.xml”
$xml = [ xml ] (Get-Content “C:\temp1\workbooks.xml”)
Foreach ($workbook in $xml.workbooks.workbook) {Write-host “Getting: ” $workbook.name; tabcmd get /workbooks/”$($workbook.’repository-url’).twb” -f “C:\temp1\$($workbook.’repository-url’).twb” – – no-certcheck}
tabcmd logout
exit
Option#2 From Local or Desktop (Single file at a time)
Follow the below given steps to export the Tableau reports.
- Open a Tableau Workbook on your local machine or Desktop.
- Select File > Save As.
- Select the path where you want to save the file.
- Save as Tableau Workbook (*.twb)
Option#3 From Tableau Server (Single file at a file)
Follow the below given steps to export the Tableau reports using Tableau Server.
- Login to Tableau Server.
- Select the Workbook which you want to export.
- Download as Tableau Workbook in(* .twb) format
Option#4 Using Command Line (Single file at a file)
Follow the below given steps to export the Tableau reports using Tableau Server.
As a prerequisite, you need tabcmd. If you do not have it, use this link to download it: tabcmd (tableau.github.io)
- Login using this command.
tabcmd login -s < https://online.tableau.com > -t mysite -u authority@email.com -p password
- You can execute using this command.
tabcmd get “/workbooks/Sales_Analysis.twb” -f “C:\Tableau_Workbooks\Weekly-Reports.twb”
It is recommended to export Tableau Workbook using one the above mentioned options or methods. This will help you to export them in the required .twb format.
Getting Help
Contact LeapLogic technical support at info@leaplogic.io
Leaplogic