Desktop app batch file

DataSelf Desktop has an internal application that can trigger extract refreshes on the Web Server.

To use this method, Desktop needs to be installed on the same server that has the scheduling program (SQL Agent or Windows Task Scheduler). But the DataSelf Web Server can be on another server in the network.

Use the following batch file, changing the red text as needed.

C:

cd \Program Files\DataSelf\DataSelf Desktop 10.0\bin

tableau refreshextract --server http://Server12 --username dataself --password jxyxyx --datasource "SA Sales" --project "Data Sources" --source-username dataself --source-password jxyxy

@echo off

echo 0

@echo on

NOTES

• The third line that starts with "tableau refreshextract" is one long line that ends with the second instance of the password.
• Quotes are needed if there are any spaces in the path or file name
• Use quotes around passwords containing special characters such as &
• 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.
• Repeat the third line as needed for additional data sources.

Example of multiple data sources:

C:

cd \Program Files\DataSelf\DataSelf Desktop 10.0\bin

tableau refreshextract --server http://Server12 --username dataself --password jxyxyx --datasource "SA Sales" --project "Data Sources" --source-username dataself --source-password jxyxy

tableau refreshextract --server http://Server12 --username dataself --password jxyxyx --datasource "GL Transaction History" --project "Data Sources" --source-username dataself --source-password jxyxy

tableau refreshextract --server http://Server12 --username dataself --password jxyxyx --datasource "IN Inventory OH Today" --project "Data Sources" --source-username dataself --source-password jxyxy

@echo off

echo 0

@echo on

Previous      Next