Tabcmd batch file

DataSelf Web Server has Tabcmd.exe, a stand-alone application that can trigger the extract refresh.

If the scheduling program is not on the same server where DataSelf Web Server is installed, the Tabcmd.exe will need to be separately installed on the server with the scheduler.

The Tabcmd batch file

Change the red text as needed.

REM make sure there are no spaces at the end of the line

REM Set directory to DataSelf Web Server bin folder or other folder where tabcmd.exe is installed

C:

cd ..\..

cd \Program Files\Tableau Server\Tableau\10.0\bin

REM login to DataSelf Web Server. Enter URL and admin credentials

tabcmd login -s http://Server12 -u "dataself" -p "NewPassword"

REM list extracts to refresh

tabcmd refreshextracts --datasource "SA Sales"  --project "Data Sources"

tabcmd refreshextracts --datasource "SO Sales Order"  --project "Data Sources"

tabcmd refreshextracts --datasource "IN Transaction History"  --project "Data Sources"

REM Logout from server. Required for stability.

tabcmd logout

REM unremark Pause to see the CMD box messages, for troubleshooting

REM Pause

NOTES

• Quotes are needed if there are any spaces in the path or file name
• Use a DataSelf Web Server administrative user.
• The batch file can be converted to an encrypted exe. In which case, after converting to exe, in the bat file edit out the real passwords, but save the bat file for reference.
• Create or edit batch files in Notepad, saving it as a bat file instead of txt.

Tableau help gives the following instructions for installing Tabcmd.exe:

By default, the tabcmd command line utility installs with Tableau Server to the server's bin folder (for example, C:\Program Files\Tableau\Tableau Server\10.0\bin). You can run it from there. For administrative flexibility, you can also install it on other computers.

If you installed the tabcmd command line utility on computers that are not running Tableau Server and you are upgrading Tableau Server to a new major version (version 9.3 to version 10.0 for example), Tableau recommends you also upgrade standalone installations of tabcmd to avoid any potential incompatibilities between versions.

To install tabcmd on another machine:

1. Navigate to the extras folder on Tableau Server:

C:\Program Files\Tableau\Tableau Server\10.0\extras\TabcmdInstaller.exe

2. Copy TabcmdInstaller.exe to the computer where you want to install it.
3. Double-click TabcmdInstaller.exe to run it.
4. Follow the prompts to install tabcmd.

Because tabcmd is a command line tool, and due to some limitations with the Windows operating system, Tableau recommends that you install tabcmd in a folder named tabcmd at the root of the C:\ drive (C:\tabcmd).

Note: Running the tabcmd Setup program does not automatically add tabcmd to the Windows PATH variable, you will need to either explicitly call tabcmd using its full path or add its directory to the PATH variable.

Previous      Next