Content in Tableau Community Forums

tabcmd to publish workbooks with database server name & port as a parameter

tableaucommunity@tableau.com — Thu, 14 Mar 2019 08:24:27 GMT

Hi,

I have created a workbook (.twbx) having some data extracts and some live connections to the SQL Server database.

I am able to successfully publish this workbook on Tableau Server using tabcmd in development environment.

Now my question is how to publish this workbook on Tableau Server using tabcmd on client machines (production) where database server name is different from the development. Seems like during publishing Tableau is trying to make a connection to the database server and throwing error since it could not find that same server (that was used in development). I can pass the database user id and password as parameter in tabcmd but how to pass database server name and port?

Tableau Desktop should be required only during development. It should be not be required for production deployment.

Regards,

Nitin

Tableau refreshextracts tracking

tableaucommunity@tableau.com — Thu, 27 Jun 2013 12:12:30 GMT

Hi,

I changed the Tableau Server configuration to have 2 background processes so that I can run 2 refresh extracts parallel.

I wrote following batch script to run the refresh extracts:

----------------------------------------

tabcmd login -s "http://localhost" -u "userid" -p "password"

tabcmd refreshextracts --workbook "workbook1"

tabcmd refreshextracts --workbook "workbook2"

tabcmd refreshextracts --workbook "workbook3"

tabcmd refreshextracts --workbook "workbook4"

tabcmd logout

----------------------------------------

My question is how to monitor the progress of refresh extracts so that system can automatically:

1. Send an email as soon as all the refresh extracts are completed with status (Error/Success) and time taken by all the refresh extracts.

2. Send an alert/email as soon as any of the refresh extracts fails with reason for failure.

Regards,

Nitin