My Oracle OCI database connection tool input ran with no issues in Alteryx Designer. When I tried to set up a Managed Data Connection on server, the database connection produces a validation error and the workflow fails to run on the server. I've included a screenshot of the error. Please advise. Thank you.
If you want to publish a workflow to the Server that uses a database connection you have two options. Either replicate the same connection settings from your machine (drivers, DSN, TNS file) on the Server or create the connection on the Server, create a Gallery Connection and share that with the Designer user.
All this that I mentioned needs to be performed by the Server administrator. If you’re not the admin, please ask the admin to create the connection for you.
