Hi Tushar -
Tableau has a command-line utility that you can use to refresh extract and publish to server. Once you build the script you can run it with a scheduler.
To be able to refresh the extract Tableau needs to be able to access the source file. One possibility that would still require a little manual work but less would be to make copies of the files from the shared drive to your computer. Use those files as the source files for the report and then publish the report and extracts to Tableau Server. All you would have to do now is make sure to replace the files on your desktop with the new files on the shared drive when they're created. If you keep the file names exactly the same then it should refresh directly from the files on your computer without you needing to open up Tableau Desktop again.
Thanks for sharing the link!!
What I understand here is that "tableau refreshextract" is used to refresh an extract on Tableau Server. But I want to refresh the extract at Tableau Desktop level and then publish it on the server as the server can't connect to the files stored at shared path or local drives.
Current refresh process I am using is, Open workbook and click on Data >> Extract >> Refresh. After this I publish the workbook on server.
I think publish part can be achieved using tabcmd. But refreshing the extract seems to be the challenge here without connecting to the server.
I hope it clarifies my requirement.
Tableau command line "tableau refreshextract" is available for Tableau desktop.