SAP Hana and Alteryx Server Issues

Question

Has anyone had any issues with publishing an SAP Hana connected workflow to an Alteryx Server? We are not using Windows Auth but instead, the SAP Hana studio prompts the user for username and password. Every time I try to publish a workflow with it fails on the server.

* Yes, I have the correct ODBC driver on the server VM 
* The local machine does not have access the SAP Hana database but we can prompt it with a username and password.

DiganP · Answer

@sfadel It seems like you are using MFA support for SAP Hana. With MFA, you are promoted to enter in your username/password. This method of authentication cannot be enabled on the server as you need to enter the user/pw for the workflow. You can only run workflows on the server with active directory or username/password based authentication methods.

Hope this helps.