Run HANA in Gallery

Question

I have a workflow that needs to be run from Gallery.

The input is database connection to HANA.

however when I uploaded and run it I get an error.

It runs just fine when I run it from the desktop however from Gallery it fails every time.  I'm sure I have not set up the input right or I am missing something.

Any help would be greatly appreciated.

TXULarry · Answer

Thank you for your response.  Based on your reply my assumption is that Gallery is on an Alteryx server.  If that is the case, I'm understanding that even though I have the ODBC driver set up on my personal desktop computer, I would have to ensure that the ODBC driver is set up on the Gallery?

But I do have another question in regards to your message, what is "same name" is referring to?  I'm guessing it is the field "Connection Name" found in the "Manage Connections" options for the "Connect In_DB" tool?  See Screenshot 1.

If that is the case this comes from the data source settings, see Screenshot 2, does this mean I have to set up 2 data source settings, 1 on my computer and 1 on server, that have the same name and configuration in order for this to work?

Screenshot 1

Screenshot 2

AkimasaKajitani · Answer

Hi @TXULarry

Does your server that Alteryx Server run appropriately install the ODBC driver for SAP HANA and create the connection as the same name of your local machine?