5 Replies Latest reply on Jun 22, 2016 10:26 AM by Tracy Mixa

    Automated "tableau refreshextract"

    David Saunders

      Hi,

       

      I have a bit of a weird situation here. Our Tableau Server can't see one particular database I'd like to create an extract from because of strict firewall rules, but my work machine can access the database just fine. I can use the "tableau refreshextract" command line tool without issue, but the scheduled extract refresh silently fails for this one particular database.

       

      I'd like to create a batch file or Powershell script that runs "tableau refreshextract" from my machine nightly, but I don't want to store my credentials in plain text.

       

      Is there a way to run "tableau refreshextract" via a script of some sort without having credentials sitting around in plain text? Or is there a simpler way to automatically refresh the extract from a database that our Tableau Server can't talk to directly?

       

      Thanks!

       

      -Dave