Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
          • LeapLogic Express
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
        • LeapLogic Express
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • Script/ Query Log/ Code Extraction Prerequisites
    • Cloud
      • Azure Data Factory
      • Snowflake
      • Azure Synapse
      • Google BigQuery
      • Redshift
      • Azure SQL Database Hyperscale
      • Aurora PostgreSQL
    • EDW
      • Oracle
      • Netezza
      • Teradata
      • Vertica
      • SQL Server
      • Db2
      • MySQL
      • PostgreSQL
    • ETL
      • DataStage
      • Informatica
      • SSIS
      • Talend
      • ODI
      • IICS
      • DBT
      • Pentaho
      • Matillion
      • SnapLogic
      • Ab Initio
      • SAP BODS
      • TAC
      • WebFOCUS
    • BI
      • IBM Cognos
      • OBIEE
      • Tableau
      • Metabase
      • MicroStrategy
      • PowerBI
      • LeapLogic Utility for SAP BO
      • SAP BO Universe and Web Intelligence
      • SSRS
    • Analytics
      • SAS
      • Alteryx
    • Orchestration
      • AutoSys
      • Control-M
      • SQL Server
    • Mainframe
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 4.9) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  Script/ Query Log/ Code Extraction Prerequisites   »  BI  »  Tableau Report Extraction Prerequisites

Tableau Report Extraction Prerequisites

This topic briefs about the Tableau report extraction prerequisites.

In This Topic:

  • Introduction
  • Tableau Workbook (.twb files) Extraction
  • Tableau Data Source (.tds files) Extraction
  • Getting Help


Introduction

LeapLogic’s Assessment profiles existing inventory, identifies complexity, draws lineage, and provides comprehensive recommendations for migration to the modern data platform.


Tableau Workbook (.twb files) Extraction

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 Tableau Server Client (TSC) for Bulk download

Follow the below given steps to export Tableau workbooks using TSC.

Install TSC. As a prerequisite, install Python on your system. You can use TSC with Python 3.7 or later. Also, install Git which is optional but recommended to download the samples.

Install TSC with pip (recommended) or from the source code.

Run the following command to install the latest stable version of TSC:

pip install –upgrade pip

pip install tableauserverclient

If you want to install TSC from the development branch or on an offline machine without an internet connection, please see the steps here.

Run the following code to download all the required workbooks:

import tableauserverclient as TSC

tableau_auth = TSC.TableauAuth(‘username’, ‘password’, site_id=’site’)

