Alteryx server questions

[Yuri24]

Hello,

I am trying to publish my first workflow and getting the below errors when saving a workflow to gallery. Workflow works great in the designer but getting these errors during save. So I suspect that "Crew parallel block until done" and connection to database need to be setup in the server itself. 

Can we add Crew macro pack to a server? Also I don't see an option to add a data connection in the server. Server and designer are on 2020.1. Can someone tell me how does the server add connections look like or adding a macropack look like?

Thanks

[AkimasaKajitani]

Hi @Yuri24 

When you save the Workflow with macro to the Gallery, you have to Manage workflow assets.

And you have to check the macro that you use in the workflow.

Database connections need to be created in advance on the Server.
https://community.alteryx.com/t5/Alteryx-Server-Discussions/Alteryx-Gallery-Database-Connections/td-...

[Yuri24]

Thank you for the response. Output files are currently all csv's in my workflow (stored in my laptop) that serve as input for a tableau dashboard. If I let them stay as csv instead of hyper where are they going to get generated after publishing the workflow? If I change the output destination to a tableau server as a csv would that workflow be able to publish csv's to tableau server directly? 

[AkimasaKajitani]

Hi @Yuri24 

When you run the Workflow at Alteryx Server, the file is outputed on Web interface that can download.

Or you can also output the data to share folder, but you can not output the specific folder on Alteryx Server's storage.
The data will output to Alteryx Server's temporary folder.

If you use the Tableau Server, You can directly publish the data source by the Publish to Tableau Server Tool. I think that this is best solution.
https://help.alteryx.com/current/designer/publish-tableau-server-tool

[Yuri24]

I see, thanks