Automatically run Alteryx Workflow & Refresh Tableau Extract + Published Dashboard
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community,
Is there a way to automate my workflow to run daily so that it can update the extract in Tableau and the published dashboard without having a Server license? My job currently has a Tableau server which I'm trying to utilize as much as I can. Ultimately, after reading through several discussions, I'm realizing since the data source is in Alteryx, there's no way for Tableau to run my workflow. Alternatively, I've tried Windows Task Scheduler but nothing seems to happen. I'm assuming Alteryx blocks SSO and Windows Task Scheduler jobs without a Sever license?
I was able to get a Personal Access Token from Tableau in which I can enter it into the "Tableau Output" tool in Alteryx. But I don't see that working out either.
My Alteryx workflow saves the data in .tde format with the "Output Tool". Once it saves, I have to manually open Tableau and it automatically refreshes the data. But then I have to re-publish the dashboard everyday.
Below is my Designer specs:
Alteryx Non-Admin Designer
Version: 2021.3.1.47945
Running Non-Elevated
Below are my Tableau specs:
Tableau Professional Edition
2020.4.1 (64-bit)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I believe you can run desktop designer using the desktop scheduler. This comes with it's sown set of nuances though.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Seems like I would need to Designer + Scheduler license for this. 😞 We only have the Designer license.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My first workaround would be a python script:
But even that's going to require an additional license.
Alteryx Server / Desktop Scheduling is awesome to work with but when your Organization doesn't have either yet it can be very frustrating.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am sailing in the same boat. We have just Designer licenses and I need to automatically trigger the workflows for the data to be updated in tableau extract.
Was there any workaround found for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Still trying to find a solution..
You would have to run your workflow manually and then have it output to your Tableau server.
Attempts so far:
To automate (or attempt to), you can follow the below link about creating a .vbs script. Then create a .bat file that would trigger your .vbs script. It’ll be
“execution path” “file location path”. Then put your .bat file into windows task schedule and schedule it.
I attempted this on a virtual machine while I was logged off the server. Unfortunately, it runs with no errors when I’m logged off but my alteryx workflow just doesn’t run. It runs in all my attempts when the .bat or .vbs is ran manually when logged in.
Then attempted the python script (also in that link) but encounter a GUI error.
Then attempted keystrokes to be able to run my workflow through Windows task schedule. No luck
All possible things you can try. Hoping you have better luck!
