Alteryx Server-Designer Database connection compatibility.

Question

Hello,
I have workflows where it reads data from oracle database, but when I try to upload the workflow to Alteryx server, it pops an error.

Here’s the situation:

* I need to connect to an Oracle database and then upload the workflow to Alteryx Server.

* On my current machine, I successfully connected to the Oracle database using the ODBC driver downloaded from the Alteryx Portal (Simba driver).

* Similarly, on the virtual machine (VM) hosting the Alteryx Server System Settings, I connected to the same Oracle database, and the connection was also successful.

However, when I attempt to upload the workflow to the Alteryx Server, an error occurs stating that the driver cannot be found.

To troubleshoot, I synchronized the connections between my Designer and the Gallery by navigating to:
Files -> Manage Connections -> Synchronize.

And still no changes happened!

Could you please provide detailed guidance on how to create a compatible connection that ensures workflows with embedded connections can be uploaded to the Alteryx Server without encountering errors?

fmvizcaino · Answer

Hi @Hamza_Abuali ,

Could you please share the error you are having?

As @bryan06 mentioned, it is important to have everything installed on your server. The same steps you had to do in your own machine have to be performed on your server. (Install driver, configure environment variable, tns_names file)

This tutorial is not using DCM, but could give you an idea of what is happening: https://knowledge.alteryx.com/index/s/article/How-To-Connect-to-an-Oracle-Database-in-Alteryx

Best,

Fernando Vizcaino

bryan06 · Answer

have you added the directory path to the system environment variables for Path to make sure that it is recognised? Make sure that the odbc data source is configured with the right connection details. Make sure the oracle odbc driver is installed on the alteryx server, the sytem dsn configured on the alteryx designer are also available to the alteryx server.  Any further issue feel free to reply