community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

HELP!!: Migrating Alteryx workflows From Designer to Server

Alteryx Partner

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?

 

The server is 11.7 same as designer

 

 

@wale_ilori

For the DSN issue:

Is this an In-DB connection or regular input?

Is the DSN set up in ODBC manager exactly the same as well?  Same driver version?

 

 

For the macro issue: was the macro installed on the server the same way it was on your machine?  Is this an app or scheduled workflow?

Alteryx
Alteryx

Hi @wale_ilori

 

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.

 

Publish to Tableau Server install.png

Peter Stoddard
Premium Support Advisor
Alteryx, Inc.