This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What is the best way to be able to save the results from a workflow so that others can access it and have 'live' data? This would be similar to Tableau. There is an app created where you can export the data to the Tableau server and a user could then create a dashboard and link directly to that path. What are the available options? Would this need to be a data warehouse? Does Alteryx include this feature on the server?
Thanks for the response. Could you please explain that a little more? What we are looking for is being able to save the results from a workflow that would be updated according to a schedule and a user could refer to that file if using Tableau or another analytical program. For this type of project we wouldn't want to export it as an excel spreadsheet because we would want this data to be current. Does the Alteryx server have this capability or would we need to subscribe to another data warehousing type of program?
You would need a separate database. For what you are describing I would not expect that you would need a full Data Warehouse. If it is just a few datasets, then that would only relate to a few tables in a database, and so you could most likely use something free/cheap (PostgreS/MySQL/MongoDB).
In Alteryx, you would just set up a Data Connection for that DB (Options > Advanced > Data Connections) which will act like an ALias so that you can easily write to it from multiple workflows.
It's my guess that data connections shared in the Gallery are really only useful to Alteryx users. Though with Gallery you can place analytical apps out in the public side and create log ins for non-Alteryx users.
Info about sharing data connections in your company Gallery:
If you are storing the output in a standalone database then you can just share the credentials to whoever needs them to connect. If you sole audience consists of Tableau developers then you cold have Alteryx writing to a .tde . Then put the .tde into Tableau Server's Data Sources and control the access to it in the Permissions tab.