server = TSC.Server(‘https://servername’)

with server.auth.sign_in(tableau_auth):

     all_workbooks_items, pagination_item = server.workbooks.get() 

     # print names of first 100 workbooks

     #print([workbook.name for workbook in all_workbooks_items])

     for workbook in all_workbooks_items:

         workbook_id = workbook.id          workbooks.download(workbook_id, filepath=None, no_extract=True)

Option#2 Using Command Line (Bulk download)

Follow the below given steps to export the Tableau reports using command line.

Connect to the Postgres Workgroup database with user ID readonly or tableau. Copy the below query and execute it.

SELECT workbook_url FROM _workbooks;

Export the output of the above query to a file and name it as input.txt

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 “userid” -p “********” – -no-certcheck – -timeOut 6000

#Create a folder in your directory namely “temp” and place the input.txt #file on that location.

$filePath =”D:\temp\input.txt”

#Create a folder within the temp folder namely “workbooks”.

$workbookpath=”D:\temp\workbooks”

New-Item -Path “$workbookpath” -ItemType Directory -Force

cd $workbookpath

foreach ($line in Get-Content $filePath) {

   #Write-Host “/workbooks/$line.twb”

   tabcmd get “/workbooks/$line.twb” –no-certcheck            

               }

tabcmd logout

Next, go to the location where you’ve saved the Workbooks. Execute the below command to extract .twb files out of the workbooks. Once this is done, please share the .twb files with the LeapLogic team for assessment.

# Set the path to the folder containing .twbx files

$folderPath = “D:\temp\workbooks”

# Define the destination folder for extraction

$extractionFolder = “D:\temp\workbooks\extracted”

# Define the folder to move the .twb files to

$twbDestinationFolder = “D:\temp\workbooks\twbfiles”

# Create folders if they don’t exist

if (-Not (Test-Path -Path $extractionFolder)) {

    New-Item -ItemType Directory -Path $extractionFolder

}

if (-Not (Test-Path -Path $twbDestinationFolder)) {

    New-Item -ItemType Directory -Path $twbDestinationFolder

}

# Get all .twbx files in the folder

$twbxFiles = Get-ChildItem -Path $folderPath -Filter “*.twbx”

foreach ($twbxFile in $twbxFiles) {

    # Rename .twbx to .zip

    $zipFilePath = $twbxFile.FullName -replace “.twbx$”, “.zip”

    Rename-Item -Path $twbxFile.FullName -NewName $zipFilePath

    # Extract the .zip file

    Expand-Archive -Path $zipFilePath -DestinationPath $extractionFolder -Force

    # Locate the .twb file

    $twbFilePath = Get-ChildItem -Path $extractionFolder -Filter “*.twb” | Select-Object -First 1

    # Check if .twb file was found

    if ($twbFilePath) {

        Write-Host “The .twb file has been extracted to: $($twbFilePath.FullName)”

        # Move the .twb file to the new destination folder

        Move-Item -Path $twbFilePath.FullName -Destination $twbDestinationFolder -Force

        Write-Host “Moved .twb file to: $twbDestinationFolder”

    } else {

        Write-Host “No .twb file found in the extracted contents for: $($twbxFile.Name)”

    }

    # Clean up: Remove the .zip file

    Remove-Item -Path $zipFilePath -Force

    # Optional: Clear the extraction folder for the next iteration

    Remove-Item -Path $extractionFolder -Recurse -Force

}

# Get all .twb files in the source folder

$twbFiles = Get-ChildItem -Path $folderPath -Filter “*.twb”

# Move each .twb file to the destination folder

foreach ($twbFile in $twbFiles) {

    Move-Item -Path $twbFile.FullName -Destination $twbDestinationFolder -Force

    Write-Host “Moved: $($twbFile.FullName) to $destinationFolder”

}

Option#3 Using Command Line (Bulk download)

Follow the below given steps to export the Tableau reports using command line.

As a prerequisite, you need tabcmd v2.0.14. 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 list workbooks –details

tabcmd logout

Save the output of this command with the name workbooks.xml.

tabcmd login -s “http://myserver.company.com” -u “terkson” -p “passwordGoesHere” – -no-certcheck – -timeOut 6000

#Create a folder in your directory namely “temp1” and place the #workbooks.xml file on that location.

$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#4 From Local or Desktop (Single file at a time)

Follow the below given steps to export the Tableau reports.

  1. Open a Tableau Workbook on your local machine or Desktop.
  2. Select File > Save As.
  3. Select the path where you want to save the file.
  4. Save as Tableau Workbook (*.twb)

Option#5 From Tableau Server (Single file at a time)

Follow the below given steps to export the Tableau reports using Tableau Server.

  1. Login to Tableau Server.
  2. Select the Workbook which you want to export.
  1. Download as Tableau Workbook in(* .twb) format

Option#6 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)

  1. Login using this command.

tabcmd login -s <https://online.tableau.com> -t mysite -u authority@email.com -p password

  1. You can execute using this command.

tabcmd get “/workbooks/Sales_Analysis.twb” -f “C:\Tableau_Workbooks\Weekly-Reports.twb”

Note:

Edit the path and file name in the above command as required.

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.


Tableau Data Source (.tds files) Extraction

LeapLogic requires Tableau report in the TDS format to perform an assessment. See the following options containing the steps to achieve the same.

Using Command Line (Bulk download)

Follow the below given steps to export the Tableau data sources using command line.

Connect to the Postgres Workgroup database with user ID readonly or tableau. Copy the below query and execute it.

SELECT name FROM _datasources;

Export the output of the above query to a file and name it as input.txt

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 “userid” -p “********” – -no-certcheck – -timeOut 6000

#Create a folder in your directory namely “temp” and place the input.txt #file on that location.

$filePath =”D:\temp\dsinput.txt”

#Create a folder within the temp folder namely “datasources”

$datasourcepath=”D:\temp\datasources”

New-Item -Path “$ datasourcepath ” -ItemType Directory -Force

cd $ datasourcepath

foreach ($line in Get-Content $filePath) {

   #Write-Host “/datasources/$line.tdsx”

   tabcmd get “/datasources/$line.tdsx” –no-certcheck            

               }

tabcmd logout

Next, go to the location where you’ve saved the Data Sources. Execute the below command to extract .tds files out of the data sources. Once this is done, please share the .tds files with the LeapLogic team for assessment.

# Set the path to the folder containing .tdsx files

$folderPath = “D:\temp\datasources”

# Define the destination folder for extraction

$extractionFolder = “D:\temp\datasources\extracted”

# Define the folder to move the .tds files to

$tdbDestinationFolder = “D:\temp\datasources\tdbfiles”

# Create folders if they don’t exist

if (-Not (Test-Path -Path $extractionFolder)) {

    New-Item -ItemType Directory -Path $extractionFolder

}

if (-Not (Test-Path -Path $tdsDestinationFolder)) {

    New-Item -ItemType Directory -Path $tdsDestinationFolder

}

# Get all .tdsx files in the folder

$tdsxFiles = Get-ChildItem -Path $folderPath -Filter “*.tdsx”

foreach ($tdsxFile in $tdsxFiles) {

    # Rename .tdsx to .zip

    $zipFilePath = $tdsxFile.FullName -replace “.tdsx$”, “.zip”

    Rename-Item -Path $tdsxFile.FullName -NewName $zipFilePath

    # Extract the .zip file

    Expand-Archive -Path $zipFilePath -DestinationPath $extractionFolder -Force

    # Locate the .tds file

    $tdsFilePath = Get-ChildItem -Path $extractionFolder -Filter “*.tds” | Select-Object -First 1

    # Check if .tds file was found

    if ($tdsFilePath) {

        Write-Host “The .tds file has been extracted to: $($tdsFilePath.FullName)”

        # Move the .tds file to the new destination folder

        Move-Item -Path $tdsFilePath.FullName -Destination $tdsDestinationFolder -Force

        Write-Host “Moved .tds file to: $tdsDestinationFolder”

    } else {

        Write-Host “No .tds file found in the extracted contents for: $($tdsxFile.Name)”

    }

    # Clean up: Remove the .zip file

    Remove-Item -Path $zipFilePath -Force

    # Optional: Clear the extraction folder for the next iteration

    Remove-Item -Path $extractionFolder -Recurse -Force

}

# Get all .tds files in the source folder

$tdsFiles = Get-ChildItem -Path $folderPath -Filter “*.tds”

# Move each .tds file to the destination folder

foreach ($tdsFile in $tdsFiles) {

    Move-Item -Path $tdsFile.FullName -Destination $tdsDestinationFolder -Force

    Write-Host “Moved: $($tdsFile.FullName) to $destinationFolder”

}



 
Getting Help

Contact LeapLogic technical support at info@leaplogic.io


To learn more, contact our support team or write to: info@leaplogic.io

Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

  • Terms of Use
  • Privacy Policy
  • License Agreement
To the top ↑ Up ↑