5 Replies Latest reply on Sep 3, 2018 12:42 AM by Naveen B

    TABCMD from another machine

    Stefan Stoian

      Hi,

       

      I have a machine with the SQL Server installed on it and another one with the Tableau Server.

       

      I want to put on the SQL Server Job as the last step to a daily refresh to refresh the extracts from Tableau Server.

       

      I just need to access the tabcmd from the second maschine.

       

      Can I do that? and How?

       

      Thanks,

      Stefan

        • 1. Re: TABCMD from another machine
          Ritesh Bisht

          Hi Stefan,

           

          Not sure about the question.

          You need to have Tableau Server installed in the machine where you want to  fire tabcmd command

           

          Thanks,

          Ritesh

          • 2. Re: TABCMD from another machine
            Sankarmagesh Rajan

            hi Stefan,

             

            Install tabcmd in another machine and do the following

             

            Locate the folder that installed tabcmd. pls refer my comments below

             

            tabcmd login with other machines

             

            C:\Program Files\Tableau\Tableau Server\10.5\extras\Command Line Utility

            tabcmd login -s http://172.11.111.111:80 -u Admin -p asdfd@123

            tabcmd export GanttTree/GanttTree --pdf -f "D:\Tableau_Workbooks\Weekly-Reports.pdf"

            tabcmd logout

             

            Thanks

            sankar

            • 3. Re: TABCMD from another machine
              Naveen B

              Hi Stefan,

               

              1) Download the tabcmd of your server compatibility from the below link and Save in your Server where SQL server Installed
              Tableau Server | Tableau Software

              2) Click on the download file --> Run as administrator --> Click Next , Next , Next..

              3) Default location of the tableau command line utility is

               

              C:\Program Files\Tableau\Tableau Server\<Version Number>\Extras\Command Line Utility\

               

              4) Create .bat file with scripts you want to run ( example below will refresh the data source)

               

              CD C:\Program Files\Tableau\Tableau Server\<Version Number>\Extras\Command Line Utility\

              tabcmd login -s <Server Name> -u <User Name> -p <Password> -t <Site ID> --no-certcheck

              tabcmd refreshextracts --datasource datasourcename

              tabcmd logout

               

              5) Schedule job from SSIS using script task or using windows scheduler

               

              Points to remember:

              1) Enable the firewall setting to connect to tableau server by giving inbound and out bound rules in firewall

              2) your tabcmd should be below or equal to tableau server version

              3) While you are scheduling make sure that you pass the location along with CD

               

              Hope this helps

               

              Plz mark this answer as correct and helpful to close the thread

               

              BR,

              NB

              • 4. Re: TABCMD from another machine
                Stefan Stoian

                The solution provided by you worked

                 

                Thanks

                • 5. Re: TABCMD from another machine
                  Naveen B

                  Glad it Helped :-)