EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Tableau Commands
Secondary Sidebar
Tableau Tutorial
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Tableau Commands

By Priya PedamkarPriya Pedamkar

Tableau-Commands

Introduction to Tableau Commands

Tableau provides two command-line tools that automate regular tasks. They are tabcmd and tabadmin. All the functions are available directly within the tableau server’s user interface. Tabcmd provides functions that are responsible for adding new users, exporting images and data files. Tabcmd is not installed on the same machine, this flexibility makes highly beneficial from an administrative and scheduling views. Tabadmin is explored for server administration – configuring the server, activating new users, resetting passwords.

What is Tableau?

Tableau is a data visualization software with interactive dashboards which tells us about the storage of data. Tableau’s actual process is to perform an analysis of data by visualization. Humans have used visualization to describe the data in different insights. Easy to use drag and drop interface. It is being used by data scientists, data analysts in many different industries. It allows business users to create their own reports in an easy manner by then reducing backlog reports.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Basic Tableau Commands

The basic commands are as explained below:

  • Start, restart, stop the server

The command is

  1. tsm start
  2. tsm stop
  3. tsm restart
  • To set an Encrypted password

Password encryption credentials are visible in a batch script or power shell. TSM is itself a batch file, to run with it requires CALL command. If the user wants to run the script, has to run the ‘test login’ in power shell.

To set an Encrypted password

Tableau command encrypted password

To get an encrypted file:

encrypted file

To view the credential objects in the encrypted file:

encrypted file2

Getting the password for the batch file.

Getting the password

  • To log in using tabcmd

login

  • Setting Local date

Setting Local date

  • Creating a session

creating a session

  • Creating a group

tabcmd create group “ library dept”

  • Create site users

tabcmd createsiteusers :c:\tc\create user.csv”

csv includes password, username, display name, role, publisher.

  • To remove the project

tabcmd delete project “ library Management”

  • To update data extract

tabcmd refresh extracts –project “ library management” – data source “ no.of books”

  • To check tabcmd dir

Type dir and press enter

Tableau command check tabcmd dir

  • Versions

displays the version information for the current tabcmd utility.

example: tabcmd version

Intermediate Tableau Commands

The intermediate commands are as explained below:

Tableau Services Manager (TSM)

  1. Pending/Apply configurations change

To restart the server and topology changes the command is:

  • tsm pending-changes apply
  1. Change in header logos and log-in

To change the header logo for an image in the path the command is:

  • tsm customize – header – logo <path>

To change the sign-in logo for an image

  • tsm customize – sign in -logo<path>
  1. Default customizations reset
  • tsm customize – restore-defaults
  1. Enabling repository access
  • tsm data-access repository – access enable — repository -username<username> –rep
  1. disabling repository access
  • tsm data-access repository – access disable — repository -username<username> –rep
  1. Data caching configuration
  • tsm data-access caching set –refresh -frequency <value>

<value> option include low, always, 30 or other numerical.

  1. Tsm authentication
  • sspi:

tsm authentication sspi enable/disable [global options]

  • openid:

tsm authentication openid enable [global options]

  • trusted:

tsm authentication trusted configure [options] [global options]

example:

tsm authentication trusted configure -th “192.168.1.100”, “192.168.1.101”, “192.168.1.102”

  1. Tsm data access:
  • caching set

tsm data-access caching set [options] [global options]

option include -r, –refresh

the global option includes -h, -p, -s (help, password, server address)

  • Data access repository

tsm data-access repository-access enable/disable [options] [global options]

option include –repository-username <username> (eg: username as tableau), –request timeout -restart.

  1. tsm licenses
  • It activates tableau server product key
  1. tsm licenses activate –license-key <product-key> [global options]
  • options include -f (licence file), -k (licence key), -t (trial)
  1. tsm licenses deactivate –license-key <product-key> [global options]
  2. tsm license refresh

tsm licenses refresh [global options]

Advanced Tableau Commands

The advanced commands are as explained below:

tabcmd

It is a command line tool, tableau installs this commands to its own folder on the root as c:\drive named tabcmd. We use all these commands in tableau online.

 ex: c:\tabcmd

  1. Adding users to the group
  • tabcmd add users “Development” –users “users.csv”
  1. To create a project

– tabcmd create project – name “Reports” -d “workbook”

-name (name of the project), -d (description of the project)

  1. Generating PDF’s PNG’s from the command line

we need to login to tableau server with tabcmd.

tabcmd login -s http://tableauserver:80 -u admin -p admin ( u and p stands for username and password)

To get a pdf file:

  • tabcmd get /views/ xxx.pdf
  1. To send emails

we have to install email shareware

  • Tabcmd get / views/Wow/xxx.png -f progressReport.png
  1. publish data source
  • tabcmd publish :c:\TC\Sql extracts” -r “TABCMD” -n “Transactions” -db – username “test” –db-password “test” –save -db -password
  1. To get URL
  • It gets the resource from the tableau The result is given in the format of the file.
  • tabcmd get “/views/ lib/ management.png” – ppf “ books return.png”
  1. Schedule
  • To run the specified schedule
  • tabcmd run schedule “ inventory sales refresh”

Tips and Tricks to use

Tabcmd is a window-based tool used to communicate with tableau Server/online via the command line. It is one of the command-line tools that install with tableau server. They are commonly used to automate common content management tasks in Tableau Server. The main tips are they are used to publish content new and to manage it. The versions to be used is essential, tabcmd be the same version as tableau server. The server password is stored in a separate file for additional security.

Conclusion

Tableau commands run on a tableau server itself. There are about calculating the content on the tableau server. Another benefit is we can type these Tableau commands into a script, then we can automate them to many of the processes. We can automatically refresh tasks using Tableau data extract command – this command comes with Tableau desktop, through which we can refresh and append data to them. Those commands don’t work for multi-connection data sources. The main application of tabcmd in the tableau is to automate the downloading of pdf’s in certain dashboards to distribute to the employees through email.

Recommended Articles

This has been a guide to Tableau Commands. Here we have discussed basic, intermediate as well as advanced Tableau Commands along with tips and tricks to use. You may also look at the following article to learn more –

  1. Uses of Tableau | You Should Know
  2. Data Visualization With Tableau
  3. Difference Between Splunk and Tableau
  4. Top 10 Tableau Interview Questions
  5. Information on Splunk Commands
Popular Course in this category
Data Visualization Training (15 Courses, 5+ Projects)
  15 Online Courses |  5 Hands-on Projects |  105+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Tableau Training (8 Courses, 8+ Projects)4.9
Business Intelligence Training (12 Courses, 6+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more