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.
Does anyone have a good compendium of moving workflows from Alteryx designer to run on the alteryx server?
I'm finding a current migration of content rather frustrating with all the Error SQLDriverConnect:[Microsoft][ODBC] Datasource name not found and not default river installed. Why does this happen even though we are using the Alteryx's gallery's connection to connect to the data? I got the admin to setup the connection with the same DSN name and credentials from the server and I built a workflow using that but get an error publishing even that.
I've seen some documentation that points to making an indbc file for the connection but found no instructions on how to create this and don't seem to find anything on the youtube channel either.
Then there's the macro not found issue for publishing to Tableau Server using the macro.
Not being the admin of the server does not help wither so my ask is are there any recommended articles or blogs that talk about the typical hurdles to migrating workflows from desktop to server?
Another thing to consider, if using database connections made through the Gallery, also make sure that the Gallery Connection(s) is also shared with the Run As User.
As for the Publish to Tableau Server macro if you are able to log on/remote desktop to the server or Have your Admin go out to the Alteryx Public Gallery, sign in and donwnload the 'Publish to Tableau Server' macro. Follow the instructions on the page to download the macro and ensure the correct version of the macro is downloded for the version of Alteryx being used.
If using Chrome the file should download as a .yxi. We've seen if using Internet Explorer the file may download as a .zip. If you get a .zip file rename the resulting downloaded file so that it has a .yxi extension. Then double click the file to install the macro. Ensure that the option for 'Install for All users' is selected, as this is the recommended option when installing the macro on a Server environment. Installing a .yxi tool for all users makes it easier for users to schedule workflows and run workflows from the Gallery. This should resolve the issue related to macro not found. Take a look here for more info on the .yxi installation file type.
Peter Stoddard Premium Support Advisor Alteryx, Inc.