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.
If you are trying to publish the workflow to our Public Gallery at https://gallery.alteryx.com, you wil receive that error because we do not have an ODBC connection created to access your database. The workflow should still upload, but you will only be able to share with others to download the workflow and run on their own computers. You will not be able to run it through the Gallery.
If you are working with your own Private Gallery, verify that you have an System ODBC connection made to the database on the server the Gallery is hosted. It will need to be a System connection for the Gallery to connect.
Thank you for your response. I am trying to publish the workflow in my private gallery.Can you please provide the steps to install the system ODBC for SQL Server on the Alteryx gallery.
I am also trying to publish the workflow on Tableau Server so I am receiving another error that says 'Cannot find macro "PublishtoTableauServer.yxmc" '. How do I update the macro also in the gallery. Please let me know.
I had this problem before. The reason is the machine that houses server should have access to SQL server as well.
So, to fix this, you just need to configure the server/gallery agian. While in the tab Worker, there is a step named Run As.. You can provide your own user name and password so that Alteryx server could have access to SQL server as you do.
This may only apply to conditions that you are using Integrated Windows Authentications as your authentication type.